4 ms·
I looked, but it seems to run on SQLite. Makes me a bit concerned about scalability.
by freen 5y ago
I looked, but it seems to run on SQLite. Makes me a bit concerned about scalability.
- tony-allan 5y agoThey mention 100,000 rows as a soft limit. SQLite is the underlying database technology and it has a maximum database size of 281 terabytes. Enough for a weekend project! [1] https://support.getgrist.com/limits/ https://support.getgrist.com/limits/ [2]https://www.sqlite.org/limits.html https://www.sqlite.org/limits.html
- sdoering 5y agoThanks for the reminder of SQLite's limits. I knew that they were enough to just not think about it for everything I could imagine practically doing. But that I could even extend them beyond even that was nice to see: > The default setting for SQLITE_MAX_COLUMN is 2000. You can change it at compile time to values as large as 32767.
- freen 5y agoMore worried about write contention than storage.
- speedgoose 5y agoIf you don’t need concurrent transactions, SQLite is usually more than enough. A lot of people’s “big data” problems, not really big data but still significant data, can be solved using SQLite.
- kissgyorgy 5y agoThe use-case of this app is that a couple of people editing things at a time, which is perfect for SQLite. It can read a lot, only struggles when you have hundreds of parallel write transactions. It's a big misconception about SQLite that it doesn't scale. It absolutely can if you don't write it a lot!