Postgres Weekly
Feed since 17 Mar 2019This feed publishes the latest news and updates on one of the most popular open-source relational database systems in the world. See: http://postgresweekly.com/
To subscribe to and get updates from Postgres Weekly in your feed stream, sign up, or see the rest of our feeds.
kyleconroy/sqlc
sqlc 1.8: Generate Type Safe Go(lang) from SQL — You write SQL queries, run sqlc to...
Open-sourcing Datanymizer, in-flight template-driven data anonymization tool by Evrone
Datanymizer: A Database Anonymizer with Flexible Rules — Written in Rust, this tool offers in-flight template-driven...
xo/usql
usql 0.9: A Universal CLI for Databases — A CLI tool (written in Go) for working...
Finding the root cause of slow Postgres queries using EXPLAIN
Finding the Root Cause of Slow Postgres Queries Using EXPLAIN — An in-depth guide on how...
TLS: Demystifying communication encryption in PostgreSQL - CYBERTEC
TLS: Demystifying Communication Encryption in Postgres — TLS (Transport Layer Security) is a widely used technology...
Bruce Momjian: Postgres Blog
JSONB Multi-Column Type Casting — I’ve been doing a lot of work with JSONB columns lately...
Dave Page | PostgreSQL Person of the Week
An Interview with Dave Page — The latest in the PostgreSQL Person of the Week series...
supabase/realtime
Supabase: Listen to Database Changes in Real Time via WebSockets — We first mentioned this project...
Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python
Creating Test Data with SQL, PL/pgSQL, and Python — Greg posits that creating test data on...
ERROR: deadlock detected | Understanding deadlocks - CYBERTEC
Understanding Deadlocks — One of the more straightforward demonstrations of what a deadlock actually is. Essentially...
ankane/pgvector
pgvector: A Vector Similarity Search Extension for Postgres — Supports L2 distance, inner product, and cosine distance.
Bruce Momjian: Postgres Blog
On Database Software Bundles — No strong point here but Bruce ponders on how commercial database...
Developer Productivity Metrics
[Guide] The Truth About Developer Productivity Metrics — What you need to know to avoid weaponizing...
Hash Index Internals - Highgo Software Inc.
The Internals of Hash Indexes — B-trees are the most popular type of index in Postgres...
CHAR(1) to Boolean transformation while migrating to PostgreSQL - MigOps
A CHAR(1) to Boolean Transformation While Migrating to Postgres — Did you know Oracle Database doesn’t...
Getting Started with PostgreSQL Set Operators
Getting Started with Set Operations — For example, UNION for bringing result sets together and INTERSECT...
Getting value from dynamic column in pl/PgSQL triggers? – select * from depesz;
Can You Get a Value From a Dynamic Column in pl/PgSQL Triggers? — There’s a workaround...
Choice of Table Column Types and Order When Migrating to PostgreSQL
When to Use NUMERIC/DECIMAL vs. Other Numeric Types — For Postgres users looking for any incremental...
Cockroach University | Cockroach Labs
Cockroach University: Learn to Build Cloud-Native Apps — Cockroach University is a free online learning platform...
Benchmarking PostgreSQL: Setting up a RAID Array from Scratch
As part of my work on the CTO Team here at EDB, I do daily benchmarking...
Citus Talk at CMU: Distributed PostgreSQL as an Extension
Last month we released Citus 10 and we’ve received an overwhelming amount of positive feedback on...
Bruce Momjian: Postgres Blog
This blog is about my work on the Postgres open source database, and is published on...
Cleaning up a large number of BLOBs in PostgreSQL - CYBERTEC
PostgreSQL allows end users to store BLOBs (binary large objects) in the database. Many people use...
Getting started with QGIS, PostgreSQL and PostGIS - CYBERTEC
Visualizing spatial data is an important task. In this mini-tutorial, you will learn how to quickly...
Devrim Gündüz | PostgreSQL Person of the Week
Tags: postgresql community enterprisedb edb london friends rpm redhat fedora centos Category: Interviews Interviewed by: Andreas...
Bruce Momjian: Postgres Blog
This blog is about my work on the Postgres open source database, and is published on...
How to run Hierarchical Queries with PostgreSQL - Highgo Software Inc.
A hierarchical query is built upon parent-child relationship, the relationship exist in the same table or...
13 Tips to Improve PostgreSQL Database Insert Performance
Some of these may surprise you, but all 13 ways will help you improve ingest (INSERT)...
PostgreSQL: Get member roles and permissions - CYBERTEC
PostgreSQL provides a highly sophisticated and powerful security and permission system. It allows you to define...
PostgREST Documentation — PostgREST 7.0.1 documentation
PostgREST PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful...
Bruce Momjian: Postgres Blog
This blog is about my work on the Postgres open source database, and is published on...
Standing on the Shoulders of a Giant Elephant: Upgrading Discourse to PostgreSQL 13
When the Discourse project started, way back in 2013, the team had to pick and choose...
Preventing FreeBSD to kill PostgreSQL (aka OOM Killer prevention)
There are a lot of interesting articles on how to prevent the Out of Memory Killer...
Logging of Pgpool-II on Kubernetes
Logging is an important topic and particularly useful for troubleshooting, debugging and monitoring. Many applications have...
Speeding up SQL queries by orders of magnitude using UNION – Foxhound Systems
SQL is a very powerful tool for querying data. It allows you to write queries against...
