Menu
Sign In Search Podcasts Charts People & Topics Add Podcast API Pricing

Glauber Costa

๐Ÿ‘ค Speaker
358 total appearances

Appearances Over Time

Podcast Appearances

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

And then the client is that, and Leap SQL can become just the server implementation as an open source alternative to do that.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

And then the client is that, and Leap SQL can become just the server implementation as an open source alternative to do that.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

There's so much. There's so much. Because one of the things that we heard as we launched Leap Sequel, for some reason I'll never forget that individual. So we create this Discord community. We announced Leap Sequel. People came and one person in particular, but others said the same thing as well. Give me better schema changes and I'm switching to this tomorrow.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

There's so much. There's so much. Because one of the things that we heard as we launched Leap Sequel, for some reason I'll never forget that individual. So we create this Discord community. We announced Leap Sequel. People came and one person in particular, but others said the same thing as well. Give me better schema changes and I'm switching to this tomorrow.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

So one of the areas, for example, the SQLite is really bad at is schema changes. You can make schema changes, but you cannot alter the type of a column. There's all sorts of limitations like that, which is something, by the way, that we made better in LibSQL. So LibSQL does better schema changes than SQLite, but it's not better enough. Same story, because we were limited in what we can do.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

So one of the areas, for example, the SQLite is really bad at is schema changes. You can make schema changes, but you cannot alter the type of a column. There's all sorts of limitations like that, which is something, by the way, that we made better in LibSQL. So LibSQL does better schema changes than SQLite, but it's not better enough. Same story, because we were limited in what we can do.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

So we want to run... replication, like native replication to the browser, which is something like people have been asking us for a long time. Imagine you have this SQLite database running on your browser that can then sync with an external server or whatever and just get pages on demand. That's one of the things we want to do. We want to tackle the problem of schema changes.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

So we want to run... replication, like native replication to the browser, which is something like people have been asking us for a long time. Imagine you have this SQLite database running on your browser that can then sync with an external server or whatever and just get pages on demand. That's one of the things we want to do. We want to tackle the problem of schema changes.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

We want to tackle the problem of write throughput because SQLite is a very bad database for write operations. We want to make SQLite much better for analytical workloads. So there's just so much. that we believe we can do, right? But together with all of that, there is also the boring work of, you know, we don't even support transactions yet.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

We want to tackle the problem of write throughput because SQLite is a very bad database for write operations. We want to make SQLite much better for analytical workloads. So there's just so much. that we believe we can do, right? But together with all of that, there is also the boring work of, you know, we don't even support transactions yet.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

And again, some of that you can do in parallel, like a sync, like browser, but some of them is just time in the saddle, right?

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

And again, some of that you can do in parallel, like a sync, like browser, but some of them is just time in the saddle, right?

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

Nine months to a year. Nine months to a year. For two reasons. First of all, because of the deterministic simulation testing. Because it allows you to move with a lot more confidence. Imagine trying to get into the thought process of a database writer.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

Nine months to a year. Nine months to a year. For two reasons. First of all, because of the deterministic simulation testing. Because it allows you to move with a lot more confidence. Imagine trying to get into the thought process of a database writer.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

It's always like I want to make this change, but I don't fully understand the impact that this change will have in all of those environments that I don't control, like running on an embedded device here, running this or so making changes to systems like that again. And those are the kind of systems that we dealt with at Linux.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

It's always like I want to make this change, but I don't fully understand the impact that this change will have in all of those environments that I don't control, like running on an embedded device here, running this or so making changes to systems like that again. And those are the kind of systems that we dealt with at Linux.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

sometimes Linux has a lot of weird stuff in the process of development around the idea of like, we know that this thing can break on a processor that only three people have in the world and it's not supported anymore. And we don't want to break those things. So we always move very, very, very, very carefully. And the deterministic simulation testing just allows it to make a lot faster. Like,

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

sometimes Linux has a lot of weird stuff in the process of development around the idea of like, we know that this thing can break on a processor that only three people have in the world and it's not supported anymore. And we don't want to break those things. So we always move very, very, very, very carefully. And the deterministic simulation testing just allows it to make a lot faster. Like,

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

paired with antithesis, which is our integration testing in this analogy, it just allows you to move so much faster. The second reason for why we believe like a year is the reasonable timeframe here is a SQLite, as it turns out, that's why one of the reasons we believe And forking and rewriting is not the biggest code base in the world. SQLite is not that complex.

The Changelog: Software Development, Open Source
Turso is rewriting SQLite in Rust (Interview)

paired with antithesis, which is our integration testing in this analogy, it just allows you to move so much faster. The second reason for why we believe like a year is the reasonable timeframe here is a SQLite, as it turns out, that's why one of the reasons we believe And forking and rewriting is not the biggest code base in the world. SQLite is not that complex.