4 ms·
yes is heavyweight, SQLite for example isn't , but is kind the point you want database to use multiple formats, have acid compliance, json support, parallelism,
by imachine1980_ 4y ago
yes is heavyweight, SQLite for example isn't , but is kind the point you want database to use multiple formats, have acid compliance, json support, parallelism, easy debuggability, scalability, fault tolerance.
this are problems that you pay only little cost because 1 PostgreSQL database can scale to thousands or millions of users, and is more like a video editor you doesn't code directly in it, and data replication is difficult and expensive.
some people don't want have a server only for this and accept the drawbacks of not having a full database server, for example remoteok.
- quesera 4y agoSQLite claims at least 180K LOC (~145K+25%, covering a substantial but incomplete part of the codebase), and the above report shows Rails at 386K LOC. Suggesting that LOC does not support this argument, and perhaps is not a great metric in general, especially across different languages. https://www.sqlite.org/amalgamation.html https://www.sqlite.org/amalgamation.html (as of Version 3.37.0 - 2021-11-27)