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
931: Project Init - How to Make Good Choices When Starting a New Coding Project
Scott and Wes dive into the fundamentals of project initialization and planning, from outlining ideas and choosing the right tools to making smart technology decisions. They also chat about leveraging AI and collaboration to shape better projects before rolling up your sleeves an ... Show More
30m 46s
Aug 20
930: Text Editor Keybindings, WASM Replacing Docker, LLM apathy and hosting mini apps
In this potluck episode of Syntax, Wes and Scott answer your questions about VS Code vs Cursor, navigating promotions and job titles, database fundamentals, avoiding decision paralysis, how AI is shaping frameworks, and more! Show Notes 00:00 Welcome to Syntax! 00:56 Brought to y ... Show More
55m 37s
Aug 18
929: Cloudflare Blocks AI Crawlers × Debugging Local Data × Raising Kids with Healthy Digital Habits and More
Scott and Wes tackle listener questions on everything from local-first databases and AI-built CRMs to protecting APIs and raising kids with healthy digital habits. They also weigh in on Cloudflare’s AI crawler ban, portfolio critiques, and more hot takes from the dev world. Show ... Show More
53m 58s
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
Sep 2019
Episode 286: 286: SQL Smart with Nancy Sheleheda
Nancy Sheleheda, Senior Director of Application Development at PCT, joined Brittany to discuss why it is important to learn SQL, to engage in a debate on differences between a developer and a DBA and introduce some great resources to leveling up on SQL. Links for this episode:SQL ... Show More
30m 28s
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