Database

via Hacker News 100 (@hn100@social.lansky.name): How’s Linear so fast? A technical breakdown

Dennis Brotzky reverse-engineers the architectural decisions that make Linear feel instantaneous: a real database (IndexedDB) in the browser, local-first mutations that render synchronously, and a sync engine that pushes deltas over WebSockets in the background. It’s a good tour of the local-first playbook — the core insight being that the fastest network request is the one you never make.

via Simon Willison (@simon@simonwillison.net): And Fly.io announced their object storage alternative to S3! https://fly.io/blog/tigris-public-beta/

Fly.io introduces Tigris, a globally distributed, S3-compatible object storage service that caches objects near where they’re requested instead of pinning them to a single region. Fly’s take is refreshingly honest: they couldn’t figure out how to beat S3 themselves, so they’re pointing at someone who did — at least for the kinds of apps that run on Fly.

via Axel Rauschmayer (@rauschma@fosstodon.org): Two projects that sync in-browser SQLite databases with servers:

SQLSync is a collaborative, offline-first wrapper around SQLite that syncs web application state between users, devices, and the edge. Written in Rust and compiled to WASM, it brings reactive query subscriptions and automatic conflict resolution to local-first apps without requiring you to hand-roll a sync layer.

via Kevin Stewart: Postgres: the next generation. Investing in the next generation of committers. — James Governor’s Monkchips

via Kevin Stewart: Tracking Application-Level Consistency with LiteFS · The Fly Blog

via Rust Weekly: SpacetimeDB: A new database written in Rust that replaces your server entirely

via Rust Trending: kawasin73 / prsqlite: Pure Rust implementation of SQLite ★42

via Rust Trending: supabase / postgres_lsp: A Language Server for Postgres ★1626

via Rust Weekly: CachewDB - An in-memory, key value database implemented in Rust

via Rust Trending: pola-rs / polars: Fast multi-threaded, hybrid-out-of-core query engine focussing on DataFrame front-ends ★18955

via Rust Trending: PRQL / prql: PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement ★7931

via Rust Trending: launchbadge / sqlx: 🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, SQLite, and MSSQL. ★9239

via Rust Trending: pingcap / talent-plan: open source training courses about distributed database and distributed systems ★8950

via Rust Trending: tikv: Distributed transactional key-value database, originally created to complement TiDB ★13339

via Rust Trending: m1guelpf / tinyvector: A tiny embedding database in pure Rust. ★135

via Kevin Stewart: LiteFS Cloud: Distributed SQLite with Managed Backups

via Rust Weekly: Zawgl graph database

via Rust Trending: surrealdb: A scalable, distributed, collaborative, document-graph database, for the realtime web ★21210

Grafbase: How we built the Grafbase local development experience in Rust

via Rust Weekly: GQL: A new SQL like query language for .git files written in Rust

Via Sam Smith at IIW: A fast memory-based database engine written in C.

via Rust Trending: MaterializeInc / materialize: Materialize is a fast, distributed SQL database built on streaming internals. ★4966

via Rust Trending: neondatabase / neon: Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, branching, and bottomless storage. ★6825

A way to query arbitrary data sources in SQL-like fashion.

Adam Wiggins: The 2.0 release of Automerge is a huge milestone for local-first software. If you’re interested in developing great multi-user, multi-device software without needing massive infrastructure, it’s worth reading this post in full.