Scaling out relational data models, and SQL, through co-location

Re:Scaling out relational data models, and SQL, through co-l... by andy_ppp on Saturday December 24, 2016 @03:17AM (#13249076)

I assume he wants a proper database and to be honest if you have zero interaction between the things you are partitioning on it's very easy to scale with SQLite or any other database.

There's no reason you can't either run more servers or multiple instances of postgres per server, with docker or otherwise.

I'm probably going to try using Citus Data instead of moving to Cassandra if I ever get big. We'll see.

[ Parent | on HN ]

Re:Scaling out relational data models, and SQL, through co-l... by unsoundInput on Saturday December 24, 2016 @07:47AM (#13249594)

I honestly don't see why you wouldn't consider SQLite to be a "proper database." I think it has a reasonably competitive feature set.

In a usecase where you consider independent databases, with few interactions between them, for millions of users (and a few MBs + binary blobs of data per user) I'd certainly consider it as a possible solution.

[ Parent | on HN ]

Re:Scaling out relational data models, and SQL, through co-l... by ddorian43 on Saturday December 24, 2016 @06:34AM (#13249419)

Cassandra is completely different beast. Like, it has no feature of postgresql and vice-versa.

[ Parent | on HN ]

Re:Scaling out relational data models, and SQL, through co-l... by brianwawok on Saturday December 24, 2016 @01:05PM (#13250865)

They both have selects and inserts

[ Parent | on HN ]