/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

carlschwan.eu
| | maho.dev

The Raccoon Bytes - Bite-piece of knowledge from a garbage code connosseur by Maho Pacheco
2.2 parsecs

Travel
| |
| | adriano.fyi

Problem synopsis I'm a huge fan of sqlc's approach to code generation. I've seen sqlc called a reverse ORM, and I really like that moniker. However, as a sqlc newbie, I'm still discovering its edge cases. Today's edge case is using postgres UPSERT queries with sqlc. The crux is that when upserting, it's necessary for unique key conflicts to occur so that the UPDATE portion of the query executes. But non-null uuid Go types tend to have a zero-value of 00000000-0000-0000-0000-000000000000. This results in new records inserting with the uuid Go type's zero value, and every following new record upserts the existing zero ID record.
1.3 parsecs

Travel
| |
| | rolle.design

I have finally implemented a very simple Fediverse-commenting to my WordPress blog here at rolle.design in favor of Webmention. I have practically taken the Carl Schwan's code and modified it a bit. Mastodon's API is quite simple, but I wanted to get it done in ten minutes. There are other fancier ways available, which even [...]
0.5 parsecs

Travel
| |
| | blog.m5e.de

Static site generators like Hugo, Jekyll or Nuxt are awesome. They provide way faster delivery of your contents to your customers than any PHP solution like WordPress. Unfortunately you have to create the Markdown files for your content yourself, but because every single post has a filename, title, date and often tags as well as a status for draft, I created a simple tool which takes care of doing exactly that.
17.6 parsecs

Travel
|