1351
SQLite 3.39.3
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site .
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1352
Scraping data from an app: real world example
How to inspect the network traffic of an app with Fiddler Everywhere and scrape the data from its servers.
1353
A Short Chronology of Deep Learning for Tabular Data
Occasionally, I share research papers proposing new deep learning approaches for tabular data on social media, which is typically an excellent discussion…
1354
DBOS: A database-oriented operating system
Today, most people develop applications on operating systems such as Linux which are more than thirty years old, even though computing has changed a lot in the meantime. Since Linux was first released in 1991, the size of application state and data has grown by several orders of magnitude, many applications have moved…
1355
Roaring bitmaps: what they are and how they work
A detailed primer on Roaring bitmaps explaining what they are, how they're different from traditional bitmaps, and how they work internally.
1356
Notes on the SQLite DuckDB Paper
SQLite: Past, Present, and Future is a newly published paper authored by Kevin P. Gaffney, Martin Prammer and Jignesh M. Patel from the University of Wisconsin-Madison and D. Richard Hipp, …
1357
One million queries per second with MySQL
Discover how PlanetScale handles one million queries per second (QPS) with horizontal sharding in MySQL
1358
1359
Understanding Google’s File System (2020)
These paper reviews can be delivered weekly to your inbox , or you can subscribe to the Atom feed . As always, feel free to reach out on Twitter with feedback or suggestions!
1360
PostgreSQL 15: Stats Collector Gone? What’s New?
Yes, the stats collector is gone from PostgreSQL 15, but there's lots of new exciting features to talk about!
1361
How discord stores billions of messages (2017)
We decided early on to store all chat history forever so users can come back at any time and have their data available. This is a lot of data: how do we do it?
1362
A Graph-Based Firebase
In A Database in the Browser , I wrote that the schleps we face as UI engineers are actually database problems in disguise [1] . This begged the question: would a database-looking solution solve them?
1363
PostgreSQL 14 Internals book – Part II
I’m pleased to announce that Part II of the “ PostgreSQL 14 Internals ” book is available now. This part explores the purpose and design of the buffer cache and explains the need for write-ahead logging. Please download the book freely in PDF. There are three more parts to come, so stay tuned! Thanks to Matthew Daniel…
1364
How SQLite scales read concurrency
Understanding how the write-ahead log turns your scaling up to 11.
1365
A Critique of SQL, 40 Years Later
Homepage of Carlin Eng
1366
What's the big deal about embedded key-value databases?
What's the big deal about key-value databases like FoundationDB and RocksDB?
1367
Parsing SQL
SQL is a language to handle data in databases. However, it has limitations and you might need to parse SQL to get around them.
1368
How do cash transfers impact the people who don’t receive them? (2019)
GiveDirectly partnered with academic researchers to find out how cash transfers affect local economies, including nearby non-recipients. Read the results.
1369
Turning SQLite into a Distributed Database
mvSQLite is the open-source , SQLite-compatible distributed database. We decoupled SQLite's storage layer onto FoundationDB to offer massive yet "bottomless" scalability, point-in-time reads, and the strictest level of consistency.
1370
Supabase Vault
Today we're announcing Vault, a Postgres extension for managing secrets and encryption inside your database.
1371
The PlanetScale serverless driver for JavaScript
You can now use PlanetScale in HTTP-only environments like Cloudflare Workers, Vercel Edge Functions, and Netlify Edge Functions.
1372
Learn Postgres at the Playground – Postgres compiled to WASM running in browser
Run Postgres in your local web browser with guided tutorials to help you grow your Postgres skills.
1373
Faster offset pagination for Rails apps
Introducing FastPage a new gem for ActiveRecord that speeds up deep pagination queries.
1374
How to create a blog post title optimizer with GPT-3 and Hacker News data
GPT-3 says the title for this post is very bad.
1375
Why use Paxos instead of Raft?
TLDR: Neon separates storage and compute, substituting the PostgreSQL persistency layer with a custom-made distributed storage written in Rust. Due to this separation, some nodes don’t have persistent disks. The original Raft paper works only with uniform nodes, but Paxos variants support proposers without storage and…
1376
Improving Postgres text search speed
CharityAPI.org improved our Postgres response time so that searches initiated via our API were 760% faster without adding an additional tool like Elastic Search. This is how we did it.
1377
Excel is pretty dang cool
It's like discovering a treasure chest under my kitchen sink
1378
Redis explained
A deep technical dive into all things Redis. Covering various Redis topologies, data persistence and process forking.
1379
The four pillars of data observability: metrics, metadata, lineage, and logs
How much data is enough for observability? Learn the key pillars that describe your data and underpin data observability practices in 2024.
1380
How SQLite Helps You Do ACID
Let's take a peek at how the rollback journal works.