Tue Feb 11
I often have to merge data from different tables in PostgreSQL, this is a code snippet I use: MERGE INTO users u USING new_users n ON u.user_uuid = n.user_uuid WHEN NOT MATCHED THEN INSERT VALUES (n.user_uuid, n.first_name, n.last_name) WHEN MATCHED THEN UPDATE SET first_name = n.first_name, last_name = n.last_name...
Credo che il primo post archiviato da queste parti sia un riepiloghetto del Sanremo 2013 a conduzione Fazio, riesumato da uno dei miei antichi blog.
The documentation of the Tangara reminded me to check out a tool that has been collecting dust in my bookmarks for months: the powerful beets! What a mighty tool! You can have a look at my configuration that takes care of all my music library management needs: Clean up tags with data from MusicBrainz (that is beets’...
Night has fallen, coolness seeping. The head is heavy, with weakened limbs. A final prayer midst fainting hymns. All is still. Humans sleeping.
Si el Golden Sun tiene, a mi parecer, una de las mejores OST, se dice y punto. Y ver que la han añadido a la app Nintendo Music me ha alegrado el día. También os digo que este cover a capella que Smooth McGroove ha hecho de de mi canción preferida de esta banda sonora. Es que es flipante cómo incluso ha reproducido...
Intro As part of my journey towards higher privacy while using internet, I decided to set up Pi-hole on my Synology NAS DS218play. If you are reading this article, you probably don’t need the following explanation, but just in case: Pi-hole is perhaps the most popular DNS sinkhole, which aims to block ads, trackers...
IUMA's Jeff Patterson and Rob Lord; photo via Good Times. Although much of the interactive multimedia focus was on CD-ROMs during 1994, there were some multimedia experiments happening on the World Wide Web. Of particular note was a prototype online music service called the Internet Underground Music Archive (IUMA),...
Yesterday I posted that I’d resolved my new microblog POSSE1 posts from generating link previews on Mastodon and Bluesky. Today, I want to briefly run through how I managed that.