News for hackers. Stuff that matters.
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)?
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.
Re:Cold Showers: For when people get too hyped up about things by JAlexoid on Friday July 24, 2020 @08:48PM (#23945968)
Low maintenance overhead - SQLite, Firebird, Sybase are all like that.