PostgreSQL

PostgreSQL 17: Enhancing JSON Support for Web Developers

PostgreSQL 17 introduces new features for working with JSON data. These features align PostgreSQL more closely with the SQL/JSON standard and improve the developer experience when dealing with semi-structured data. In this blog, we will explore the new JSON capabilities(…)

Enhancing PostgreSQL Performance with Index Advisor and HypoPG

In database management, query performance is critical for efficient data retrieval. PostgreSQL, a powerful open-source database, offers various extensions to optimize and tune query performance. Two such extensions are Index Advisor and HypoPG. These tools help database administrators (DBAs) identify(…)

PosgreSQL + SQL Server = WiltonDB – Part 2 – Database Management

Few months ago I write about WiltonDB and how to install it. Now, I move one step forward with the Database Management. How to create a Database ? I test first with the T-SQL Command CREATE DATABASE script: I(…)

Upgrade etcd in a patroni cluster

In a distributed database system like PostgreSQL managed by Patroni, etcd plays a critical role as the distributed key-value store for cluster coordination and configuration. As your system evolves, upgrading etcd becomes necessary to leverage new features, bug fixes, and(…)

PostgreSQL 17: pg_buffercache_evict()

In PostgreSQL up to version 16, there is no way to evict the buffer cache except by restarting the instance. In Oracle you can do that since ages with “alter system flush buffer cache“, but not(…)

Create REST API from your database in minute with Feathers.js

Creating REST APIs is a fairly repetitive task. You’re always rewriting the Create, Read, Update, Delete methods…In my search for a framework capable of generating a REST API, I discovered Feathers, a simple and useful framework for Node.js.

Introduction to PostgreSQL in OpenShift

I’m on a mission to tackle scary topics around DevOps these days! In my 2 previous blog posts (Part 1 and Part 2) I’ve tried to demystified the DevOps word (and world!)(…)

PostgreSQL Backups with pg_back

1. Introduction In the world of PostgreSQL database management, ensuring robust backup strategies is mandatory. This week I discovered on postgresql.org latest news one useful tool that streamlines this process: pg_back. pg_back serves as a dedicated dumping tool designed(…)

PostgreSQL’s New Milestone in Security: Officially CVE Numbering Authority

The PostgreSQL Community just made a significant leap forward in database security :Postgresql is now a CVE Numbering Authority (CNA). Here is the original announcement about PostgreSQL being added as a CNA on the CVE website.

And suddenly it’s already over again – pgconf.eu 2023

Last week was the week of the European PostgreSQL Conference in Prague which I was allowed to join once more. An amazing location was waiting for all the participants and once I entered the hotel, I already felt(…)