 
      
    | You are here | carlschwan.eu | ||
| | | | | daudix.codeberg.page | |
| | | | | Passionate designer, translator, and FOSS contributor. | |
| | | | | www.lukas-barth.net | |
| | | | | I am now using the Mastodon-comment system by Carl Schwan to attach comments to my blog posts. | |
| | | | | 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. | |
| | | | | adriano.fyi | |
| | | Mastodon While I'm in no way a Mastodon power user, I've really been enjoying the content that I get from my very limited Mastodon feed. I recently stopped consuming news from - hold on let's not call it news. I recently stopped consuming useless information from a site that I won't name. Everyone has those junk, just-for-fun sites they visit to blow off stream. You don't have to be proud of them, and it's fine that you visit them; every part of every day need not be productive. Anyway, I recently stoppe... | ||