3 ms·

I have quite a few personal services running at home that use mysql. Would be lovely if sqlite worked, but why is it the only one that makes any sense?

• lupusreal 2y ago
  Installing/maintaining mysql or the others is a pain in the ass relative to sqlite (essentially no cost at all). For a personal media library, all write operations are trivially serializable. Sqlite DBs are the easiest to copy to new machines when you upgrade hardware.
  • Mashimo 2y ago
    > Installing/maintaining mysql or the others is a pain in the ass Koel provides a docker-compose file for them, should make it trivial to spin it up.
    • lupusreal 2y ago
      Needing to delve into docker stuff is itself a bigger hassle than using sqlite. Which isn't saying much admittedly, but sqlite is basically hassle free in the most extreme way.
      • Mashimo 2y ago
        Oh yeah, but it's still far far away from "not making any sense"