Topics /

Databases & Data

The most popular blog posts about databases & data on Hacker News. 332 posts.

2017
275

Amazon Aurora with PostgreSQL Compatibility

Late last year I told you about our plans to add PostgreSQL compatibility to Amazon Aurora. We launched the private beta shortly after that announcement, and followed it up earlier this year with an open preview. We’ve received lots of great feedback during the beta and the preview and have done our best to make […]

279

Prime Day 2017: 12.9M DynamoDB requests per second

The third annual Prime Day set another round of records for global orders, topping Black Friday and Cyber Monday, making it the biggest day in Amazon retail history. Over the course of the 30 hour event, tens of millions of Prime members purchased things like Echo Dots, Fire tablets, programmable pressure cookers…

293

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.

294

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