/explore
|
You are here 
|
ankane.org | ||
| | | | |
antonz.org
Inserting and updating data with a single query. |
|
| | | | | ||
| | | | |
abuisman.com
Blog about solving problems with code, mostly Ruby, and other things I have learned working as an engineer and a technical leader |
|
| | | | | ||
| | | | |
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. |
|
| | | | | ||
| | | | |
operand.ca
[AI summary] The author shares their experience fixing their blog's responsive design by implementing CSS media queries and viewport meta tags to ensure proper display on mobile devices. |
|
| | | |||
