Topics /

Databases & Data

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

2020
1

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

4

Jepsen: PostgreSQL 12.3

PostgreSQL is a major open-source relational database with a 23-year history and a broad range of features. While Jepsen’s work has traditionally focused on distributed systems, our tooling is readily applicable to traditional, single-node databases. In this report, we present the results of applying Jepsen’s…

10

Jepsen: MongoDB 4.2.6

2020-05-26: MongoDB identified a bug in the transaction retry mechanism which they believe was responsible for the anomalies observed in this report; a patch is scheduled for 4.2.8.

14

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 …

16

SQLite Is Serverless

Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the…

21

Data Science: Reality Doesn't Meet Expectations

OLXTOTO adalah situs menyediakan link alternatif untuk login tanpa hambatan yang di rancang agar pemain bermain lebih stabil dan optimal apabila domain utama mengalamin kendala. Nike Hat Size 6 1/2 6 5/8 6 3/4 6 7/8 7 7 1/8 7 1/4 7 3/8 7 1/2 7 5/8 7 3/4 Head Size (CM) 52 53 54 55 56 57 58 59 60 61 62 Alpha Size - - XS…

23

Advanced SQL and database books and resources

For people who've worked through Mastery with SQL , a common question I get is "What's next?" If you completed the course and all 150+ exercises, at this point you'll have a very strong grasp of SQL and should be comfortable writing all sorts of complex queries. However, there's more to working with databases…

27

A humble guide to database schema design

Having a good database schema design is crucial for building applications that will need to scale in traffic and complexity. If you happen to do a bad design choice you will see that it takes a lot of effort to stop the pattern from propagating to your backends’ services and controllers, and finally to your frontend.