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

Glauber: Understanding yourself, What is Aphantasia.

Shameless Plugs

Glauber: React Rally Park City, UT, Turso, Laravel.

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

Tactful or Tacky? We’re Judging the Wildest Frugal Wedding Fails