3 ms·
> I want to clarify why I excluded SQLite in that list: It is not a database server (all of the others are); it is an embedded database. Agree. The confusion
by SJC_Hacker 3y ago
> I want to clarify why I excluded SQLite in that list: It is not a database server (all of the others are); it is an embedded database.
Agree. The confusion probably comes from the fact, the SQLite programming language interfaces still have the "connection" abstraction.
Also, it would be great if there was a simple way to simply "load this entire database into memory". Its not too difficult to manually copy tables, but its much slower than it could be. Even a smallish ~250 MB database was taking like 30 seconds to copy row-by-row.