|
You are here |
www.lukas-barth.net | ||
| | | | |
carlschwan.eu
|
|
| | | | | 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. | |
| | | | |
rolle.design
|
|
| | | | | I have finally implemented a very simple Fediverse-commenting to my WordPress blog here at rolle.design in favor of Webmention. I have practically taken the Carl Schwan's code and modified it a bit. Mastodon's API is quite simple, but I wanted to get it done in ten minutes. There are other fancier ways available, which even [...] | |
| | | | |
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. | |
| | | | |
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. | ||