Explore >> Select a destination


You are here

www.lukas-barth.net
| | adriano.fyi
2.4 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.
| | carlschwan.eu
0.9 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.
| | www-gem.codeberg.page
2.3 parsecs away

Travel
| | The concept of keybinders should not be a secret for you. If youre using a tiling windows manager, you are even probably already familiar with assigning keyboard shortcuts to actions within its configuration file. Thats what I used to do for years using awesomewm, i3, or dwm. Once I moved to bspwm, Ive also be introduced to sxhkd and I first missed the point of yet another keybinders. Lets see why sxhkd stands out among the various keybinders available for Linux.
| | daudix.codeberg.page
9.3 parsecs away

Travel
| Passionate designer, translator, and FOSS contributor.