1921
TimescaleDB 2.0 released, now distributed multi-node
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.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
1922
Markov Chain Monte Carlo (MCMC) Sampling, Part 1: The Basics (2019)
In this first post of Tweag’s four-part series on Markov chain Monte Carlo sampling algorithms, you will learn about why and when to use them and the theoretical underpinnings of this powerful class of sampling methods. We discuss the famous Metropolis-Hastings algorithm and give an intuition on the choice of its free…
1923
NYC taxi meter and options pricing
An experiment analyzing the NYC taxi dataset through the eyes of an options trader.
1924
Improving Postgres Connection Scalability: Snapshots
Improving connection scalability in Postgres 14. From the neat to the gritty: snapshot scalability edition.
1925
Reverse-engineering the problematic tail behavior of Fivethirtyeight forecast
We’ve been writing a bit about some odd tail behavior in the Fivethirtyeight election forecast, for example that it was giving Joe Biden a 3% chance of winning Alabama (which seemed high), it was displaying Trump winning California as in “the range of scenarios our model thinks is possible” (which didn’t seem right)…
1926
Amazon RDS on Graviton2 Processors
I recently wrote a post to announce the availability of M6g, R6g and C6g families of instances on Amazon Elastic Compute Cloud (Amazon EC2). These instances offer better cost-performance ratio than their x86 counterparts. They are based on AWS-designed AWS Graviton2 processors, utilizing 64-bit Arm Neoverse N1 cores…
1927
What ORMs Have Taught Me: Just Learn SQL (2014)
I’ve come to the conclusion that, for me, ORMs are more detriment than benefit. In short, they can be used to nicely augment working with SQL in a program, but they should not replace it.
1928
SQLite now allows multiple recursive SELECT statements in a single recursive CTE
Is there any command to see the history of a file beyond renames, similar to git log --follow <file> ?
1929
Backblaze Hard Drive Stats Q3 2020
A look at the performance of 150,757 hard drives in the Backblaze data centers.
1930
The surprising impact of medium-size texts on PostgreSQL performance
Why TOAST is the best thing since sliced bread
1931
How to better calculate churn rates
According to Andreessen Horowitz, this number is one of the top 16 metrics to measure a SaaS startup by. Well, sorry Andreessen, and sorry Horowitz, but this just isn't right.
1932
Python For Feature Film
A look into how Python is used to bring your favorite movies to the big screen.
1933
Emerging Architectures for Modern Data Infrastructure
To help data teams stay on top of the changes happening in the industry, this article reviews an updated set of data infrastructure architectures.
1934
Lessons from Bug Hunters Who've Found 400 Bugs in Popular DBMSs
TiDB is the distributed SQL database built for AI agents. Vectors, transactions, and analytics in one engine with ACID guarantees and elastic scale.
1935
Pg_stat_monitor – better insights into query performance in PostgreSQL
Percona has developed a new pg_stat_monitor plugin for PostgreSQL which captures all the details in order to provide deep query performance insights.
1936
Visidata 2.0
This is a major milestone. After almost 2 years of development, version 2.0 of VisiData is finally released. It's got several major improvements, a bunch of new loaders, and tons of new features and quality of life improvements. And, most importantly, an API specification for plugins.
1937
Applying Textbook Data Structures for Real Life Wins
How we leveraged a textbook data structure in our core platform and achieved a 15x speed up for a key data processing step.
1938
1939
Loading CSV File at the Speed Limit of the NVMe Storage
I plan to write a series of articles to discuss some simple but not embarrassingly parallel algorithms. These will have practical usages and would most likely be on many-core CPUs or CUDA GPUs. Today’s is the first one to discuss a parallel algorithm implementation for CSV file parser.
1940
A Short Story About SQL’s Biggest Rival
A short story about SQL's better rival: Michael Stonebraker's storied query language, QUEL.
1941
Machine Learning Engineer Guide: Feature Store vs. Data Warehouse
The feature store is a data warehouse of features for machine learning (ML)....
1942
PostgreSQL community impact of 2nd Quadrant purchase
This blog is about my work on the Postgres open source database, and is published on Planet PostgreSQL. PgLife allows monitoring of all Postgres community activity.
1943
Generalizing 'jq' and Traversal Systems using optics and standard monads
The Personal blog and musings of Chris Penner, a designer, developer and future opsimath.
1944
Gradient Boosted Decision Trees
From zero to gradient boosted decision trees
1945
Time for a WTF MySQL Moment
Documenting the reasons why I tend to prefer Postgres - even when it's my friends getting bitten.
1946
1947
Why is Snowflake so Valuable?
An overview of some of the reasons Snowflake is trading at 150x its revenue.
1948
APFS changes in Big Sur: how Time Machine backs up to APFS
APFS adds 6 volume roles, including one which supports Time Machine backups. And per-file encryption is coming.
1949
CRDTs are the future
I saw Martin Kleppmann’s talk a few weeks ago about his approach to realtime editing with CRDTs, and I felt a deep sense of despair. Maybe all the work I’ve been doing for the past decade won’t be part of the future after all, because Martin’s
1950
PostgreSQL 13
The PostgreSQL Global Development Group today announced the release of [PostgreSQL 13](https://www.postgresql.org/docs/13/release-13.html), the latest version of the world’s [most advanced …