Data & Databases
- Pandas Should Go Extinct
- Neki – Sharded Postgres
- Pre-Release of Polars 2.0
- Executable Is a SQLite Database
- JIT Compiling Code in 5μs
- Things I want in a modern relational query language
- PostgreSQL for Everything
- A Preview of DuckDB v2.0
- Tracking down the 16-year-old WAL-reset SQLite bug
- 50k Boat Names
- We replaced Redis with MySQL for inventory reservations and it scaled
- Making Postgres 300x faster for analytics: batching, operator fusion, and SIMD
- The startup's Postgres survival guide
- Map of the world's great castles and fortresses
- SQLite should have (Rust-style) editions
- Prefer strict tables in SQLite
- Looking Ahead to Postgres 19
- Show HN: I made Google Trends for Hacker News by indexing 18 years of comments
- F3
- In praise of memcached
- British Columbia, Time Zones, and Postgres
- PgDog is funded and coming to a database near you
- pg_durable: Microsoft open sources in-database durable execution
- SQLite is all you need for durable workflows
- Building durable workflows on Postgres
- SQLite Is a Library of Congress Recommended Storage Format
- Redis array: short story of a long development process
- Pgbackrest is no longer being maintained
- Do you even need a database?
- Instant 1.0, a backend for AI-coded apps
- A Faster Alternative to Jq
- RX – a new random-access JSON alternative
- Big data on the cheapest MacBook
- C# strings silently kill your SQL Server indexes in Dapper
- Kafka is Fast – I'll use Postgres
- QGIS is a free, open-source, cross platform geographical information system
- Will Amazon S3 Vectors kill vector databases or save them?
- Search all text in New York City
- DuckLake is an integrated data lake and catalog format
- Sync Engines Are the Future
- You might not need Redis
- Postgres Just Cracked the Top Fastest Databases for Analytics
- Composable SQL
- Every System is a Log: Avoiding coordination in distributed applications
- You probably don't need query builders
- PostgreSQL is the Database Management System of the Year 2024
- Visualizing All ISBNs
- SQL nulls are weird
- Advent of Code 2024 in pure SQL
- Postgres UUIDv7 and per-back end monotonicity
- Databases in 2024: A Year in Review
- Fun facts about SQLite
- How bloom filters made SQLite 10x faster
- Introducing S2
- In Search of a Faster SQLite
- Map of GitHub
- Should you ditch Spark for DuckDB or Polars?
- Limbo: A complete rewrite of SQLite in Rust
- From where I left
- How to use Postgres for everything
- 7 Databases in 7 Weeks for 2025
- Show HN: Outerbase Studio – Open-Source Database GUI
- Amazon Aurora DSQL
- Safe relational database queries using the Rust type system
- Amazon S3 Adds Put-If-Match (Compare-and-Swap)
- DELETEs Are Difficult
- SQLiteStudio: Create, edit, browse SQLite databases
- Show HN: Embed an SQLite database in your PostgreSQL table
- Huawei developing SSD-tape hybrid amid US tech restrictions
- FireDucks: Pandas but Faster
- What I wish someone told me about Postgres
- ASCII Delimited Text – Not CSV or Tab Delimited Text
- Show HN: BemiDB – Postgres read replica optimized for analytics
- Title drops in movies
- Do you need Redis? PostgreSQL does queuing, locking, and pub/sub (2021)
- Get me out of data hell
- Prisma Postgres – Runs on bare metal and unikernels
- Using SQLite as storage for web server static content
- Toasty, an async ORM for Rust
- A new JSON data type for ClickHouse
- MVCC – the part of PostgreSQL we hate the most (2023)
- Why does everyone run ancient Postgres versions?
- Sqlite3 WebAssembly
- Upgrading Uber's MySQL Fleet
- Zero-latency SQLite storage in every Durable Object
- Sq.io: jq for databases and more
- Jazz – Apps with Distributed State
- How CERN serves 1EB of data via FUSE [video]
- MusicBrainz: An open music encyclopedia
- How Discord stores trillions of messages (2023)
- PostgreSQL 17
- Rearchitecting: Redis to SQLite
- SQL Tips and Tricks
- Insights after 11 years with Datomic [video]
- Iron Mountain: It's Time to Talk About Hard Drives
- Sqlc: Compile SQL to type-safe code
- Taming the beast that is the Django ORM – An introduction
- Farewell Pandas, and thanks for all the fish
- Faster CRDTs (2021)
- Database “sharding” came from Ultima Online? (2009)
- Google's new pipe syntax in SQL
- Pipe Syntax in SQL
- Show HN: InstantDB – A Modern Firebase
- Making database systems usable
- Classifying all of the pdfs on the internet
- Show HN: PgQueuer – Transform PostgreSQL into a Job Queue
- Just use Postgres
- CockroachDB license change
- CSVs Are Kinda Bad. DSVs Are Kinda Good
- Show HN: PGlite – in-browser WASM Postgres with pgvector and live sync
- Postgres.new: In-browser Postgres with an AI interface
- Building a highly-available web service without a database
- Show HN: Play with an interactive heatmap of SF crime (and other cities)
- Full text search over Postgres: Elasticsearch vs. alternatives
- "We ran out of columns"
- Why CSV is still king
- Ask HN: What is the best software to visualize a graph with a billion nodes?
- SQLite: 35% Faster Than the Filesystem
- Database Design for Google Calendar: A Tutorial
- Maestro: Netflix's Workflow Orchestrator
- Garage: Open-Source Distributed Object Storage
- How we sped up Notion in the browser with WASM SQLite
- Binance built a 100PB log service with Quickwit
- Mongo but on Postgres and with strong consistency benefits
- PostgreSQL and UUID as Primary Key
- At 50 Years Old, Is SQL Becoming a Niche Skill?
- Show HN: Triplit – Open-source syncing database that runs on server and client
- I've stopped using box plots (2021)
- Open Source Python ETL
- Discussion on why SQLite is gaining popularity [audio]
- You'll regret using natural keys
- Half a century of SQL
- Heroku Postgres is now based on AWS Aurora
- Vector indexing all of Wikipedia on a laptop
- DuckDB Doesn't Need Data to Be a Database
- Big data is dead (2023)
- Storing knowledge in a single long plain text file
- Migrating Uber's ledger data from DynamoDB to LedgerStore
- Show HN: Exploring HN by mapping and analyzing 40M posts and comments for fun
- Show HN: An SQS Alternative on Postgres
- How to Use JSON Path
- Why SQLite Uses Bytecode
- BeeBase, a programmable relational database with graphical user interface
- Supabase Storage now supports the S3 protocol
- Redis is forked
- Loading a trillion rows of weather data into TimescaleDB
- Neon Serverless Postgres is generally available
- We are moving to General Availability
- Redis re-implemented with SQLite
- Show HN: Using Google Sheets as the back end/APIs of your app
- Code search is hard
- Distributed SQLite: Paradigm shift or hype?
- Chronon, Airbnb's ML feature platform, is now open source
- Saving cloud costs by writing our own database
- Redict 7.3.0, a copyleft fork of Redis, is now available
- Your database skills are not 'good to have' (2023)
- DeWitt and Stonebraker's "MapReduce: A major step backwards" (2009)
- Simon Riggs has died
- The Great Migration from MongoDB to PostgreSQL
- Friends don't let friends export to CSV
- Pack: A new container format for compressed files
- Ask HN: How should organize and back up 23 TiB of personal files?
- SQL is syntactic sugar for relational algebra
- Garnet – A new remote cache-store from Microsoft Research
- Compressing chess moves for fun and profit
- Pg_hint_plan: Force PostgreSQL to execute query plans the way you want
- Postgres is eating the database world
- How Figma's databases team lived to tell the scale
- Show HN: Comma Separated Values (CSV) to Unicode Separated Values (USV)
- DBeaver – open-source database client
- Pg_vectorize: Vector search and RAG on Postgres
- Show HN: We built the fastest spreadsheet
- Pql, a pipelined query language that compiles to SQL
- Is Tableau Dead?
- Apache Superset
- Show HN: PRQL in PostgreSQL
- My notes on Gitlab's Postgres schema design (2022)
- Observable 2.0, a static site generator for data apps
- Show HN: Aldi Price Map
- Is the "modern data stack" still a useful idea?
- Postgres as queue
- What's new in the Postgres 16 query planner
- Show HN: Daily price tracking for Trader Joe's
- SQL for data scientists in 100 queries
- PostgreSQL is enough
- UUID v7
- Why Postgres RDS didn't work for us
- SeaweedFS fast distributed storage system for blobs, objects, files and datalake
- We built our customer data warehouse all on Postgres
- Command-line Tools can be 235x Faster than your Hadoop Cluster (2014)
- Shouldn't FROM come before SELECT in SQL? (2011)
- Are we at peak vector database?
- Waterway Map
- Qdrant, the Vector Search Database, raised $28M in a Series A round
- Ceph: A Journey to 1 TiB/s
- We migrated our PostgreSQL database with 11 seconds downtime
- Apple built iCloud to store billions of databases
- Vector Databases: A Technical Primer [pdf]
- Databases and why their complexity is now unnecessary
- Polars
- UK 2022 rail station flow images
- Fake Trees: Using Indents for Simpler UIs
- Understanding Parquet, Iceberg and Data Lakehouses
- How the append-only btree works (2010)
- Website search hurts my feelings
- SQL as API
- Do you really need foreign keys?
- Jepsen: MySQL 8.0.34
- Moving from relational data to events
- Database Fundamentals
- Fly Postgres, Managed by Supabase
- Open and portable Postgres-as-a-service. Also available on Hetzner
- Zero downtime Postgres upgrades
- What if an SQL statement returned a database?
- River: A fast, robust job queue for Go and Postgres
- Operating on a minimal two-core Postgres instance: Query optimization insights
- Horrible edge cases to consider when dealing with music (2022)