Comment by sgt

2 days ago

Sure but if you're dealing with WAL logs, why not just go Postgres? Then you also get a port you can connect to from remote machines if you need.

4 comments

sgt

Reply
wild_egg  2 days ago

> "dealing with WAL"

What's there to deal with? You turn it on with a pragma and forget about it.

  • sgt  1 day ago

    Sure but once you have WAL logs, you suddenly have a more heavy weight setup. Backing it up you'll want to back up those WAL logs to achieve proper point in time recovery, and so on. My point is, you're now bolting on extra stuff on it to do things that Postgres can do (which can be pretty light weight). Not disrespecting SQLite, still one of my favorite DB's.

    • wild_egg  1 day ago

      What? Why are you backing up the WAL?

          sqlite3 source_database.db ".backup backup_database.db"

      Now the WAL content is rolled into your new backup file. Stick a timestamp in the backup file name and run this as a cron job every N minutes and you have all the recovery you need. Another one-liner to sync to S3 and you're all set.

      Edit: And just to clarify, that command can be run on a live DB as it's being used by your app server. SQLite handles external concurrent readers just fine.

      1 reply →