database

A month ago, during a release to production, the feature I was working on failed to deploy due to a PostgreSQL restriction. It turned out to be a surprisingly fun and comprehensive learning moment.

PostgreSQL Development Conference, aka "PGConf.dev", is where users, developers, and community organizers come together to focus on PostgreSQL development an...

The CIS Benchmark for Postgres is a free, community supported, security checklist for Postgres.

Boost PostgreSQL full-text search speed by 50x with simple optimizations. Use VectorChord-BM25 to accelerate and better BM25 ranking in postgres.

Learn practical SQL & PostgreSQL techniques. Build rock-solid data systems with 'boring' database solutions that deliver reliability without the drama.

Master advanced Data Engineering with this 2025 roadmap! Explore tools, skills, and resources to excel in Python, SQL, CI/CD, AI, cloud, and more

Download Open Datasets on 1000s of Projects + Share Projects on One Platform. Explore Popular Topics Like Government, Sports, Medicine, Fintech, Food, More. Flexible Data Ingestion.

Solve SQL interview questions

SQL Exercises, Practice, Solution: Structured Query Language (SQL) is a language used to view or change data in databases. The sentences used in this language are called SQL Queries.

An issue I often see folks missing when reviewing query plans, is that they see that all of their scans involve indexes and they think that the query is likely already as fast (or efficient) as it can be. In this post we’ll look through several examples, some things to look out for, and how to then

Semantic caching is changing how we optimize systems reliant on large language models. By using vector embeddings, it enables faster queries.

An SQL optimization guide for developers. With best practices, warnings, and pro tips to speed up your SQL query optimization.

If you had to store something for 100 years, how would you do it?

I’ve been working professionally for the better part of a decade on web apps and, in that time, I’ve had to learn how to use a lot of different systems and tools. During that education, I found that the official documentation typically proved to be the most helpful.

Introduction When modeling a Postgres database, you probably don’t give much thought to the order of columns in your tables. After all, it seems like the kind of thing that wouldn’t affect storage or performance. But what if I told you that simply reordering your columns could reduce the size of your tables and indexes by 20%? This isn’t some obscure database trick — it’s a direct result of how Postgres aligns data on disk.\n

p PostgreSQL became a go-to SQL database for many developers over the past couple of years. While being an SQL database, Postgres also includes a lot of ...

A deep technical dive into all things Redis. Covering various Redis topologies, data persistence and process forking.

Optimizing Postgres's Autovacuum for High-Churn Tables

How to monitor replication lag in PostgreSQL? What is replication lag? And how to best go about monitoring PostgreSQL replication in general?

Build a legacy data migration checklist: Experts offer advice from migration preparation to ensuring the project is successfully completed.

Engineer Bo Ingram shares insight into how Discord shoulders its traffic and provides a platform for our users to communicate.

Organizations have many choices when it comes to databases. In this article, Robert Sheldon explains how to choose between SQL and NoSQL databases.

This article will provide an overview on database architectures, including use cases and pros and cons for each of them.

This is a comprehensive guide, packed with best practices and expert insights about proper deployment, to master the art of seamless database migrations.

This article on SQL vs NoSQL will demistrify the differences between these backend databases, and also dicusses the differences between MySQL and MongoDB.

Embedding Yjs and Automerge into Postgres for collaborative applications.