Turn #JSON objects to rows and columns with #SQL using JSON_TABLE SELECT * FROM JSON_table ( jobj, '$.path' COLUMNS ( ... ) ) Expand arrays to rows with JSON_table ( '[1,2,3]', '$[*]' COLUMNS ( c1 path '$' ) ) See more examples by René Nyffenegger at renenyffenegger.ch/notes/developm…

The azure CLI command "az" is among the worst for typing - it reminds me of piano lessons for the pinky.

vim motions should really be on the OS level, not just editor. We should be able to control everything with vim key bindings

Some notes on querying the Swiss Zefix (zentraler Firmenindex = central business name index) with curl on a shell: renenyffenegger.ch/notes/developm…

Some notes on networking in Docker: renenyffenegger.ch/notes/developm…

Everything you need to know about computers and software 🔥 renenyffenegger.ch/notes/index.ht…

This is well worth a read: Ken Thomson - Reflections on Trusting Trust You can't trust code that you did not totally create yourself. cs.cmu.edu/~rdriley/487/p…

Einfluss der KI auf den eMailverkehr: Ich kriege zunehmend eMails, die mit "Ich hoffe, diese Nachricht erreicht sie gut" beginnen.

I guess I don't want RecordUsageTelemetry to be found anyway. What's that function doing on my computer?

I just found out that my domain renenyffenegger.ch is in the top 1000 list of domains of switch (the registry of .ch) which prompted me to publish all domains that were at least once in this list along with the <title> and description: domain.db.renenyffenegger.ch/ch/top-1000

Trying to naively determine Wikipedia trends over the past year: opendata.renenyffenegger.ch/Wikimedia/tren… While not perfect, this still provides some insight into the sentiment of the period.

So, Perplexity occasionally asks me to compare two generated answers. In german, I have to compare between the "linke Antwort" and the "richtige Antwort" (= correct answer) - because "right answer" can be translated as "rechte Antwort" or "richtige Antwort" (which is wrong)

Isn’t it interesting that Zürich, Switzerland's most populous municipality, comes last alphabetically when ordering its municipalities?

For a project I am currently working on, I needed a multithreaded web server in a Windows environment. I've published the streamlined version of the source code on my website: renenyffenegger.ch/notes/web/webs…

You may know about ALT + Tab, but did you know pressing Delete while ALT + Tab is open will close the selected window? 👀

Anna Diouf (hoffentlich hip) Benedikt Brechtken Konrad Lorenz hätte das vermutlich als die "Verhausschweinung des Menschen" bezeichnet.

I created a website with similar flags for my godchild and her brother. We had quite some fun figuring out which country belongs to which flag: renenyffenegger.ch/misc/similar-f…

So, @grokipedia has two entries about AI? grokipedia.com/page/Artificia… and grokipedia.com/page/Artificia… (which is partly french)

I've created a simple python module to load AI model data from models.dev into an SQLite database: ReneNyffenegger/db-AImodels: Load AI models from models.dev into an SQLite database

Hello World example for Runpod serverless: github.com/ReneNyffenegge…