/explore
|
You are here 
|
rolle.design | ||
| | | | |
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. | |
| | | | |
daudix.one
|
|
| | | | | Silly little goober with a creative mind. | |
| | | | |
solariz.de
|
|
| | | | | Did not find anything which matched my usecase / habbits so in some evenings of tinkering I built my own. Kara-Tiles is a Browser New-Tab-Page extension which offer a nice way and fuzzy search for your KaraKeep Bookmarks. | |
| | | | |
adriano.fyi
|
|
| | | Fly.io Postgres failover fix (flyctl pg failover) This is a note to myself, meant to be succinct and helpful. I'm sharing it publicly to save others time. Most of the time Fly.io works as I expect it to, but occasionally there are edge cases that lack documentation, public announcements, or both. It's possible that at some point Fly.io announced a breaking change and I missed it, but the behavior I observed deserves more than an announcement or silently released documentation. | ||
