SQLite JSON Superpower: Virtual Columns + Indexing - DB Pro Blog
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.
One of the coolest patterns in SQLite—store raw JSON documents, create virtual generated columns using json_extract, add indexes, and query JSON at full B-tree index speed.
The companies building AI are spending billions to acquire engineers, not replace them. Here’s why your job is safer than you think.
Even though the in-game world is fairly small compared to Earth, I want it to feel big. Part of that is being able to see things that are far away.
A fast and safe service between Styria and Carinthia: That’s the Koralm Railway. It’s part of the new Southern Line in Austria and one of the most important infrastructure projects in Europe.
A month after I started my first Bear blog at , my blog was entirely de-indexed by Google for no apparent reason: I have since migrated to (you ar...
In 2022, Vampire Survivors, a game where you destroy hordes of enemies by just moving around, released.
The library for web and native user interfaces
Query your SQLite database any time, anywhere
RJ opened the first ever Autonomy and AI Day explaining why Rivian believes it is positioned to lead in this next phase of the industry. The company is leaning hard into compute, custom hardware, large scale AI systems, and a shared data foundation that touche…
The new LLM world is very exciting, and I try to experiment with the new tools when I can. This includes building agentic applications, one of which is my personal accounting and invoicing tool - that I wrote about previously As part of that effort I started e…
In today’s fast-paced, data-driven world, teams spend far too much time manually building pipelines, managing access, and integrating data…
This “new” game has a special place in my heart. It’s a re-imagining of a game I played all the time in high school back in the early 2000s. Late nights spent with friends pre-cable internet. Using our AOL connections and firing up Acrophobia. Making inside jo…
Debugging upside-down text in ChatGPT.app: a race condition where addSubview() connects the view hierarchy before Core Animation's layer tree settles.
I hate waiting for compilations. For day-to-day it may only be a minute or two, but once you start doing another task, the context switching distracts from what you were doing before and breaks everything up. Life is too short to be waiting for computers.
Responding to "The highest quality codebase"
← back
I was told this over and over growing up as a kid. "Your mind doesn't work that way," being the rationale for this. Teachers, if you are reading this, NEVER tell a kid that. Seriously. I believed it for nearly a half-century, then wrote my first novel, and lat…
Building a fake battery, adding a USB-C port, booting from SD card, and giving a new life to a classic Linux smartphone.
A look back at some of my favorite self-hosted software and applications released in 2025
September 3, 1967 was the day every Swedish driver had to relearn how to drive. Here is how the streets looked on the day when Sweden switched from driving on the left side of the road to the right side of the road:
I can quit it, but I do not want to
Miguel had been battling an annoying blinking with his view transitions and found the root cause. He’s sharing his learning in this article so you don’t fall into the same trap!
Hands-on GPT-5.2 review: better instruction following and codegen, Pro is a slow genius, but Thinking is too slow to compete with other models of similar intelligence.
The technical musings of Iain Cambridge.
I am currently looking for a job! If you're hiring a new grad in 2026 for for Rust, TypeScript, or React, feel free to shoot me an email at serena (at) quamserena.com.