241
Propagation of mistakes in papers
A blog by and for database architects.
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 300 posts.
242
243
Building a High Performance Data Integration Framework in Go
Behind the scenes of building CloudQuery — architectural decisions, engineering challenges, and lessons learned creating the open-source cloud asset inventory.
244
Supabase Wrappers: A framework for building Postgres foreign data wrappers
A framework for building Postgres Foreign Data Wrappers which connects to Stripe, Firebase, Clickhouse, and more.
245
It's not Ruby that's slow, it's your database
Many people keep repeating that Ruby is slow. It is. But that doesn't matter, because your database is so much slower that it is the bottleneck. So, an alternative title would be "Ruby is slow, but that doesn't matter for you."
246
MongoDB Releases Queryable Encryption Preview
Today we are announcing the preview release of Queryable Encryption which allows customers to encrypt sensitive data from the client side, store it as fully randomized encrypted data on the database server side, and run expressive queries on the encrypted data. Learn more.
247
Custom SQL functions for data analytics in PostgreSQL
There is a better way to explore and analyze time-series data with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler data.
248
Making Faster B-Trees with Go Generics
Go generics are a new way to improve performance in golang. Let’s see what effect generics had on Google’s B-tree implementation.
249
Dicom File Format Basics
Explore the fundamentals of the DICOM file format! This quick introduction covers the basics of DICOM's structure, its essential uses, and tips for easily navigating its complex and abstract components.
250
SQL + M4 = Composable SQL
I often work with clients who have large “data lakes” or big star schema style enterprise databases with fact and dimension tables as far as the eye can see. Invariably said clients end up with a substantial SQL codebase composed of hundreds of independent queries with lots of overlap between them. I want to be able…
251
One Million Database Connections
Learn how to use PlanetScale to safely include your database in your serverless functions without hitting connection limits in MySQL.
252
RStudio Is Becoming Posit
We are very excited to announce that RStudio has a new name, Posit.
253
SQLite Release 3.40.0
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 .
254
K-Nearest Neighbors
One Machine Learning algorithm that relies on the concepts of proximity and similarity is K-Nearest Neighbor (KNN). KNN is a supervised learning algorithm capable of performing both classification and regression tasks.
255
A sequel to SQL? An intro to Malloy
Homepage of Carlin Eng
256
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.
257
TimescaleDB 2.7 vs. PostgreSQL 14
TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical.
258
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.
259
How the Native American population changed since the last census
The federal government has counted the Native American population in various ways throughout the years. Recent data shows how the demographic is growing.
260
261
How Airbnb Built “Wall” to prevent data bugs
Gaining trust in data with extensive data quality, accuracy, and anomaly checks.
262
Postgres Insider Terminology
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
263
Backblaze Drive Stats for Q3 2022
Q3 2022 Drive Stats: Read the latest insights and check out the data.
264
Filesystems can experience at least three different sorts of errors
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
265
Overview of Consistency Levels in Database Systems
Database systems typically give users the ability to trade off correctness for performance. We have spent the previous two posts in this s...
266
Aggregating away the signal in your data
By aggregating our data in an effort to simplify it, we lose the signal and the context we need to make sense of what we’re seeing.
267
A/B test improved your website's conversion rate? Not so fast
Many internet companies use A/B testing to evaluate the performance of website changes they want to make. A typical metric in such scenarios is the conversion rate (CVR) of a user, i.e. the probability that a user converts (e.g. makes a purchase) on the website. A typical A/B test setup in such a situation would…
268
Migrating from SQLite to PostgreSQL
Product updates, comparisons, and deep dives on database change management, access control, and compliance from the Bytebase engineering team.
269
Partitioning in Postgres, 2022 Edition
Tracking improvements to Postgres partitioning since 2017. In just five years it’s gone from a non-feature to a very good one.
270
Range joins in DuckDB
DuckDB has fully parallelized range joins that can efficiently join millions of range predicates.