Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 2,338 posts.

Any year
1981

Databases and Distributed Deadlocks: A FAQ

A developer FAQ created by the Citus engineering team when they first began working on distributed deadlock detection in the Citus database. Explores when PostgreSQL acquires locks, when deadlocks occur, and how Citus detects and prevents distributed deadlocks in Postgres.

1983

Getting Started with Event Sourcing in Postgres

In a previous post we explored how our application tracks sent emails. We set things up to update or insert a record for each email with the current state (delivered, dropped, etc). In this post we'll look at an alternative data model where we'll store each event as its own record and then roll up t

1988

SQLite's Use of Tcl (2017)

The design of SQLite was inspired by the design of TCL, both in the way it handles datatypes and in the formatting of its source code. The index use case for SQLite was in a Tcl/Tk application for an industrial company. From its inception, SQLite has always depended heavily on TCL. These days, SQLite no longer uses…

1995

How to Build Your Distributed Database

Citus gives you all the greatness of Postgres plus the superpowers of distributed tables. By distributing your data and queries, your application gets high performance—at any scale. The Citus database is available as open source and as a managed service on Azure.