rcmnd

The GuardianCompany

UK news publisher; its developer blog covers the engineering behind theguardian.com.

6 things

PostgreSQLSoftware

recommended

Another great thing about Postgres is how mature it is: every question we wanted to ask had in most cases already been answered on Stack Overflow.

Why the Guardian moved its CMS content store from MongoDB to PostgreSQL on Amazon RDS

theguardian.com ↗·2018-11-30Wrong?

ReactSoftware

uses

We’ve rebuilt it using React and Typescript and whilst it looks pretty similar to our old website, what’s underneath is all new.

The Guardian rebuilt theguardian.com on React and TypeScript

theguardian.com ↗·2019-12-08Wrong?

TypeScriptSoftware Microsoft

uses

We’ve rebuilt it using React and Typescript and whilst it looks pretty similar to our old website, what’s underneath is all new.

The Guardian rebuilt theguardian.com on React and TypeScript

theguardian.com ↗·2019-12-08Wrong?

PostgreSQLSoftware

uses

We use Amazon’s RDS (Relational Database Service) to store our data in a PostgreSQL database.

A Guardian service storing data in PostgreSQL on Amazon RDS

theguardian.com ↗·2019-12-02Wrong?

ScalaSoftware

uses

We wrote a proxy in Scala using Akka Streams

The Guardian built its Mongo-to-Postgres migration proxy in Scala

theguardian.com ↗·2018-11-30Wrong?

Amazon DynamoDBService

mixed

Unfortunately at the time Dynamo didn’t support encryption at rest.

DynamoDB was the obvious choice for the Guardian CMS migration off MongoDB but lacked encryption at rest

theguardian.com ↗·2018-11-30Wrong?

MongoDBSoftware

disliked

It also didn’t deliver on its “one-click upgrade” promise, due to changes in the authentication schema between different versions of Mongo DB.

Why the Guardian moved its CMS content store off MongoDB and its OpsManager tooling

theguardian.com ↗·2018-11-30Wrong?

Every entry is a verbatim quote and a link to the public post it came from. Nothing is paraphrased. If it is not on record somewhere public, it is not here.

The verdict is what they actually said: loved and liked are explicit; recommended means they told others to get it; uses means they only say they use it; read is a book on their public shelf with no verdict; mixed and disliked are kept too.

A dashed affiliate link, sponsored or their own label means the post disclosed a relationship. It is shown, never hidden.

The small bar beside a date shows how dated a recommendation is for its kind of thing.

The bar shows how dated a recommendation is, for its kind of thing. Full and green is recent. It drains, and turns amber and then grey, as the post gets older.

What counts as old depends on the thing. A laptop praised four years ago has been replaced twice; a book loved twenty years ago is probably still loved. The bar is empty after about:

A striped bar means the post carries no date and the date shown is an estimate. No date at all, no bar.