Best of SQLite — 2025

  1. 1
    Article
    Avatar of newstackThe New Stack·33w

    Why We Created Turso, a Rust-Based Rewrite of SQLite

    Turso is a Rust-based rewrite of SQLite designed to address modern development needs while maintaining compatibility. SQLite's single-writer architecture, synchronous design, and limited extensibility create bottlenecks for high-throughput writes, real-time applications, and modern features like vector search and CDC. Turso introduces asynchronous I/O, concurrent writes through MVCC, native encryption, vector search, CDC support, and live materialized views. The rewrite enables SQLite-like simplicity with architectural improvements for edge computing, AI agents, and streaming analytics while fostering an open contribution model with over 150 contributors.

  2. 2
    Video
    Avatar of devopstoolboxDevOps Toolbox·45w

    SQLite Is ULTIMATE Choice For 99% of Projects

    SQLite is a powerful, lightweight database that's widely deployed across mobile devices and applications. Despite being perceived as a beginner tool, it offers ACID compliance, can scale to 100TB, requires no separate server process, and supports advanced features like Write-Ahead Logging (WAL) for improved concurrent performance. The article explores SQLite's core features, demonstrates its durability and transaction handling, and introduces LibSQL, a distributed fork designed for modern cloud applications that addresses traditional SQLite's concurrency limitations.

  3. 3
    Article
    Avatar of antonzAnton Zhiyanov·45w

    Redka: Redis re-implemented with SQL

    Redka is a Redis-compatible server and Go module that reimplements Redis functionality using SQL databases (SQLite or PostgreSQL) as the backend. It supports five core Redis data types (strings, lists, sets, sorted sets, hashes) and offers both standalone server and embedded library usage. While not matching Redis performance, Redka handles tens of thousands of operations per second and provides benefits like SQL introspection, embedded caching for Go apps, and simplified testing environments.

  4. 4
    Article
    Avatar of nodejsNode.js·30w

    Node.js — Node.js v25.1.0 (Current)

    Node.js v25.1.0 introduces several minor enhancements including an HTTP server option to optimize empty requests, SQLite defensive flag configuration, and a watch config namespace. The release includes updates to root certificates (NSS 3.116), dependency updates for simdjson, corepack, and inspector_protocol, plus V8 visibility improvements. Additional changes cover module loading refactoring, inspector network payload limits, test improvements, and build system updates including Visual Studio 2022 upgrade for Windows.

  5. 5
    Article
    Avatar of bytesdevBytes by ui.dev·45w

    The great SQLite rewrite

    Turso has released an alpha version of their Rust-based SQLite rewrite, addressing modern application needs like concurrent writes, async APIs, and vector search that the original SQLite doesn't handle well. The rewrite maintains SQLite's reliability while adding features for AI applications and real-time workloads. The newsletter also covers various JavaScript/TypeScript tools including zshy build tool, TanStack Start's Selective SSR, and a code example demonstrating object mutation issues in data processing.

  6. 6
    Video
    Avatar of bytegradByteGrad·1y

    Next.js Multi-Tenant & Local-First Apps Are Easy Now

    SQLite can be challenging to use in production, but Turo, a sponsor of the video, simplifies the process by allowing easy setup of multi-tenant and local-first apps. Turo can manage numerous databases, create embedded replicas for low latency, and even integrate AI capabilities like storing vector embeddings. In a demo, the post shows creating a Next.js app with Turo's database management, showcasing benefits like simple database replication, creating multi-database schemas, and enabling point-in-time recovery.

  7. 7
    Article
    Avatar of hnHacker News·32w

    Why Is SQLite Coded In C

    SQLite remains implemented in C because it provides optimal performance, universal compatibility across platforms and languages, minimal runtime dependencies, and stability. C enables SQLite to be called from any programming language, requires only basic standard library functions, and avoids the complexity of modern language runtimes. While safe languages like Rust are acknowledged as potential future options, the SQLite team prioritizes mature, well-understood languages and notes that recoding would likely introduce more bugs than it would fix. The article addresses common questions about why SQLite wasn't built with object-oriented languages or modern safe alternatives.

  8. 8
    Article
    Avatar of infosecwriteupsInfoSec Write-ups·52w

    How to Build a Secure Password Manager in Python

    This guide provides a step-by-step approach to building a secure password manager using Python. It covers key components such as encryption with the cryptography library, data storage using SQLite, and secure handling of master passwords. The project aims to enhance cybersecurity knowledge through practical implementation, while emphasizing security best practices.

  9. 9
    Article
    Avatar of hnHacker News·35w

    Why Local-First Apps Haven’t Become Popular?

    Local-first apps promise instant loading and privacy but remain uncommon due to synchronization challenges. Building offline-capable applications creates distributed systems where multiple devices modify data independently, requiring solutions for unreliable event ordering and data conflicts. Hybrid Logical Clocks (HLCs) solve ordering issues by combining physical and logical timestamps, while Conflict-Free Replicated Data Types (CRDTs) handle conflicts through strategies like Last-Write-Wins. SQLite serves as an ideal foundation for local-first architectures, enabling reliable offline functionality through message-based synchronization that guarantees eventual consistency across devices.

  10. 10
    Article
    Avatar of threedotslabsThree Dots Labs·35w

    SQLite Pub/Sub, Quickstart, and more — Watermill 1.5 Released

    Watermill 1.5 introduces SQLite Pub/Sub support for event-driven applications without external message brokers, adds a hands-on Quickstart training program, and includes API improvements like deprecated CQRS marshalers and enhanced SQL package compatibility with pgx and ORMs. The Go library now supports 13 different Pub/Sub implementations and has grown to nearly 9k GitHub stars with contributions from 43 developers.

  11. 11
    Article
    Avatar of bunBun·26w

    Bun v1.3.3

    Bun v1.3.3 fixes 95 issues and introduces several new features. Key additions include CompressionStream and DecompressionStream APIs with support for gzip, deflate, brotli, and zstd formats. Standalone executables now support flags to disable automatic .env and bunfig.toml loading. The test runner gains retry and repeats options for handling flaky tests. A new --no-env-file flag allows disabling automatic environment file loading. SQLite has been upgraded to version 3.51.0, and the runtime now uses Zig 0.15.2. The release includes numerous bug fixes across the bundler, package installer, Windows support, Node.js compatibility, Web APIs, networking, YAML parsing, and TypeScript definitions.

  12. 12
    Article
    Avatar of hnHacker News·49w

    Working on databases from prison: How I got here, part 2.

    A software engineer shares his remarkable journey from incarceration to joining Turso as a database developer. After enrolling in a prison college program that provided computer access, he rediscovered programming and began contributing to open source projects. Through Maine's remote work program for inmates, he first worked at Unlocked Labs before becoming a major contributor to Turso's Project Limbo, a SQLite rewrite. His dedication to learning database internals and consistent contributions eventually led to a full-time position at Turso, demonstrating how determination and skill development can create unexpected career opportunities even in challenging circumstances.

  13. 13
    Article
    Avatar of nodejsNode.js·24w

    Node.js — Node.js v24.12.0 (LTS)

    Node.js v24.12.0 (LTS) 'Krypton' has been released with several notable changes including HTTP server optimization options, stable type stripping support, new Node-API object creation methods, SQLite defensive flag configuration, watch mode configuration namespace, portable compile cache options, inspector permission controls, and V8 CPU profiling capabilities. The release includes numerous bug fixes, performance improvements, and dependency updates across modules like crypto, buffer, console, and testing infrastructure.

  14. 14
    Article
    Avatar of lnLaravel News·1y

    VS Code database management extension launches v2

    DevDb, a lightweight VS Code extension for database management, has launched version 2.0. This update includes new features like one-click row deletion, easy column value editing, SQL query explanation using MySQL Visual Explain, and more keyboard shortcuts. It supports SQLite, MySQL/MariaDB, PostgreSQL, and Microsoft SQL Server, making it versatile for various developers.

  15. 15
    Article
    Avatar of flydotioFly.io·24w

    Litestream VFS

    Litestream VFS is a SQLite plugin that enables querying databases directly from object storage backups without downloading the entire database. It supports point-in-time recovery through SQL pragmas, allowing instant queries against historical database states. The system uses LTX file format for efficient page-level compaction, fetches only needed pages via S3 range requests, implements LRU caching for hot pages, and can maintain near-realtime replicas by polling backup storage every second. The VFS module works as a plugin to existing SQLite installations without requiring application modifications.

  16. 16
    Article
    Avatar of lobstersLobsters·41w

    Release v2.0.0 · syncthing/syncthing

    Syncthing v2.0.0 introduces major architectural changes including a switch from LevelDB to SQLite database backend, structured logging with per-package log levels, automatic deletion of old database entries after six months, modernized command line options, removal of rolling hash detection, multiple device connections by default, and improved conflict resolution for deleted files. The release includes numerous bug fixes and performance improvements but drops prebuilt binaries for several platforms due to SQLite cross-compilation complexities.

  17. 17
    Article
    Avatar of tilThis is Learning·1y

    RAG - Designing the CLI interface

    The post outlines the design and initial implementation of an open-source CLI tool named 'rag' that stores and retrieves documentation of various frameworks and libraries. It covers the brainstorming of commands such as `add`, `update`, `remove`, and `get`, their arguments, and considerations like handling missing requirements and permissions. The tool will be implemented using TypeScript and Bun, with `commander` used for the CLI interface. The author plans to proceed with database integration, command logic, testing, and CI/CD pipeline setup.

  18. 18
    Article
    Avatar of flydotioFly.io·31w

    Corrosion

    Corrosion is an open-source distributed service discovery system built with Rust, SQLite, and CRDTs that uses gossip protocols instead of distributed consensus. Developed by Fly.io to solve global state synchronization across their platform, it propagates SQLite databases using SWIM-based gossip and cr-sqlite for conflict resolution. The article details major outages caused by the system, including a deadlock bug that locked up their entire proxy fleet, and describes their iterative improvements: watchdogs for event-loop stalls, extensive testing with Antithesis, eliminating partial updates, and regionalizing clusters to reduce blast radius.

  19. 19
    Article
    Avatar of freecodecampfreeCodeCamp·1y

    An Animated Introduction to SQL – Learn to Query Relational Databases

    Learn Structured Query Language (SQL) to query and manage relational databases through an animated, interactive tutorial. This guide covers SQL basics, core concepts, and keywords, along with practice problems using example databases. It also shows how to use SQLite in various programming languages, with a focus on practical, step-by-step examples and code playbacks to reinforce learning.

  20. 20
    Video
    Avatar of primeagenThePrimeTime·48w

    Programming From Prison

    A software engineer currently incarcerated has been hired full-time by Turso to work on their Limbo database project, a Rust rewrite of SQLite. Through a prison remote work program, he contributed extensively to open source projects, spending 90+ hours per week programming and eventually becoming a top contributor to Limbo. His journey from drug-related charges to landing a dream job demonstrates how dedication, hard work, and rehabilitation programs can create second chances in tech careers.

  21. 21
    Article
    Avatar of tdsTowards Data Science·50w

    Mobile App Development with Python

    A comprehensive guide to building cross-platform mobile applications using Python and the Kivy framework. The tutorial covers setting up the development environment, creating user interfaces with KivyMD, implementing database functionality with SQLite, and testing on iOS simulators. The author demonstrates these concepts by building a memorization app with multiple screens for saving, viewing, and playing with word pairs.

  22. 22
    Article
    Avatar of lobstersLobsters·1y

    SQLite4: SQLite4

    SQLite4 was an experimental project from 2012 to 2014, aimed at rewriting SQLite. The project was discontinued, and its lessons were incorporated into SQLite3. SQLite4 was never released or maintained and should not be used. The repository exists purely for historical reference.

  23. 23
    Article
    Avatar of threedotslabsThree Dots Labs·31w

    Durable Background Execution with Go and SQLite

    Durable execution guarantees correct program output despite system failures. This guide demonstrates implementing durable execution in Go using SQLite and Watermill by persisting input events immediately after validation, ensuring idempotent event handlers through database constraints and deduplication, and proving atomicity with chaos engineering tests. The approach uses SQLite's persistent storage as a drop-in replacement for ephemeral backends, combined with the outbox pattern and single-transaction handlers to achieve reliable recovery from network outages, service failures, and other interruptions.

  24. 24
    Article
    Avatar of wordpresscoreMake WordPress Core·49w

    Introducing a new SQLite driver for WordPress – WordPress Playground

    WordPress has released a new SQLite driver that provides better MySQL compatibility through advanced query parsing and emulation. The driver features a complete MySQL lexer and grammar parser written in PHP, supports complex SQL operations like subqueries and UNION statements, and includes MySQL information schema emulation. It's currently available as a feature flag in the SQLite Database Integration plugin v2.2.1+ and powers WordPress Playground. The new architecture enables more robust MySQL feature support and lays groundwork for future database engine compatibility within WordPress.

  25. 25
    Article
    Avatar of mobileMobile developers·1y

    My First Flutter CRUD Application using SQLite

    Pocket Wallet is a mobile app built with Flutter designed to help users manage their allowances. The app supports CRUD operations for allowance entries, displays user information from a database, and includes features like profile customization and expense statistics using pie charts, with SQLite handling local storage.

See all SQLite archives