3 ms·
I actually get to see a little more of databases than most so: "SQLite is a sql-based database with a particularly unique feature: the entire database is in a
by chasil 3y ago
I actually get to see a little more of databases than most so:
"SQLite is a sql-based database with a particularly unique feature: the entire database is in a single file."
Digital Equipment Corporation (DEC) developed a SQL database known as Rdb for VMS. It could store everything in a single file. Oracle bought it, and maintains it here:
https://www.oracle.com/database/technologies/related/rdb.html https://www.oracle.com/database/technologies/related/rdb.htm...
SQLite's ATTACH command allows the spanning of files. Be careful how you use it in WAL mode.
"SQLite being a file on disk does make connecting from external clients effectively impossible."
SQLite does support access over NFS and SMB, unless you are in WAL mode.