Wes Bos & Scott Tolinski - Full Stack JavaScrip...

Zpravodajství

Technologické zprávy

Technika

803: The SQLite Takeover with Turso’s Glauber Costa

Syntax - Tasty Web Development Treats

Full Stack Developers Wes Bos and Scott Tolinski dive deep into web development topics, explaining how they work and talking about their own experiences. They cover from JavaScript frameworks like React, to the latest advancements in CSS to simplifying web tooling.

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

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

Aplikace Youradio Talk

803: The SQLite Takeover with Turso’s Glauber Costa

Poslechněte si podcast