[00:00] It was the year 2000, an application developer named D-Richard Hibb was working on damage control software for US Navy guided missile destroyers. Yes, a terrorist attack was about to change the world as we knew it, but the bigger problem was that the app Hibb was building relied on a sequel database, and whenever the database server went down, his app would do. [00:20] So he asked himself a simple question. He can jet fuel melt steel beams. Wait, no, that's not the right question. He asked himself, why can't I have a sequel database engine embedded inside the application itself that talks directly to the files on disk? [00:32] That would get rid of a separate server process, the ports, the configuration, and the neurodivergent webmaster you needed to keep it all running. He liked the idea so much, he gave it a name, spent the next 25 years of his life building it, and today it may be the most important piece of software ever written. [00:47] By stripping the database down to a single library that read and wrote to one file on disk, Hibb accidentally made it small and simple enough to drop almost anywhere, which is exactly what happened. Today there are billions, no trillions of sequel-like databases in the world, and at least one on every iPhone, Android, Mac, Windows, Posterior, Insertable, Browser, and Mars Rover in existence. [01:09] It's easily the most trusted and resilient software out there, and in today's video we'll look at a project that's crazy enough to think they can rewrite it from scratch, It is June 19th, 2026, and you're watching the code report. If someone told you they were rewriting sequel-like and rust, I think you'd have trouble figuring out if they were one of the smartest people you ever met, or one of the dumbest. [01:28] In this case, it's two people, and the evidence points mostly to smart. One of them wrote a book on latency, and the other was ranked by Linus himself as a top 5 contributor to the Linux kernel. Their problem was never that sequel-like as bad, but rather that it's not truly open source in the traditional sense. [01:44] The source code is available, and you can do whatever you want with it, but it's maintained by just three people, and they don't accept outside contributions. That model is a big reason why it's trusted, but it also means that if you have opinions on how it could be better, you can remove your sequel-like powered Posterior Insertable, and gently return it back to where it came from, or you can keep it and rewrite the library and rust. [02:05] So that's what they did, and they're calling it Turso, and the first feature you won't find in sequel-like is concurrency. The way sequel-like works today is only one writer can touch the database at a time. With Turso, multiple writers can work on different parts of the database simultaneously, and only conflict if they actually touch the same rows. [02:23] Although sequel-like has had this on a branch for the better part of a decade, it's never actually been shipped to Maine. The second feature is Turso Async. A sequel-like blocks the thread every time it touches the disk. With Turso, that operation hands control back, instead of locking everything up, so your app can actually do other things while it waits. [02:40] Then the third and probably most important feature nowadays is VectorSearch. Every AI app needs a place to store embeddings and find the nearest ones fast. Usually what you do is just bolt on a separate vector database like Pinecone, but now you're running two databases with double the complexity. [02:56] Turso comes with native vector types and indexing build directly into the database, so your embeddings live in the same file as the rest of your data, and you can query them with the sequel you already know. It's the exact trick hitpooled 25 years ago, where you take the thing that's needed in its own server, and cram it into a library small enough to run everywhere. [03:15] Except this time, the thing is your AI's entire memory, but doing more than sequel-like is the easy part. The hard part is earning the trust that took 25 years to build. It's to do that, you need to be a drop-in replacement, and you need to never lose someone's data. [03:28] The drop-in part is basically done, because Turso is already fully backwards compatible with sequel-like, so you can swap it in without rewriting anything. But the never-lose data part is harder, so to get there, Turso uses a pretty interesting testing strategy called deterministic simulation. [03:43] What they do is run the entire database inside a simulated universe and play god with time at the network and the disk. Then they inject failures like power-loss mid-write, a corrupted page or a disk that lies about whether it saved your data, [03:57] and then replay the exact same scenario from the same random seed until they squash the bug, and because Turso is actually open-source, anyone can contribute as you traditionally would. This so is rewriting the most trusted database on planet Earth actually a good idea. [04:12] Probably not, but you're only viewed as an idiot until it works, and speaking of ideas that sound dumb until they work, what if your AI coding agent didn't set your money on fire? And that's why you need to know about JetBrains, the sponsor of today's video. [04:24] Their Juni coding agent just graduated out of beta and is based on a very relatable idea. AI tokens cost too damn much, so they made Juni completely model agnostic, and created a lever to decide what each task should cost. [04:38] You can choose a cheaper model for routine work and a more expensive model for harder jobs. I used the Juni CLI to add rule-based permissions to an existing admin dashboard, and I'd like to have the advanced plan mode create a full spec in the Juni plans directory [04:52] with your full project requirements, technical design, delivery stages, and tests. I used a stronger model for this planning phase, then switched to a much cheaper model to implement everything, and saved myself a bunch of tokens. [05:04] Juni just beat out every other coding agent in the most recent SWE Rebench, and you can get 20 free AI credits when you use the Code Fireship 20 at the link below. If this has been the code report, thanks for watching, and I will see you in the next one.