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
Today
918: Extreme Native Perf on the Web with Superhuman
Wes and Scott talk with Loïc Houssier about how Superhuman builds lightning-fast, delightfully-designed email software. They dig into engineering philosophy, offline-first architecture, local databases, AI-powered productivity, and what it takes to create tools that people love. ... Show More
48m 54s
Jul 7
917: AI Tools You Should Know
Scott and Wes round up the hottest AI tools you should have on your radar; from text-to-speech wizards to self-hosted image generators. They break down what they’re using, what’s worth paying for, and which tools are changing their workflows. Show Notes 00:00 Welcome to Syntax! 0 ... Show More
37m 48s
Jul 2
916: I got fired, what should I focus on?
In this potluck episode of Syntax, Wes and Scott answer your questions about maintaining popular open-source projects, where to start after a layoff, impostor syndrome, Scott’s recording setup, whether a computer science degree is still worth it in the age of AI, and more! Show N ... Show More
58m 24s
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
Dec 2024
The Art of Database Selection and Evolution
Summary In this episode of the Data Engineering Podcast Sam Kleinman talks about the pivotal role of databases in software engineering. Sam shares his journey into the world of data and discusses the complexities of database selection, highlighting the trade-offs between differen ... Show More
59m 56s
Aug 2024
Picking a database should be simple (Changelog & Friends #56)
Database aficionado, Ben Johnson, joins Jerod to answer the age ol’ question: which database should you use? Answering that isn’t always easy, which means it’s time to play the “It Depends” jingle & weigh (some of) the options. Leave us a commentChangelog++ members save 9 minutes ... Show More
1h 6m
Oct 2024
MongoDB Vector Search with Ben Flast
MongoDB Atlas is a managed NoSQL database that uses JSON-like documents with optional schemas. The platform recently released new vector search capabilities to facilitate building AI capabilities. Ben Flast is the Director of Product Management at MongoDB. He joins the show to ta ... Show More
41m 54s
Nov 2024
scikit-learn & data science you own
We are at GenAI saturation, so let’s talk about scikit-learn, a long time favorite for data scientists building classifiers, time series analyzers, dimensionality reducers, and more! Scikit-learn is deployed across industry and driving a significant portion of the “AI” that is ac ... Show More
52m 2s
Dec 2024
Customizing a Graph Solution
In this episode, Dave Bechberger, principal Graph Architect at AWS and author of "Graph Databases in Action", brings deep insights into the field of graph databases and their applications. Together we delve into specific scenarios in which Graph Databases provide unique solutions ... Show More
38m 7s
Jun 2022
Configuration as Data, with Justin Santa Barbara
What is configuration as data, how is different from infrastructure as code, and why can’t anything just be itself anymore? We posed these questions and more to long-time Kubernetes contributor Justin Santa Barbara at KubeCon EU, and this episode is the result. Justin created the ... Show More
50m 49s
Aug 2024
Where does Postgres fit in a world of GenAI and vector databases?
For the last two years, Postgres has been the most popular database among respondents to our Annual Developer Survey. Timescale is a startup working on an open-source PostgreSQEL stack for AI applications. You can follow the company on X and check out their work on GitHub. You ca ... Show More
24m 38s
Sep 2024
GraphRAG (beyond the hype)
Seems like we are hearing a lot about GraphRAG these days, but there are lots of questions: what is it, is it hype, what is practical? One of our all time favorite podcast friends, Prashanth Rao, joins us to dig into this topic beyond the hype. Prashanth gives us a bit of backgro ... Show More
55m 2s