• 0 Posts
  • 13 Comments
Joined 1 year ago
cake
Cake day: June 28th, 2023

help-circle
  • If you’re going to use SQLite regularly, you’ll need some extra infrastructure. OP’s post provides some boilerplate that would help you on your way.

    What has really made the difference for me recently though, is Simon Willison’s sqlite_utils package. It’s heavier weight than OP’s wrapper classes, but it’s infinitely more powerful and has made using a local database a joy instead of the kludge I usually make of it. I’ll be bummed to writing stuff for PostGres when I have to do that







  • Wow, the tone here is… really arrogant. When somebody starts off calling their audience idiots, I find it a little harder to read along.

    I think I’m glad I did, though. Tone aside, I think it’s a worthwhile insight to note that caching is making up for a shortcoming in your data supply, and that fixing that shortcoming if at all possible should be a priority. The author’s summary would have helped me in the past:

    Caching is a useful tool, but can be easily abused without giving any signs of the abuse.

    Don’t get involved with caching till the last minute; find any other way you can first. Optimise your application before you use the blunt tool of caching.