2 ms·
For me, the main killer feature of sqlite is portability. (Like moving it around, not porting it to new systems). Just write the code to create an empty databa
by ajsnigrutin 6y ago
For me, the main killer feature of sqlite is portability. (Like moving it around, not porting it to new systems).
Just write the code to create an empty database if the db file does not exist, move your code elsewhere, and the database will be created on the first run. No usernames, passwords, firewall rules, IP addresses, no nothing... just a single file, with all the data inside.
Miration? Copy the whole folder, code and the database. Clean install.. copy the folder, delete the database. Testing in production? Just backup the file, do whatever, then overwrite the file.