-
Notifications
You must be signed in to change notification settings - Fork 0
Database
Lauri Ojansivu edited this page Mar 20, 2026
·
89 revisions
- https://planetscale.com/blog/zero-downtime-migrations-at-petabyte-scale
- https://news.ycombinator.com/item?id=47037781
- https://www.cs.cmu.edu/~pavlo/blog/2026/01/2025-databases-retrospective.html
- https://archive.is/dR9Jd
- https://news.ycombinator.com/item?id=46496103
- https://archive.is/eIio9
- Dolt
- https://www.dolthub.com
- https://github.com/dolthub/dolt
- Regarding Prollyferation: Followup to
People Keep Inventing Prolly Trees - Choosing a Database Schema for Polymorphic Data (2024)
- Gel
- lakeFS
- TerminusDB
- Show HN: EloqDoc: MongoDB-compatible doc DB with object storage as first citizen
- https://www.category.xyz/blogs/raptorcast-designing-a-messaging-layer
- https://news.ycombinator.com/item?id=44353098
- Ask HN: How are you cleaning and transforming data before imports/uploads?
- New DSL "MassQL" lets scientists query mass spectrometry data
- Jepsen: TigerBeetle 0.16.11
- Just make it scale: An Aurora DSQL story
- Conformance checking at MongoDB: Testing that our code matches our TLA+ specs
- A High-Level View of TLA+
- Show HN: Greenmask 0.2 – Database anonymization tool
- Display any CSV file as a searchable, filterable, pretty HTML table
- Hierarchical CSV
- Show HN: CSV GB+ by Data.olllo – Open and Process CSVs Locally
- Show HN: Interactive jq, but it's a bash script using fzf
- Preserves: An Expressive Data Language
- Crap Data Everywhere
- Show HN: Automated smooth Nth order derivatives of noisy data
- A DuckDB-based metabase alternative
- Sirius is a GPU-native SQL engine.
- It plugs into existing databases such as DuckDB via the standard Substrait query format, requiring no query rewrites or major system changes.
- By offloading query execution to GPUs, Sirius achieves over 10× speedup at the same hardware rental cost!
- https://www.sirius-db.com
- DuckDB NPM packages 1.3.3 and 1.29.2 compromised with malware
- DuckDB Is a Protocol
- Radio for DuckDB – DuckDB Now Talks to WebSockets and Redis Pub/Sub
- DuckDB: Development Roadmap
- Adding concurrent read/write to DuckDB with Arrow Flight
- Deep Down the Rabbit Hole: Bash, OverlayFS, and a 30-Year-Old Surprise
- Show HN: Desktop app displaying files on a 2D canvas
- Show HN: Vortex – a high-performance columnar file format
- Show HN: CEL by Example
- Show HN: Jsonic – Python JSON serialization that works
- FracturedJson
- Sick: Indexed deduplicated binary storage for JSON-like data structures
- Progressive JSON
- Show HN: Convert JSON Schema to SQL DDL
- Ten years of JSON Web Token and preparing for the future
- Loading Pydantic models from JSON without running out of memory
- JSON Patch
- Yamlfmt: An extensible command line tool or library to format YAML files
- SpacetimeDB 1.0 is here
- Taking over 60k spyware user accounts with SQL injection
- Google Research: Graph foundation models for relational data
- HeidiSQL Available Also for Linux
- Getting AI to write good SQL
- AtomixDB
- The Prompt() Function: Use the Power of LLMs with SQL
- Beyond Dune: Accelerating with EVM Query Language
- FerretDB
- TigerFS – A Filesystem Backed by PostgreSQL
- Show HN: Pg-typesafe – Strongly typed queries for PostgreSQL and TypeScript
- PgX – Debug Postgres performance in the context of your application code
- Discovering and recovering from PostgreSQL corruption on Matrix.org
- Postgres LISTEN/NOTIFY does not scale
- Coming to PostgreSQL – on-disk database encryption
- Show HN: PLJS – JavaScript for Postgres
- How to run cron jobs in Postgres without extra infrastructure
- Making Postgres Distributed with FoundationDB
- Postgres IDE in VS Code
- PostgreSQL Lock Conflicts
- The fastest Postgres inserts
- Pgwatch: PostgreSQL Monitoring Solution
- Migrating to Postgres
- Xata Agent: AI agent expert in PostgreSQL
- The Great Re-shard: adding Postgres capacity (again) with zero downtime (2023)
- Postgres as a Graph Database: (Ab)Using PgRouting
- Pg_parquet: An extension to connect Postgres and parquet
- PostgreSQL Streaming Replication (WAL); What It Is and How to Configure One
- The Part of PostgreSQL We Hate the Most (2023)
- Why does everyone run ancient Postgres versions?
- What I wish someone told me about Postgres
- Microsoft Python Driver for SQL Server
- GenosDB (GDB) – Decentralized P2P Graph Database
- Multi-Region Row Level Security in CockroachDB
- Migrating from Postgres to CockroachDB
- Litestream Writable VFS
- Litestream v0.5.0
- LiveStore: State management based on reactive SQLite and built-in sync engine
- From Prisma Founder to LiveStore: Building local-first apps with Johannes
Schickling
- https://www.youtube.com/watch?v=aKTbGIrkrLE
- LiveStore voi synkata selaimen tabit myös offline? Broadcast channel, give name to it to post, to cross-tabs. Or localstorage. Or indexDB. Or shared worker, used at LiveStore
- LiveStore can sync browser tabs also offline. Ways:
- Use shared worker, this is what LiveStore uses. Other ways would be:
- Add broadcast channel, give name to it, post to cross-tabs
- Use localstorage from all tabs
- Use IndexDB
- Pull or push requests for events since time something, or rebase. Just persist event log to D1, turso, postgres, elsewhere.
- Store can be CloudFlare Workers, using web sockets get realtime feedback, receives events, lets everyone know. Replicache is similar architecture.
- LocalFirstFM podcast has more info
- SQLite: Query Result Formatting in the CLI
- Show HN: Micasa – track your house from the terminal
- Hamming Distance for Hybrid Search in SQLite
- Many small queries are efficient in SQLite
- Rqlite: Distributed Database Built on SQLite
- Marmot – A distributed SQLite server with MySQL wire compatible interface
- Building a Durable Execution Engine with SQLite
- SQLiteData: A fast, lightweight replacement for SwiftData using SQL and CloudKit
- PSA: SQLite WAL checksums fail silently and may lose data
- Show HN: AnuDB– Backed on RocksDB, 279x Faster Than SQLite in Parallel Workloads
- Pbf2sqlite: Reading OpenStreetMap into a SQLite Database
- Retrieval Augmented Generation Based on SQLite
- Show HN: gRPSQLite – A SQLite VFS for remote databases via gRPC
- Show HN: SoloDB – A document database build on top of SQLite with JSONB
- Show HN: SQLite JavaScript - extend your database with JavaScript
- LumoSQL
- Graft
- SQLite-on-the-server is misunderstood: Better at hyper-scale than micro-scale
- Show HN: SQLite disk page explorer
- Supercharge the One Person Framework with SQLite
- Zero-latency SQLite storage in every Durable Object
- Sqlite3 WebAssembly
- https://www.gomomento.com/blog/valkey-turns-one-how-the-community-fork-left-redis-in-the-dust/
- https://news.ycombinator.com/item?id=44140379
- The PlanetScale vectors public beta
- Vector databases are the wrong abstraction
- Libxml2's "no security embargoes" policy