Hacker News new | ask | show | jobs
by notmainacct 2505 days ago
I mean, you get a similarly portable file with

mysqldump -u username -p database_name > data-dump.sql

and you can load that dump back in with

mysql -u username -p new_database < data-dump.sql

I love sqlite3 for the ease of setting up, and the ability to use in any device or environment immediately, but I'll go to a more featured database like postgres or mysql for larger projects, or for speed. This projects seems to benefit with using mysql to be able to secure the database with a password, as well as the ability to have a timestamp type (but the project saves timestamps with a string rather than a datatime except for user login timestamps so ¯\_(ツ)_/¯)