How to use row level security to restrict internal access to PostgreSQL databases. How to configure access restrictions dynamically.

Deep dive into more advanced use of window functions with window frames

PostgreSQL connection strings embedded in your application can take two different forms: the key-value notation or the postgresql:// URI scheme. When it comes to using psql though, another form of connection string is introduced, with command line options -h -p -U and environment variable support. In this short article you will learn that you can use either of the three different forms in psql and thus easily copy & paste you application connection string right at the console to test it!

PERIODs and SYSTEM VERSIONING for PostgreSQL. Contribute to xocolatl/periods development by creating an account on GitHub.

An open source time-series SQL database optimized for fast ingest and complex queries built for IoT and powered by PostgreSQL.

Changing the password for a PostgreSQL database user involves two steps: The change in the database and the change in the application code. This blog post describes how to do this without any downtime or failed authentication tries.

A Node.js PostgreSQL client with runtime and build time type safety, and composable SQL. - GitHub - gajus/slonik: A Node.js PostgreSQL client with runtime and build time type safety, and composable...

Learn the different use cases for when to use Postgres 11 with JSONB and when to use a NoSQL database such as Couchbase. Start learning with Couchbase today.

Jobin Augustine talks about PostegreSQL simple C extension development for a novice user, along with its performance advantages.

What is more beneficial: Using separate or combined indexes in your PostgreSQL database? Speed performance by understanding index scans.

A PostgreSQL extension for collecting statistics about predicates, helping find what indices are missing - GitHub - powa-team/pg_qualstats: A PostgreSQL extension for collecting statistics about pr...

In this blog post, we will see how we can improve some of your SQL's with automatic index recommendations.

Migrate to PostgreSQL in a single command! Contribute to dimitri/pgloader development by creating an account on GitHub.

pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search - GitHub - Casecommons/pg_search: pg_search builds ActiveRecord named scopes that take advantage of ...

A simple tool to help administrators restore PostgreSQL databases periodically

Bloom indexes in PostgreSQL are helpful when there is a table storing huge amounts of data and a lot of columns.

Here’s a little trick I worked out a while back. Along the way I’llintroduce two tools, direnv and Nix, which I’ve found super helpful whendeveloping many di...

ActiveRecord PostgreSQL Adapter extension for using a cursor to return a large result set - GitHub - afair/postgresql_cursor: ActiveRecord PostgreSQL Adapter extension for using a cursor to return ...

I tend to use cron(1) to schedule some automated tasks on the database server side, and since I discovered the pg_cron extension, I decided to try it. Here are some impressions.

10 PostgreSQL gems not to be missed

In our previous post, we explored locking behavior in Postgres and which types of operations hold locks against other. In this post, we highlight 7 common mistakes developers face dealing with Postgres locks. A list of do’s & don’ts based on our work with developers building apps on top of Postgres and Citus.

The nuance between timestamp with and without time zone

A Postgres Proxy to Mask Data in Realtime. Contribute to TonicAI/masquerade development by creating an account on GitHub.

We have already got acquainted with PostgreSQL indexing engine and the interface of access methods and discussed hash indexes , B-trees , as well as GiST and SP-GiST indexes. And this article will...