HNNewShowAskJobs
Built with Tanstack Start
SQLite: How it works, by Richard Hipp (2024) [video](youtube.com)
94 points by thunderbong 4 months ago | 9 comments
  • rednafi4 months ago

    I love how sqlite just keeps popping up every now and then. Folks at Turso DB are also doing some super cool stuff with Limbo and LibSQL.

    • dietr1ch4 months ago |parent

      It'll keep popping up because it's not practical to have a fully fledged database system running if your data can be downloaded in a few seconds with a phone on a decent 5G network.

      • rednafi4 months ago |parent

        DHH and friends have recently been evangelizing it like there’s no tomorrow. Simon Willison has been bullish on SQLite for the last six years.

        The Go community is pushing out tools like Litestream and LiteFS. Plus, people at fly.io, especially Ben Johnson, are heavily proselytizing SQLite. All of this adds up. Being a fantastic piece of software in its own right also helps.

    • andrepd4 months ago |parent

      Why shouldn't it! It's fast, small, ubiquitous.

    • burcs4 months ago |parent

      It is everywhere these days, I mean it always has been, but now people are talking about.

      Love the Turso team!

  • klelatti4 months ago

    Link to slides for this talk:

    https://sqlite.org/talks/howitworks-20240624.pdf

  • anonnon4 months ago

    SQLite is one of the greatest pieces of software ever written, and D. Richard Hipp is a model, both professionally and personally, that other developers should emulate.

  • maxloh4 months ago

    I always found it interesting that SQLite is embedded in almost all popular operating systems and browsers. It has like 90% market share in these spaces, being included in Android, macOS, Windows, Chromium, Firefox, etc. [0]

    It's very likely that the browser and operating system you're using to view this page are powered by SQLite.

    [0]: https://en.wikipedia.org/wiki/SQLite#Notable_uses

  • 4 months ago
    [deleted]