Re:PostgreSQL Scalability: Towards Millions TPS
by ap22213 on Tuesday May 10, 2016 @08:33AM
(#11666721)
Totally agree. In 95% of the cases, you won't go wrong starting with PG.
Re:PostgreSQL Scalability: Towards Millions TPS
by frostymarvelous on Wednesday May 11, 2016 @03:52AM
(#11673382)
Funny. I just said the same thing before reading your comment.
Somehow that makes me feel better that at least, I'm on the right path.
An abstracted interface for your datalayer is a must have.
Many startups and projects begin with a single db and grow into new dbs as the business requirements change.
Obviously if you know your data model well enough you can foresee a lot of these requirements and pick the right tool for the job.
However, you will usually need to pick a db to start with and hope that it will accommodate as many of those unknowns as possible.
I believe that Postgres is the best choice in that scenario, as it is extremely mature and has an incredible amount of flexibility.