[martinbaun]

Wow this is an awesome breakdown!

Do you have written anything more extensive about this? Especially the ANALYIZe or PRAGMA OPTIMIZE, and/or Litestream?

Or maybe you can refer some links?

[hruk]

I have not, but I keep meaning to collate everything I've learned into a set of useful defaults just to remind myself what settings I should be enabling and why.

Regarding Litestream, I learned pretty much all I know from their documentation: https://litestream.io/

[martinbaun]

I'd be the first one to read about that and share it :)

And thank you, I'll try to set it up for one of our projects and see what happens!