3 ms·
It seems like there are a few different terms being tossed around here, and it's hard to tell which one is being discussed. * How is the data stored? "Columna
by tomhallett 4y ago
It seems like there are a few different terms being tossed around here, and it's hard to tell which one is being discussed.
* How is the data stored? "Columnar" (column oriented) vs "Row Oriented" vs Document
* How do you query the data? SQL vs json (elastic search/mongo)
With any discussions on performance, while it is true that any database which has ACID compliance will struggle at very large scale, if the solutions being discussed are firebase or superbase, it feels like that is an issue which is not relevant yet. If you are having scaling issues with superbase, I would look at a few different things (indexes, application caching, work_mem, replicas, etc) way before i look at a different database engine.