Skip Navigation
Python SQLite Recipe
  • 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

  • Easy HTTPS for your private networks
  • Agreed. When I’ve had to make local carts every couple years, I have to spend 3 hours hacking a process together and remembering it all. I was hoping somebody would do something that “just works”, but this still seems like more conceptual burden than I was hoping for

  • The Caching Antipattern
  • 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.

  • Twitter traffic appears to be declining since the beginning of the 2023 calendar year
  • While I would love to see Twitter auguring straight into the ground, Twitter’s API changes would explain some portion of this traffic changes. I wonder if there are any other proxy measures for audience engagement as separate from basic traffic

  • *Permanently Deleted*
  • Interesting. Would love to know more about languages that can and can’t be parsed by this approach; the abstract assumes some greater formal-language proficiency that I don’t have

  • 📺 Screens in Screens in Screens
  • For the curious: this is an impressive and meditative ~5 minute video showcasing a simple but flexible recursive drawing system. I found it worth the watch and I’m curious about the code

  • Twilio Alternatives
  • Are you trying to do something programmatic with thousands of calls, or just engineer your own bespoke stuff? Seconding AWS SNS for big things. For small projects things, Google Voice at least used to be free or cheap and let you treat phone communications much more like emails than a standard phone number does.

  • InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)TH
    thicket @programming.dev
    Posts 0
    Comments 17