991
Modern SQL: With – Organize Complex Queries
The WITH clause adds named subqueries to SQL queries. WITH is also known as Common Table Expression (CTE).
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
992
Pipelining in psql (PostgreSQL 18)
the psql client version 18 comes with pipelining, which can speed up client-server communication. In this post, let's see how it works and how much can be g...
993
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…
994
Understanding Postgres Performance
Update theres a more recent post that expands further on where to start optimizing specific queries, and of course if you want to dig into optimizing your infrastructure High Performance PostgreSQL is still a great read For many application developers their database is a black box. Data goes in, comes back out and in…
995
996
997
An Introduction to Conflict-Free Replicated Data Types
This is an interactive tutorial series about Conflict-Free Replicated Data Types, or CRDTs for short. Their purpose is to allow seamless replication of data on different nodes in a distributed system. Merging is by construction always possible, without any conflicts. This series assumes no knowledge about CRDTs, but…
998
How I Write SQL, Part 1: Naming Conventions (2014)
"There are only two hard problems in Computer Science: cache invalidation and naming things."
999
How should you build a high-performance column store for the 2020s?
Though most relational databases (like MySQL) are "row oriented", in that they keep rows stored together... experience has taught us that pivoting the data arrow so that columns, and not rows, are stored together can be beneficial. This is an old observation that most experienced programmers know about as the…
1000
1001
1002
Phases of Netflix’s real-time data infrastructure
The blog post will share the four phases of Real-time Data Infrastructure’s iterative journey in Netflix (2015-2021). For each phase, we will go over the evolving business motivations, the team’s unique challenges, the strategy bets, and the use case patterns we discovered along the way.
1003
1004
How to implement Q&A against your docs with GPT3 embeddings and Datasette
If you’ve spent any time with GPT-3 or ChatGPT, you’ve likely thought about how useful it would be if you could point them at a specific, current collection of text …
1005
1006
1007
What Shapes Do Matrix Multiplications Like?
Divining order from the chaos
1008
Migrating to CockroachDB
CockroachDB is a newSQL database, behaving much like a traditional database while providing consistent HA and scalability out of the box.
1009
Strong Eventual Consistency – The Big Idea Behind CRDTs
Missing the Forest for the Sequence Trees.
1010
What Percent of the Top-Voted Comments in Reddit Threads Were Also First Comment?
Are commenters ’late to this thread’ indeed late?
1011
Building a high-performance ticketing system with TigerBeetle
Rene Schallner (@renerocksai): software engineer turned AI researcher and engineer, in Vienna.
1012
An opinionated map of incremental and streaming systems
Disclaimer: I used to work for Materialize which is one of the systems being compared in this post.
1013
Inserting 130M SQLite rows per minute from a scripting language
The other week, I stumbled on the post Inserting One Billion Rows in SQLite Under A Minute , which was a funny coincidence, as I was just in...
1014
How to Learn Hadoop for Free
KOITOTO LOGIN menghadirkan akses cepat, aman, dan praktis untuk pengalaman hiburan online modern dengan navigasi responsif, performa stabil, serta kenyamanan maksimal setiap waktu.
1015
1016
A visual explanation for regularization of linear models
A deep dive into exactly how regularization works, using visualizations rather than (just) mathematics. This article also dispels some myths and answer some important questions about Lasso and Ridge regression.
1017
US Postal Service data suggests significant population decline in San Francisco
PengelKeluaran SGP Hari Ini Resmi Togel Singapore Pools Tersedia Melalui Data SGP Prize dan Menyalin Pengeluaran SGP Hari Ini Untuk Pemain Toto SGP.
1018
DSM Disorders Disappear in Statistical Clustering of Psychiatric Symptoms (2024)
Whither Major Depression?
1019
1020
Building data infrastructure that will last
As a consultant, I have been called in to review and, in many cases, replace dozens of half-finished, abandoned, and sometimes forgotten data infrastructure projects.