151
Oops, You Wrote a Database
Those who fail to study databases are doomed to write them
152
Grouping digits in SQL
PostgreSQL 16 was released last week. This is the story of a feature.
153
Batch size one billion: SQLite insert speedups, from the useful to the absurd
A little-discussed method enables inserting rows with bound data into SQLite faster than any existing technique. This novel method is then discovered to have a drawback that makes it generally unusable. The rest of this article explores how to get the best insert performance out of SQLite generally; what's in your…
154
Replacing Pandas with Polars
I remember those days, oh so long ago, it seems like another lifetime. I haven’t used Pandas in many a year, decades, or whatever. We’ve all been there, done that. Pandas I mean. I would dare say it’s a rite of passage for most data folk. For those using Python, it’s probably one of the […]
155
Poor schemas, poor cataloguing: why music tagging sucks
One of the things that frustrates me with having a local music library is the tedium of tagging. While there are tools (like beets or MusicBrainz Picard) to make it easier, I feel there are fundamental issues with the design… Continue reading →
156
Building a Database in the 2020s (2022)
Building a database in the 2020s
157
Pgvector 0.5.0 Feature Highlights and how tos
An overview of new features in pgvector 0.5.0, including HNSW, parallel index builds, and more!
158
159
[109] Data Falsificada (Part 1): “Clusterfake”
This is the introduction to a four-part series of posts detailing evidence of fraud in four academic papers co-authored by Harvard Business School Professor Francesca Gino. In 2021, we and a team o…