Glauber Costa

This is a monumental release: Concurrent Writes are finally here. When we started Turso more than a year ago, we asked a large number of people what is the thing that SQLite lacked but they wanted to see the most. The result was overwhelming: Concurrent Writes. It is not an easy feature to build: the whole database needs to be able to support MVCC (Multi-Version Concurrency Control). But it possible and doable because we have a full rewrite from a blank slate, and a great and reliable foundation of deterministic testing with both @AntithesisHQ and our own simulator. MVCC is now no longer experimental and will enter a short beta period (which we do for all features) before we call it GA. But that's not the only AMAZING thing in this release: SQLite is known to be a very permissive database. Types are suggestions. Turso now not only support STRICT tables, but comes with a type system including the ability to create your own types with the CREATE TYPE statement. Turso is SQLite reimagined for the age of AI. And it is hard to think of something more important and more overwhelmingly victorious than types. For the full changelog and goodies, see the post below!

Soon, contacting me about this will be not necessary. Concurrent writes on the SQLite model will change the game.

@glcst Turso is one of the projects I'm most excited about for local-first- especially disk ann

@vedovelli74 I recommend you record something and post it on our showcase channel. A lot of great people there!

@glcst Would you like a presentation? It'll take 15 minutes only!

I keep hearing from people that one of the things they love about Turso is that "it just works". This is no accident. One year ago we embarked on this bold journey to go rewrite SQLite. We knew that the only chance this had to work was if our Cloud product was rock-solid stable and reliable and would generate virtually no ops. We switched cloud providers and abandoned scale-to-zero. Scale-to-zero is a very ops-heavy architecture, and was plagued with many issues. We now run a fleet of massively multi-tenant servers that takes into account the beauty of SQLite - being just a file. We almost never touch it, and have an update of zero nines. It just works, and reliably delivers per-agent databases that you can trust. Once Turso (the rewrite of SQLite) is ready for prime time, our multitenant servers will run it instead of SQLite. Then a whole new world begins.

@vedovelli74 share more about your product and let's make sure that it goes to the moon!

@glcst I am finally using Turso on a comercial product and I love it! Had to choose Tanstack Start instead of Laravel, because Turso doesn't work with Laravel. But who cares? LLMs are building it anyway!

X is funny, because there's a lot of people always talking about "what your ancestors would think of you", then there's this guy that's just randomly around posting stuff and ancestor mogging everybody. Keep it going, Mr. Habsburg.

@goodbyesahil @jitl @kwuchu the main problem is that sqlite doesn't make progress in a long time. That's why we are rewriting it at Turso.

@jitl @kwuchu for the majority of software being built using this manner, why cant something simple like sqlite fulfill most of the wishes? most of this would be prototypes anyway?

All these language runtime/tooling companies getting acquired, who's gonna be the first frontier lab to acquire a database company to make it a first class citizen of their platforms and ecosystem.

Sure, LLMs are next-word predictors. But how could it predict the next word in this text ?

This idea that introspection is a modern invention reminds me of other equally stupid urban legends that show up from time to time about the past. Some examples that come to mind: "the Greeks couldn't see the color blue" "medieval parents didn't love their kids because love as we know today is a modern invention" I mean, come on. Read any Greek philosopher. All these guys did was introspection.

Turso is more OSS than ever for those who do the work. But in the age of AI, "the work" it not just producing code: turso.tech/blog/what-happ…

We at @tursodatabase have also been recently flooded by slop PR submissions that DDoS our reviewers time. It is easier than ever to just slopfork stuff... Is Open Source dead? Not for us. We are more OSS than ever, and doubling down. We see Open Source as a way to give a seat at the table to the people who do the work to push a project forward. So the only difference is that what is "work" changed. Writing code is free, and just writing code does not give anyone a claim on our maintainers' time. But many other things do. Drawing from our experience in the Kernel, and how we think about it from first principles, I wrote some clarifications on our OSS policy today. Link 👇👇👇

Time to run Doom inside an LLM

@AvgDatabaseCEO @samlambert speak for yourself, motherfucker

@samlambert We are a mature and emotionally stable group

why can't people be peaceful and drama free like database ceos?

@berenddeboer @penberg we are working on multiprocess rn

@penberg Just tried 0.5.1 after my Drizzle issue was fixed, can now run e2e. Next: it seems tursodatabase doesn't support multi process access 😭 luckily libsql does, so will have to stick with that for local

2.5 years ago, I started a SQLite rewrite as a side quest. Today I'm backporting fixes to a release branch to address issues customers are experiencing as they work towards running it in production. Reminds me of my Scylla days and the shift when you don't just build, but also start maintaining. That time when people gradually move from trying it out to actually depending on it. Turso is growing up!

@ryanwebdev better safe than sorry, man

@glcst I'm not sure if that's sweet or if you have a psychopath for a kid. 🤣 Best sleep with one eye open just in case.

"Daddy, I want to crack your head, then you can go talk to Jesus" - Kid Costa, 3 year old.

Using @tursodatabase cloud for writing internal services is genuinely a great experience. You get a DSN + token to connect to from your lambda or whatever with 2 CLI commands

@AvgDatabaseCEO second dumbest

When your LLM recommends Postgres. Remember, they are trained on data from the absolute dumbest population of devs on earth. Reddit users.

@theo and llms were trained on that

omg I just realized, they're talking about create-react-app. They're conflating React and create-react-app. However dumb you think the average Reddit dev is, I promise you they are WAY dumber.

@archeologistdev @jorandirkgreef @_mm_pause without it you would have to be handwriting continuations all the time to capture general purpose data. very tedious

@glcst @jorandirkgreef @_mm_pause Genuine question: why was that particular language feature so important?

I dislike language wars. language is only 1% of what matters. in systems programming, it's the team & engineering that count. look at tigerbeetle & bun great engineers drive huge impact. those projects could’ve easily been built in c, c++, or rust