logo
episode-header-image
Aug 2024
1 h

803: The SQLite Takeover with Turso’s Gl...

Wes Bos & Scott Tolinski - Full Stack Javascript Web Developers
About this episode

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

Up next
Oct 8
944: Is Coinbase Really Writing Half Their Code With AI?
Wes and Scott talk with Kyle Cesmat about how Coinbase is writing nearly half its code with AI—while keeping quality and security front and center. They dig into tools like Cursor and Claude Code, agent-driven workflows, code review challenges, and how AI is reshaping developer p ... Show More
49m 6s
Oct 6
943: Modern React with Ricky Hanlon (React Core Dev)
Scott and Wes sit down with Ricky Hanlon from the React core team at Facebook to dive into the latest features and APIs shaping modern React development. From transitions and Suspense to fetching strategies and future directions, this episode breaks down what’s next for React and ... Show More
38m 36s
Oct 1
942: Mental Health Q&A w/ Dr. Courtney Tolinski
Wes and Scott talk with Dr. Courtney Tolinski about supporting neurodivergent teammates, navigating workplace dynamics, and recognizing strengths beyond labels. They explore ADHD diagnosis and treatment, productivity mindsets, burnout, AI in mental health, and practical routines ... Show More
57m 44s
Recommended Episodes
Jan 2025
#704: #704: Scaling your relational database on AWS - Are relational databases cool again?
Are relational databases cool again? In this episode of the AWS Podcast, host Simon Elisha sits down with Josh Hart, Principal Solutions Architect at AWS, to explore how traditional databases are getting a modern makeover. They dive into three game-changing innovations from AWS t ... Show More
23m 43s
Oct 2024
Big data is dead, analytics is alive
We are on the other side of “big data” hype, but what is the future of analytics and how does AI fit in? Till and Adithya from MotherDuck join us to discuss why DuckDB is taking the analytics and AI world by storm. We dive into what makes DuckDB, a free, in-process SQL OLAP datab ... Show More
50m 19s
Sep 18
From RAG to Relational: How Agentic Patterns Are Reshaping Data Architecture
SummaryIn this episode of the AI Engineering Podcast Mark Brooker, VP and Distinguished Engineer at AWS, talks about how agentic workflows are transforming database usage and infrastructure design. He discusses the evolving role of data in AI systems, from traditional models to m ... Show More
52m 58s
Sep 16
SurrealDB 3.0 and Building Event-Driven AI Applications with Tobie Morgan Hitchcock
Modern application development often involves juggling multiple types of databases to handle diverse data models. The lack of unification can lead to complex architectures with attendant security concerns and fragmented development workflows. SurrealDB is an open-source, multi-mo ... Show More
55m 18s
Sep 2023
How to write high-performance SQL for your Postgres database
pgnanalyze helps users deliver consistent PostgreSQL performance and availability at any scale. Get started with a free trial or explore their docs. You can also find them on YouTube, where Lukas posts a weekly show called 5mins of Postgres.Lukas was a founding engineer of Citus ... Show More
24m 44s
Feb 2024
Who's that girl? It's Jess! (JS Party #313)
Apple kills EU web apps, Amazon launches a JS runtime optimized for serverless workloads & we play a game of 20 (15) questions to welcome Jessica Sachs to the party! Leave us a comment Changelog++ members get a bonus 4 minutes at the end of this episode and zero ads. Join today! ... Show More
1h 13m
Nov 2024
Build An App with a Backend Using Ai in 20 min (Cursor Ai, Replit, Firebase, Wispr Flow)
Episode 32: How can you build an app with a backend using AI in just 20 minutes? Matt Wolfe (https://x.com/mreflow) and Nathan Lands (https://x.com/NathanLands) sit down with AI enthusiast Riley Brown (https://x.com/rileybrown_ai) to explore this exciting and challenging process. ... Show More
39m 34s
Jul 2022
IoT, IIoT and Managing Edge Data
Brian Gilmore (@BrianMGilmore, Director IoT/Emerging Technology @InfluxDB) talks about Edge and Industrial Edge Computing, as well as application and data challenges at the edge.SHOW: 634CLOUD NEWS OF THE WEEK - http://bit.ly/cloudcast-cnotwCHECK OUT OUR NEW PODCAST - "CLOUDCAST ... Show More
35m 37s
Apr 2025
Sequential Scans in Postgres just got faster
This new PostgreSQL 17 feature is game changer. They know can combine IOs when performing sequential scan. Grab my database coursehttps://courses.husseinnasser.com 
27m 36s
Jul 9
Data Pipelines with Apache Airflow
Julian LaNeve (@JulianLaneve, CTO @astronomerio) discusses data pipelines, Apache Airflow, Astronomer’s managed offering, and the benefits of data pipelines for both developers and operations.SHOW: 939SHOW TRANSCRIPT: The Cloudcast #939 TranscriptSHOW VIDEO: https://youtube.com/@ ... Show More
25m 36s