Plurrrr

Wed 29 Mar 2023

Postgres: The Graph Database You Didn't Know You Had

PostgreSQL (Postgres), is a powerful relational database that can store a wide range of data types and data structures. When it comes to storing graph data structures we might reach for a database marketed for that use case like Neo4J or Dgraph. Hold your horses! While Postgres is not generally thought of when working with graph data structures, it is perfectly capable to store and query graph data efficiently.

Source: Postgres: The Graph Database You Didn't Know You Had, an article by Dylan Paulus.

On writing better error messages

We as developers need to improve our error messages. Try to be helpful, and explain:

  1. Who caused the error?
  2. What happened, and why?
  3. When will it be fixed?
  4. How can the user respond to the error?

Depending on the type of service you run, you'll likely still need request IDs and other diagnostics in your error message to help your support staff debug the issue.

A human-readable error message doesn't have to come at the expense of removing all technical information.

Source: On writing better error messages, an article by Max Rozen.