121
How Time Series Databases Work, and Where They Don’t
This blog takes a deep dive into the hows and whys of time series databases—and why Honeycomb couldn't be limited to a TSDB implementation.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 314 posts.
122
Replacing Elasticsearch with Rust and SQLite (2017)
Caveat: Elasticsearch is a multi-purpose, distributed, battle-tested, schema-free, log and document storage engine. We’ll be replacing it with a single-purpose, relational schema, me-tested, and custom nginx access log storage engine. Knowing that, let’s begin. Find this project on Github After building my home…
123
I don't think Elasticsearch is a good logging system
I’ve been a heavy user of ElasticSearch for coming up 7 years now. During that time I’ve used it for a few main usecases: A Search Engine, An APM Solution (after NewRelic started being stupidly expensive), a backend for Jaeger, and as a log storage system. In all of those usecases I’ve really pushed ElasticSearch to…
124
PostgreSQL EXPLAIN Output Explained
UPDATED July 2023: How to use EXPLAIN ANALYZE in PostgreSQL, learn tools to visualize the output. See query execution time and row count.
125
126
Citus 10 brings columnar compression to Postgres
Deep dive into Citus columnar storage for Postgres. Includes a quickstart, as well as performance measurements for data loading, compression ratios, and query response times. Also covers how columnar relates to Citus, integration with Postgres range partitioning, limitations, & ways to get started.
127
100M Posts Analyzed: What You Need to Write the Best Headlines
Write better headlines with tactics from our analysis of 100 million headlines. Discover the best headline trigrams for Facebook, Twitter & more.
128
Databricks response to Snowflake's accusation of lacking integrity
Analyze the claims made by Snowflake regarding price/performance compared to Databricks and the counterarguments presented.
129
Ribbon filter: Practically smaller than Bloom and Xor
What the research is: The Ribbon filter is a new data structure that is more space-efficient than the popular Bloom filters that are widely used for optimizing data retrieval. One of the ways that …
130
131
132
Zillow, Prophet, time series, and prices
So I made a mildly controversial tweet. Lots of people enjoyed it, but the LinkedIn-adjacent section of data science Twitter is not happy about it. I want to provide as much context for it as I can…
133
DuckDB-Wasm: Efficient analytical SQL in the browser
DuckDB-Wasm is an in-process analytical SQL database for the browser. It is powered by WebAssembly, speaks Arrow fluently, reads Parquet, CSV, and JSON files backed by Filesystem APIs or HTTP requests, and has been tested with Chrome, Firefox, Safari, and Node.js. You can try it at shell.duckdb.org or on Observable.
134
The Rise and Fall of the OLAP Cube (2020)
A definitive history of the rise of the OLAP cube, how it's affected our industry, and what comes after.
135
PostgreSQL, Memory and the Cloud
This post explains how Linux memory overcommit and OOM-killer behavior can turn a single runaway query into a full PostgreSQL crash, and why many managed cloud database services fail to disable overcommit the way self-hosted PostgreSQL recommends.
136
137
138
PostgreSQL on ARM-Based AWS EC2 Instances
With the second gen of Graviton2 instances announced, we decided to take a look at the price/performance from the standpoint of running PostgreSQL.
139
Data-Mining Wikipedia for Fun and Profit
The engineering blog of Bill P. Godfrey.
140
PostgreSQL: Kubegres is available as open source
[Kubegres](https://www.kubegres.io) is an open-source Kubernetes operator allowing to deploy a cluster of PostgreSql instances with data replication enabled out-of-the box. …
141
UUID, serial or identity columns for PostgreSQL auto-generated primary keys?
How to decide what to use for autogenerated primary keys: UUID, serial or identity column? Recommendations are given!
142
Relational databases aren’t dinosaurs, they’re sharks
Oh relational databases, that tired old relic of another age. Codd and friends were great in their time, but serious software engineers need to move on. People building Web Scale™ software You’ve probably heard a similar sentiment at some point. That relational databases were great, but they are dinosaurs that are…
143
New PostgreSQL Interface for Cloud Spanner
Start building on Google Cloud with $300 in free credits and 20+ always free products.
144
145
146
AWS Babelfish: The Elephant in the PostgreSQL Room?
Fundación PostgreSQL
147
Cross-Database Queries in SQLite
I released Datasette 0.55 and sqlite-utils 3.6 this week with a common theme across both releases: supporting cross-database joins. Cross-database queries in Datasette SQLite databases are single files on disk. …
148
Spotify Optimized the Largest Dataflow Job Ever for Wrapped 2020
In this post we’ll discuss how Spotify optimized and sped up elements from our largest Dataflow job, , for using a technique called Sort Merge Bucket (SMB) join. We’ll present the design and implementation of SMB and how we incorporated it into our data pipelines.
149
Introduction to Window Functions in SQL
It is interesting that many people working with data have no clue about window functions in SQL. During a long period of time instead of using window functions, I preferred coding in Python and panda…
150
