Room: Medici III
At Adspert we store and analyze more than 3 TB of data in PostgreSQL databases. By separating each customers data into its own database we can scale very well horizontally. I will talk about the benefits and challenges of that approach as well as how we came to adopt it and why we chose it above alternatives.
Additionally, we rely a lot on SQL for gaining deep insight into the data and we use SCHEMAs a lot for versioning our database code. I will expand on how we manage this and how we integrate schema changes into the software development process.