meta_pixel
Tapesearch Logo
Log in
Syntax - Tasty Web Development Treats

803: The SQLite Takeover with Turso’s Glauber Costa

Syntax - Tasty Web Development Treats

Wes Bos

Js, Technology, Css, Html5, Tech News, Webdevelopment, News, Javascript, Html

4.91.1K Ratings

🗓️ 2 August 2024

⏱️ 61 minutes

🧾️ Download transcript

Summary

Scott and Wes chat with Glauber Costa from Turso about the evolution of databases and the fascinating technology behind Turso. They dive into topics like the benefits of massive multi-tenancy, vector search, and why Glauber made the switch from NoSQL to relational databases.

Show Notes

  • 00:00 Welcome to Syntax!
  • 00:36 Turso’s relationship with Drizzle.
  • 02:10 What is Turso?
  • 04:23 Brought to you by Sentry.io.
  • 04:48 Using libSQL without Turso.
  • 06:21 An explanation of Vector Search.
  • 07:16 Vector databases are being ‘Sherlocked’ by larger databases.
  • 09:24 Why did you move from NoSQL to Relational?
  • 12:00 Allows for massive multi-tenancy - what does that mean?
  • 15:27 Transactional schema changes.
  • 16:30 Why would you want 10,000 databases?
  • 19:02 What makes SQLite cheaper?
  • 22:59 The strategy for building a business around an inexpensive tool.
  • 26:13 Pull requests and branching within SQLite.
  • 28:52 Database snapshots for rollbacks.
  • 31:14 Driving the cost of a database to zero allows for rethinking architecture.
  • 32:35 SQLite informing Turso’s edge functionality.
  • 36:56 Automatic replica database syncing.
  • 39:10 Is the database a bottleneck?
  • 39:25 Embedded Replicas.
  • 40:04 How do embedded replicas handle conflict resolution from offline users?
  • 41:43 If the server is offline, can the database live in the client or WASM?
  • 43:09 Conflict resolution.
  • 44:47 What makes Turso stand out?
  • 47:51 What was it like working on the Linux Kernel?
  • 51:57 Do you use Linux?
  • 52:46 Sick Picks & Shameless Plugs.

Sick Picks

Shameless Plugs

Hit us up on Socials!

Syntax: X Instagram Tiktok LinkedIn Threads

Wes: X Instagram Tiktok LinkedIn Threads

Scott: X Instagram Tiktok LinkedIn Threads

Randy: X Instagram YouTube Threads

Transcript

Click on a timestamp to play from that location

0:00.0

Welcome to Syntax. Today we have a really good one. We're talking to Globber Costa about

0:06.1

TURSO and Sequel Light. It's a distributed Sequo Light platform that is really

0:11.8

just getting a lot of attention from a lot of

0:14.2

developers who've tried it. So we're going to be diving into distributed

0:18.2

databases in general. We're going to be talking about Sequo Light and why people

0:21.7

are using it these days and a little bit it's

0:23.8

kind of a little bit of a glow-up recently in terms of like it's public

0:27.0

perception it feels like so we're gonna be talking all about that and more

0:30.0

with me as always is Wes Boss what's up West. Hey not much excited to talk about Sequo Light and Terso and everything the the

0:37.8

dudes from drizzle have good things to say about you probably half because they like it and half because you,

0:45.2

I think you sponsor the development of Drisil quite a bit.

0:48.8

Yeah, yeah, first of all, thanks so much for having me.

0:52.4

It's a pleasure to be here. I've been a fan of the podcast and yeah, like we were in fact the first corporate sponsors of Drisol when right when they were just getting started.

1:02.5

We're very happy with the partnership,

1:04.3

we're very happy with them.

1:06.2

And I think it's safe to say they'll correct me

1:09.1

if they disagree here, but it's not just a financial thing like we really believed in what they're doing and you know very early on and I'm happy to go into into more details there as well but like very early on we had this issue in which people were very

1:26.7

excited about the idea of TURSO. That's when we were releasing our private beta. But the one thing that we got from the private

1:34.3

beta users is this is really hard to consume because it doesn't work with the ORMs,

1:38.6

right? And then we had this drizzle was just popping out in the scene at the moment and we really had that

1:45.3

symbiotic win-win relationship in which hey if you guys can support us we will be happy to sponsor

1:51.5

you and look this you know this is how the relationship

...

Please login to see the full transcript.

Disclaimer: The podcast and artwork embedded on this page are from Wes Bos, and are the property of its owner and not affiliated with or endorsed by Tapesearch.

Generated transcripts are the property of Wes Bos and are distributed freely under the Fair Use doctrine. Transcripts generated by Tapesearch are not guaranteed to be accurate.

Copyright © Tapesearch 2025.