Outer Web | Explore

/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.

You are here		ankane.org Bulk Upsert in Ruby/Rails
\|	\|	adriano.fyi Upsert UUIDs with sqlc :: Adriano Caloiaro's personal blog	6.1 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.	6.1 parsecs away Travel
\|	\|	ericlathrop.com Serving a folder of static files locally by Eric Lathrop	5.8 parsecs away Travel
\|	\|	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.	5.8 parsecs away Travel
\|	\|	www.leighhalliday.com Requiring Uniqueness in Rails \| Leigh Halliday	4.8 parsecs away Travel
\|	\|	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...	4.8 parsecs away Travel
\|	\|	www.jeremymorgan.com How to Set Up Hugo on Pop!_OS	20.7 parsecs away Travel
\|		How to install Hugo static site generator in Pop!_OS Linux	20.7 parsecs away Travel