Klaus Aschenbrenner @sqlpassion.at · 30/08/2026I've burned down a huge amount of my weekly available tokens across multiple LLMs, but I have now for my own x64 OS a working Rust-based Intel NIC driver - for the Intel 82577LM (8086:10ea) and Intel I219-V (8086:15b8) #osdev #rust #rustlang 030
Klaus Aschenbrenner @sqlpassion.at · 29/08/2026My x84 OS implements now a fully working RTL8139 network driver. It can ping IP addresses on the internet, and also answers ping requests. #osdev #rust #rustlang 171
Klaus Aschenbrenner @sqlpassion.at · 12/08/2026I'm just trying to get the BYO PostgreSQL version up and running. I've created on my pg cluster a new database called "performance", and configured its connection in the json file. But when I run the service, I get the following error: "Role "darling" doesn't exist". What am I doing here wrong? 100
Klaus Aschenbrenner @sqlpassion.at · 10/08/2026The simulator can execute now LOIs (Lunar Orbit Insertions), and also Free-Return Trajectories - that saved the life of Apollo 13. Every single dot that you see, is actually *calculated* by an orbital mechanics physics engine. 010
Klaus Aschenbrenner @sqlpassion.at · 10/08/2026Having some fun with orbital mechanics, and TLIs (trans lunar injections)... 😁 100
Klaus Aschenbrenner @sqlpassion.at · 03/08/2026Over the last 6-8 hours (spread across 3 days), I’ve vibe-coded a Home Assistant dashboard that displays data from our photovoltaic system, collected via Modbus over the local TCP/IP network. Home Assistent runs on my old Odriod-H2 Mini-PC from the year 2018... 130
Klaus Aschenbrenner @sqlpassion.at · 25/07/2026Working with multiple sub-agents across multiple GitHub issues in parallel - works like a charm :-) 000
Klaus Aschenbrenner @sqlpassion.at · 28/06/2026I have now a full-blown working UEFI boot path in my OS - incl. a simple AHCI driver to access the SATA based SSD drive with its FAT32 ESP partition. 100% pure Rust code (not a single asm file!), without any dependencies to other crates! #rust #rustlang #x64 #computerscience 050
Klaus Aschenbrenner @sqlpassion.at · 28/06/2026How to escape the heat wave? Starting a 100K “red eye” bike ride at 05:00am in the morning… 😴😴😴 130
Klaus Aschenbrenner @sqlpassion.at · 26/06/2026Running my own OS in Proxmox - booted via UEFI :-) 040
Klaus Aschenbrenner @sqlpassion.at · 23/06/2026I can boot now my x64 kernel on native UEFI hardware - like my AMD Ryzen system with 128 GB RAM. It uses the provided GOP framebuffer to draw a pseudo console to the screen. The legacy BIOS boot path (on older hardware) supports now also the VBE-based graphics mode for the console. #osdev #rust 000
Klaus Aschenbrenner @sqlpassion.at · 18/06/2026It's the 1st time in my life that I've implemented my own UEFI loader - entirely in Rust - without any external dependencies. #Rust #rustlang #computerscience 130
Klaus Aschenbrenner @sqlpassion.at · 17/06/2026I have migrated now my whole x64-based OS entirely to Rust. There is NO single line of C code anymore - just a few pure assembly files! In addition, I'm also providing a VScode based Dev-Container, with which you can even build and run the OS in your browser! #rust #rustlang #osdev #computerscience 371
Klaus Aschenbrenner @sqlpassion.at · 14/06/2026Finished the first bicycle race of my life: the „Dolomitenradrundfahrt“ in East-Tyrol. 110km with 1700m ascent! 🥵 4:19h, and the 96th place (out of 153 participants) within my age group! 💪 120
Klaus Aschenbrenner @sqlpassion.at · 31/05/2026What a day: finished my 1st Aqua Bike competition. 53th out-of-water (the last one!), and finished after the bike split at the 26th place - in 3:48h! 💪 010
Klaus Aschenbrenner @sqlpassion.at · 09/04/2026What a day! mMy longest bike ride of my life! 😎 #mallorca 170
Klaus Aschenbrenner @sqlpassion.at · 04/03/2026CoPilot in SSMS reads from my database/sql server instance, but doesn't show me any executed queries. This is *so* dangerous for your production data - CoPilot could just pass some of your sensitive data to the LLM provider... #ai #llm #datasecurity #gdpr 242
Klaus Aschenbrenner @sqlpassion.at · 27/02/2026I have never thought that software engineers will be substituted by endless loops... #AgenticAI 001
Klaus Aschenbrenner @sqlpassion.at · 23/02/2026WTF? That's part of the generated documentation... #wtf 010
Klaus Aschenbrenner @sqlpassion.at · 23/02/2026Never, ever trust an LLM *blindly*: Claude Code generated me frontend code that stores a bearer token (used for authentication against the REST API backend) in local storage. That's the perfect use case for XSS attacks... #fail #llm 122
Klaus Aschenbrenner @sqlpassion.at · 22/02/2026Using various LLMs to design and implement a web app. The results are amazing. 000
Klaus Aschenbrenner @sqlpassion.at · 18/02/2026Working in VScode with the @continue.dev extension against the model "meta-llama-3.1-8b-instruct" that runs locally in LM Studio on my MacBook Air (M3, with 24 GB unified memory). 120
Klaus Aschenbrenner @sqlpassion.at · 15/02/2026Während ich mich im Orkan durch Graz gekämpft habe, hat Philip seinen höchsten Gewinn seines Lebens eingefahren: ein Sieg (4:30h Spielzeit) gegen einen ELO 2150 Gegner! 💪 Nach 90min Pause geht es um 16:00 gegen einen Fide-Meister aus Ungarn weiter… 🤗 #chess 000
Klaus Aschenbrenner @sqlpassion.at · 13/02/2026Neo has a meeting at the #Oracle. Let's see if he takes the red or blue pill.. 110
Klaus Aschenbrenner @sqlpassion.at · 11/02/2026I have now officially more #Rust code than C code in my #osdev repository! 💪 020
Klaus Aschenbrenner @sqlpassion.at · 11/02/2026The #Linux Kernel has now official support for #Rust: git.kernel.org/pub/scm/linu... 000
Klaus Aschenbrenner @sqlpassion.at · 10/02/2026I have now a fully working preemptive scheduler in my OS available. Spawned tasks can already put into sleep when they wait on external resources (currently key presses from the keyboard). Everything is written entirely in #Rust - besides the necessary bootsector stuff. 010
Klaus Aschenbrenner @sqlpassion.at · 04/02/2026It's quite cool, when the command "cargo test" executes your own OS in qemu, and executes test cases :-) #rust #rustlang #osdev 030
Klaus Aschenbrenner @sqlpassion.at · 31/01/2026It supports the Simple Query Protocol, and supports also the more advanced Extended Query Protocol (with Parse/Bind/Execute/Sync messages) for prepared statements. It's fully written in #Rust based on the #tokio crate for asynchronous message processing. 000
Klaus Aschenbrenner @sqlpassion.at · 29/01/2026I have already learned a lot about the Simple and Extended Query Protocol in #PostgreSQL. The approach even works with traditional query tools like DBeaver. 000
Klaus Aschenbrenner @sqlpassion.at · 29/01/2026Having some "fun" with low-level programming against #PostgreSQL: written a custom asynchronous query firewall (with the tokio crate) in #Rust that intercepts incoming PostgreSQL queries, and only forwards them to the real PostgreSQL cluster, if they are not on a denied list. 100
Klaus Aschenbrenner @sqlpassion.at · 26/01/2026When you perform a Sequential Scan in #PostgreSQL, it will only move 32 pages (32x8KB = 256KB) into the shared buffers. More on that: web.archive.org/web/20171005... 000
Klaus Aschenbrenner @sqlpassion.at · 15/01/2026All my SSH keys are stored directly in 1Password, and there are no keys in the file system anymore. 000
Klaus Aschenbrenner @sqlpassion.at · 15/01/2026I really love the SSH Keys integration in @1password.bsky.social. The hardest part was the configuration across multiple client machines, so that the correct SSH key is handed out based on the machine that I'm currently using (Mac or Linux). The file agent.toml is here your friend :-) 110
Klaus Aschenbrenner @sqlpassion.at · 14/01/2026Deploying a Linux-based Virtual Machine from *scratch* in only 30 seconds - I really *love* the @exoscale.com cloud. Booting my physical Linux workstation even takes longer... 000
Klaus Aschenbrenner @sqlpassion.at · 13/01/2026AI tools can be quite powerful, if you use them in the correct way :-) Reading and trying to understand the #PostgreSQL source code... 010
Klaus Aschenbrenner @sqlpassion.at · 12/01/2026I really like it to use Claude Code to read/browse through the #PostgreSQL code base... 010
Klaus Aschenbrenner @sqlpassion.at · 08/01/2026Running my bare-metal Rust Kernel on physical hardware: a Lenovo W510 notebook from the year 2010. 010
Klaus Aschenbrenner @sqlpassion.at · 08/01/2026GitHub CoPilot: just wrap *everything* into an unsafe block to be on the safe side... #WTF 100
Klaus Aschenbrenner @sqlpassion.at · 08/01/2026These days we can life-watch the beginnings of Oceania, Eurasia, and Eastasia… 🤬😢 100
Klaus Aschenbrenner @sqlpassion.at · 06/01/2026Yes, but I haven't yet looked in detail at the generated code. But the generated code runs in Qemu. 110
Klaus Aschenbrenner @sqlpassion.at · 06/01/2026Testing Claude Code on a real source code base... Migrating my C-based operating system to Rust... 100
Klaus Aschenbrenner @sqlpassion.at · 01/01/2026Today, I’m excited to announce the lineup for my upcoming SQLpassion online trainings for the next 6 months, featuring several brand-new trainings I’ve been developing over the past few months: www.sqlpassion.at/live-trainin... #sqlpassion #sqlserver #postgres #postgresql 000