Hacker News new | ask | show | jobs
by tutfbhuf 2148 days ago
Why choose sqlite over MySQL on a single server (e.g. small vm instance)?
3 comments

Overhead.

SQLite resources are a lot lower due to the database being a flatfile on the OS. It's only main resource is storage.

MySQL is a application that not only requires configuration, tweaking, turning and tender-loving-care but consumes constant resources utilising the processor, memory and storage.

More standard without all of the correctness foot-guns, less to configure and operate, and it’s usually faster. MySQL has to do a lot of work running as a separate process, handling connections, etc. whereas SQLite is just doing file I/O in your current process.
Low maintenance overhead - SQLite, Firebird, Sybase are all like that.