This article explains in simple steps how to improve security in PostgreSQL by converting from MD5 hashes to scram-sha-256.

Hypothetical Indexes for PostgreSQL. Contribute to HypoPG/hypopg development by creating an account on GitHub.

It's a common architecture to have PostgreSQL and Redis serve as the backbone of your app, but PostgreSQL may be capable of everything you use Redis for.

In the recent Postgres Community Survey by Timescale, nearly 50% of users reported that they started using Postgres within the last 5 years, …

A cloud-native database based on PostgreSQL developed by Alibaba Cloud.

V8 Engine Javascript Procedural Language add-on for PostgreSQL

This article is about bulk loading, which is the quickest way to import large amounts of data into a PostgreSQL database.

Learn how to create and implement a row level security policy in Rails, allowing to limit the database rows a user can access.

Presentation materials for the Annotated.Conf Tutorial

Understanding & mitigating randomly slow writes in PostgreSQL

Search through user-provided HTML content with PostgreSQL and Active Record.

With some tweaking Postgres can be a great data warehouse. Here's how to configure it.

Learn how to create a read only user in Postgres both now and with a look ahead to Postgres 14.

Migrating our largest table's primary key from an integer to a bigint with zero downtime.

Broadcast, Presence, and Postgres Changes via WebSockets

Open-source vector similarity search for Postgres. Contribute to pgvector/pgvector development by creating an account on GitHub.

We create domain types and composite types in PostgreSQL and show how to hook into the Rails Attributes API to help instantiate them as objects that Ruby can use.

You might have seen the error message: "ERROR: deadlock detected". This article explains what this really means and how deadlocks can be prevented.

Get insight into how the PostgreSQL optimizer works and how it speeds up queries. Find out about anti-join & from_collapse_limit.

Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL. - GitHub - apache/age: Graph database optimized for fast analysis and real-ti...

AGE was under development since 2019 by a team of engineers at Bitnine Global Inc. The project, originally born out of AgensGraph, a multi-model graph database fork of PostgreSQL, was donated to the Apache Software Foundation and entered incubation in April 2020.

Over the last few years, the software development community’s love affair with the popular open-source relational database has reached a…

PostgreSQL extension to create, manage and use Oracle-style Global Temporary Tables and the others RDBMS - GitHub - darold/pgtt: PostgreSQL extension to create, manage and use Oracle-style Global T...