Welcome!

My name is Gabriel Bordeaux and this is my personal website where I try to share cool stuff, mainly oriented towards PostgreSQL.

Read my articles and feel free to contact me!

Recent articles

• Backup PostgreSQL to AWS S3 (Jun. 28, 2023)
• Install PostgreSQL 15 on Debian/Ubuntu servers (Jun. 22, 2023)
• Easy migration from Travis to GitHub Actions (Jan. 5, 2022)
• Encrypt a file for GitHub Actions (Dec. 18, 2021)
• Upgrade to PostgreSQL 12 (Nov. 19, 2019)

A few hacks

gabfl/vault

Python password manager

gabfl/bigquery_fdw

BigQuery Foreign Data Wrapper for PostgreSQL

gabfl/dbschema

MySQL/PostgreSQL schema migrations made easy

gabfl/redis-priority-queue

Simple Redis work queue with added features (priorities, pop multiple items at once)

gabfl/mysql_generate_series

mysql_generate_series is a MySQL replica of PostgreSQL's generate_series functions

gabfl/password-generator-py

Passwords easy for humans, hard for computers Edit

gabfl/pg_dump-to-s3

Automatically dump and archive PostgreSQL backups to Amazon S3

gabfl/pg-batch

Run large PostgreSQL update and delete queries with small batches to prevent locks

gabfl/mysql-batch

Run large MySQL updates and deletes with small batches to prevent table/row-level locks

and also gabfl/shachange, gabfl/makesite, gabfl/roulette, gabfl/redis-expire-least-used, gabfl/PHP-PSR-2-Fixer-Coda-Plugin

GPG