📰 Dev.to · Franck Pachot

Your connection to PostgreSQL is handled by a dedicated backend process. If that process crashes, you...

PostgreSQL provides several planner configuration parameters, such as enable_seqscan and...

In a previous post, I explored how MongoDB chooses between nested loop, indexed loop, and hash join...

Azure HorizonDB is a new database service on Azure. It is PostgreSQL-compatible from a developer...

Last year, I examined RUM indexes within this series on multi-key indexing, demonstrating that they...

Before looking at PostgreSQL, I'll first introduce the problem by showing how MongoDB's document...

In PostgreSQL, autovacuum and autoanalyze exist to clean up dead tuples (old versions of...

Many developers believe they need a relational database because their data has relationships. The...

The Internet Archive holds some real gems. Let’s trace the origins of MongoDB with links to its...

SQL databases use query planners (often cost-based optimizers) so developers don’t worry about...

In DynamoDB, a single-table design stores one-to-many relationships in a single physical block while...

In the previous post on consistency boundaries, we saw that an updatable join view can hide a...

Two common myths surround database consistency: Myth 1: Only SQL databases provide strong...

SQL databases are grounded in relational algebra, but they are not the only databases with a strong...

In MongoDB, all data manipulation operations are transactional and ACID. Single-document operations...

PostgreSQL auto-analyze collects statistics on tables with rows. For partitioned tables, it excludes...

The relational model was designed not to mirror application structures, but to optimize reasoning...

In databases designed for high availability and scalability, secondary nodes can fall behind the...

A document database is more than a JSON datastore. It must also support efficient storage and...

Relational composition is to joins what the cartesian product is to tables: it produces every result...

Relational database joins are, conceptually, a cartesian product followed by a filter (the join...

Prisma is an ORM (Object-Relational Mapper). With MongoDB, it acts as an Object Document Mapper,...

MongoDB guarantees durability—the D in ACID—over the network with strong consistency—the C in the CAP...

I learned about normal forms when databases were designed before the applications that used them. At...