1441
DeWitt Clause, or can you benchmark %database% and get away with it
The DeWitt clause lets database vendors forbid publishing benchmarks. What the clause is, which vendors still use it, and what you can legally publish.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1442
Some thoughts on machine learning with small data
I feel techniques for making machine learning work with small data are not talked about enough. This makes sense because many ML applications are only possible by collecting a huge amount of data. …
1443
1444
1445
Architecture Notes: Datasette
Simon is the creator of Datasette and co-creator of Django web framework. Formerly he was a JSK journalism fellow at Stanford, and prior to that an Engineering Director at Eventbrite.
1446
Range joins in DuckDB
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.
1447
How I Built Zig-SQLite
Article explaining how to leverage Zig's compile time metaprogramming to build a SQLite wrapper that can type check SQL queries
1448
AlloyDB for PostgreSQL under the hood: Columnar engine
In this technical deep dive, we take a look at the columnar engine that delivers industry leading query performance for AlloyDB for PostgreSQL.
1449
The end of big data
Databricks, Snowflake, and the end of an overhyped era.
1450
Useful Python decorators for data scientists
I show toy implementations of Python decorator patterns that may be useful for Data Scientists.
1451
Speeding up sort performance in Postgres 15
Deep dive into the sort performance improvements in PostgreSQL 15, along with charts to visualize what types of queries will be faster. Includes speedups in single column sorts, reduced memory consumption with generation memory context, specialized sort routines for common datatypes, & use of k-way merge.
1452
How Airbnb Built “Wall” to prevent data bugs
Gaining trust in data with extensive data quality, accuracy, and anomaly checks.
1453
Unfinished Business with Postgres
7 years ago I left Heroku. Heroku has had a lot of discussion over the past weeks about its demise, whether it was a success or failure, and the current state. Much of this was prompted by the recent, and on-going security incident, but as others have pointed out the product has been frozen in time for some years now…
1454
1455
Super-Structured Data: Rethinking the Schema
Dealing with real-world data is hard. You often end up stuck between the document model of JSON and the relational model of SQL databases. There's a better way. It's called super-structured data.
1456
OpenTelemetry Traces and PostgreSQL
Fully managed PostgreSQL from the creators of TimescaleDB. 99.9% uptime SLA, 10,000+ IOPS, columnar compression up to 95%, and built-in search. Try it free.
1457
JSON and Virtual Columns in SQLite
Faster JSON handling in a relational database.
1458
Cron-based backup for SQLite
Litestream replicates SQLite databases in real-time to S3.
1459
Monarch: Google’s Planet-Scale In-Memory Time Series Database
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!
1460
Time-Series Compression Algorithms
These algorithms aren't magic – but combined they can save over 90% of storage costs and speed up queries. Here’s how 5 common ones work.
1461
SQLite in Go, with and Without Cgo
Most people use the mattn/go-sqlite3 package to interact with SQLite in Go. This package uses cgo and bundles the SQLite C amalgamation files with the Go source.
1462
Friendlier SQL with DuckDB
DuckDB offers several extensions to the SQL syntax. For a full list of these features, see the Friendly SQL documentation page.
1463
BERTopic: The Future of Topic Modeling
BERTopic takes advantage of the superior language capabilities of (not yet sentient) transformer models and uses some other ML magic like UMAP and HDBSCAN to produce what is one of the most advanced techniques in language topic modeling today.
1464
D1: Our SQL database
Today, we’re excited to announce D1, Cloudflare’s first SQL database, designed for Cloudflare Workers
1465
I'm all-in on server-side SQLite
Ben Johnson has joined Fly.io
1466
When buying the dip doesn’t work: An analysis of the dot-com crash
When a sale isn’t quite what it seems to be
1467
Demystifying Database Performance for Developers
For developers, databases are basically magic. Like Penn & Teller, this blog post is set to break the illusion. Databases are just like any other code, they have algorithms and processes. These algorithms and processes are meant to improve performance, but can cause limitations if they are not expected.
1468
1469
Backblaze Drive Stats for Q1 2022
Backblaze wants to be as transparent as possible with our customers about our business. Here’s what you need to know about our drives in Q1 2022.
1470
Datasette Lite: a server-side Python web application running in a browser
Datasette Lite is a new way to run Datasette: entirely in a browser, taking advantage of the incredible Pyodide project which provides Python compiled to WebAssembly plus a whole suite …