|
You are here |
ankane.org | ||
| | | | |
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. | |
| | | | |
www.leighhalliday.com
|
|
| | | | | How to ensure your values are unique It's often the case that you want to ensure that you've got uniqueness in your data. You only want an... | |
| | | | |
ericlathrop.com
|
|
| | | | | I often need to view a bunch of static HTML files in my browser locally, and I often need to open them with http:// rather than file:// URLs so related CSS or JavaScript files load correctly. Luckily, Python provides a simple web server, and most Linux distros include Python. | |
| | | | |
www.bitovi.com
|
|
| | | Is your app Cloud ready? Containerize your JavaScript/Node.js API with Docker create a consistent experience for everyone and everywhere your app runs. | ||