Conversation

Notices

1. Embed this notice
   ARGVMI~1.PIF (argv_minus_one@mastodon.sdf.org)'s status on Friday, 07-Nov-2025 10:15:20 JST ARGVMI~1.PIF

   I must confess I'm really liking #SQLite right now.

   The database is just a file. You can put it anywhere, even on a network file system. There is no user name, no password, no IP address and port number, no certificate, and no separate RDBMS process to babysit.

   And yet it's still a proper database with SQL and ACID and all. I can query it like any other database, even if there is some other program writing to the database at the same time.

   Beautiful.

   #programming

   • prettygood likes this.
   • Embed this notice
     prettygood (prettygood@socially.drinkingatmy.computer)'s status on Friday, 07-Nov-2025 10:15:18 JST prettygood

     in reply to
     @argv_minus_one in my experience it is *fragile* though, so keep backups (as though that doesn't apply to anything and everything). At least a half-dozen times in my self-hosting life have I had sqlite databases just destroy themselves
   • Embed this notice
     ARGVMI~1.PIF (argv_minus_one@mastodon.sdf.org)'s status on Friday, 07-Nov-2025 10:25:55 JST ARGVMI~1.PIF

     in reply to

     • prettygood

     @prettygood

     Wild.

     My employer's website uses SQLite for its shopping cart system. I hadn't paid much attention to the choice of RDBMS until now, but it's been running for over 15 years and never went corrupt.

     They do keep backups, though, just in case.

     prettygood likes this.