Upserts are some of the most convenient database operations, and yet many people have never heard of them. In this post we will briefly explain what they are, and how you can squeeze every last bit of performance out of them in Postgres.
I recently finished what I thought would be a quick project to pass a weekend and turned out to be a deeper rabbit hole than expected. Most of the unexpected pain points came from handling Unicode and UTF-8, and the main takeaway for me was a clearer understanding of what they are and how they work.
Because life is too short to spam calls to SSL_CTX_load_verify_locations().
A short rant on the importance of spending a bit of time writing good error messages to save our users a lot of time.
The year is 2024. We have language models that can code, shitty AI-generated content everywhere, and still no flying cars. But a problem that should be trivial to solve is surprisingly annoying: why is there no easy way to link the contents of an <svg> tag?
Or, a proposal on how to structure JS code for simple web apps.
