Explore >> Select a destination


You are here

carlschwan.eu
| | daudix.codeberg.page
5.2 parsecs away

Travel
| | Passionate designer, translator, and FOSS contributor.
| | daudix.one
5.2 parsecs away

Travel
| | Silly little goober with a creative mind.
| | adriano.fyi
4.2 parsecs away

Travel
| | 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.
| | mostlymaths.net
55.4 parsecs away

Travel
| Here are some details of the tools used to build and keep this blog. The engine is the static site generator Hugo Hosted on Github Pages The main header is a Julia set I computed many years ago The font is Reforma 1969 The code font is Monoid The drop caps are from the Byrne font by Nicholas Rougeaux The break decoration font is Nymphette Uses MathJax in some pages Uses D3.