In this episode of The Programming Languages Podcast with Fexingo, Lucas and Luna unpack the quiet dominance of SQLite — the world's most deployed database engine. They explore why this embedded, serverless library runs on more than one trillion devices, from smartphones and cars to web browsers and spacecraft. The hosts dive into SQLite's unique architecture: no client-server setup, zero configuration, and a single-file persistence model that makes it ideal for edge computing and offline-first applications. They discuss real-world examples, including how Tesla uses SQLite to power infotainment systems, how Apple integrates it into nearly every iOS and macOS app, and how the U.S. Navy relies on it for critical navigation systems. Lucas and Luna also examine the trade-offs — scalability limits and concurrency constraints — and why SQLite is suddenly gaining attention in the serverless and WebAssembly ecosystems. A technical but accessible conversation about the database you didn't know you were using.

#SQLite #Database #EmbeddedDatabase #Serverless #EdgeComputing #WebAssembly #iOS #Tesla #Apple #USNavy #OfflineFirst #OpenSource #Technology #Programming #SoftwareEngineering #FexingoBusiness #BusinessPodcast #DeveloperTools

Keep every episode free: buymeacoffee.com/fexingo