Best of SQLite — December 2024

  1. 1
    Article
    Avatar of hnHacker News·1y

    outerbase/studio: A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite.

    Outerbase Studio is a lightweight, browser-based GUI for managing SQL databases, initially built for LibSQL and SQLite but now supporting a range of databases including MySQL and PostgreSQL. It features a user-friendly query editor, a powerful data editor, a schema editor, and a flexible connection manager. The desktop apps for Windows and Mac offer additional support for drivers not feasible in a browser environment.

  2. 2
    Article
    Avatar of hnHacker News·1y

    Introducing Limbo: A complete rewrite of SQLite in Rust

    Turso has announced Limbo, a complete rewrite of SQLite in Rust, aiming for robust memory safety and modern architecture while maintaining full compatibility with SQLite's language and file format. Limbo leverages deterministic simulation testing for higher reliability and ensures asynchronous operations from the ground up. Initial benchmarks show promising performance improvements, and the project continues to grow with community contributions.

  3. 3
    Article
    Avatar of lobstersLobsters·1y

    7 Databases in 7 Weeks for 2025

    This post discusses seven databases that are worth exploring in 2025, each offering unique capabilities and use cases. It covers PostgreSQL, SQLite, DuckDB, ClickHouse, FoundationDB, TigerBeetle, and CockroachDB, highlighting their key features and suggesting practical experiments to deepen understanding. This mix includes both well-established and emerging technologies, offering insights into client-server models, embedded databases, analytics, financial transaction processing, and globally distributed databases.

  4. 4
    Article
    Avatar of hnHacker News·1y

    trailbaseio/trailbase: A blazingly fast, single-file, open-source application server with type-safe APIs, Auth, and Admin UI built on Rust+SQLite.

    TrailBase is an open-source, single-file application server known for its speed and type-safe APIs. Built on Rust and SQLite, it includes built-in authentication, an admin UI, and supports sub-millisecond latencies. The server is highly extensible, supporting mobile, web, and desktop applications, and boasts simple self-hosting. Pre-built binaries are available, and it is easy to build from source. Contributions are welcome, though licensing under OSL-3.0 with certain conditions applies.

  5. 5
    Article
    Avatar of hnHacker News·1y

    blackcandy-org/blackcandy: A self hosted music streaming server

    Black Candy is a self-hosted music streaming server that can be easily installed using Docker. It supports both SQLite and PostgreSQL databases, with SQLite being the default. Features include mounting media files, using environment variables for configuration, and logging control via Docker options. The server can also be proxied through Nginx for improved performance. Mobile apps are available for Android, and a demo can be accessed with limited privileges. Upgrading involves careful steps due to potential breaking changes in major versions.

  6. 6
    Article
    Avatar of lobstersLobsters·1y

    Collection of insane and fun facts about SQLite

    SQLite is the world's most deployed and used database, maintained by just three people without outside contributions. It originated from a need for a serverless database on a US warship. SQLite is in the public domain and has an extensive test suite, partly proprietary, ensuring reliability. It has unique traits such as a single writer model, weak typing, and no foreign keys by default. Despite its quirks, SQLite has strong backward compatibility and diverse applications, even outperforming filesystems in some cases.

See all SQLite archives