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