Run a query in psql and output the result as CSV.

My dev.environments and system configurations (macOS, ruby, js, python, dotfiles, zsh, vim, sublime, fonts, etc). Powered by Ansible 💖

My files, solutions & notes for FreeCodeCamp's Relational Database SQL Course

Personal setup configuration

Urbanise database versioning with Flyway and Bash

Simple bash script that clone database from one Heroku app to another one. Transfers schema & data. Useful for duplicating data from production to staging environments.

A backup and restore solution for Odoo databases and filestore. The scripts automate PostgreSQL database backup, filestore compression, and restore operations.

PsqlPlus provides common operation and maintenance sql for the postgresql

pg-scripts for monitoring, basic testing and demo exercises

Swarm64 DA Docker Compose

Smart .psqlrc with a neat customizable prompt

Swarm64 DA Product Installer

hsdp-task for backing up a PostgreSQL database to S3

Perform encrypted rotating backups of a PostgreSQL database stored in AWS S3 using Linux cron or Kubernetes CronJob.

Solutions to the freecodecamp relational database projects

This project builds a data pipeline to populate the user_behavior_metric table. The user_behavior_metric table is an OLAP table, meant to be used by analysts, dashboarding.

This is one of the required projects to earn my freeCodeCamp 'Relational Database Certification'.

这是一个纯脚本工具，用于从PostgreSQL的pg_stat_activity视图中定期收集数据并保存到本地日志文件。支持PG10-PG18版本。

Bundle the PSQL Secret Rotation Lambda by Amazon with the required shared libraries.