Explore >> Select a destination


You are here

blog.startifact.com
| | adriano.fyi
5.9 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.
| | www.lukas-barth.net
2.4 parsecs away

Travel
| | When running Emacs in WSL/WSLg, copying to the Windows clipboard does sometimes not work. This article shows one possible fix for the problem.
| | carlschwan.eu
3.2 parsecs away

Travel
| | Update 29.01.2023: Adapted the code to work with Mastodon 4.0 and replaced linuxrocks.online by floss.social Update 15.03.2023: Thanks to @veronica@mastodon.online, this code now handles replies in a lot nicer way. You might want check out her solution too. Update 07.07.2023: Thanks to @cassidy@blaede.family, the layout was improved and this now handle emojis One of the biggest disadvantages of static site generators is that they are static and can't include comments.
| | rolle.design
8.6 parsecs away

Travel
| 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 [...]