Re:Cold Showers: For when people get too hyped up about things
by tutfbhuf on Friday July 24, 2020 @08:36AM
(#23938723)
Why choose sqlite over MySQL on a single server (e.g. small vm instance)?
[ Parent
| on HN ]
Re:Cold Showers: For when people get too hyped up about things
by doublerabbit on Friday July 24, 2020 @09:11AM
(#23939007)
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.
Re:Cold Showers: For when people get too hyped up about things
by acdha on Friday July 24, 2020 @09:27AM
(#23939189)
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.