SQL

KVLite is a partition-based key-value cache built for SQL RDBMSs: https://kvlite-docs.pommalabs.xyz/

Cheat sheets for several programming languages and IT related tools.

check record pgn & statistics

SQLite bindings for Kit

PostgreSQL SQL parser - parse, validate, normalize, and fingerprint SQL queries using libpg_query

Fluent SQL query builder for Kit

PostgreSQL bindings for Kit using libpq

DuckDB bindings for Kit - in-process analytical database

Relational database management system that uses YottaDB as the data store

Materials on various sections in Computer Science (CS). 🎓

⚠️ ARCHIVED: This project is no longer maintained. See successor: npx postgresai checkup

In this project, I used PostgreSQL to analyze a database of movie rentals to uncover trends in customer behavior, inventory performance, and staff efficiency. The emphasis was placed heavily on extracting meaning from complex SQL query structures. The resulting insights were visually presented using Vega-Lite, and the final slide deck presentation was generated cleanly via the Obsidian Slides core plugin.

Ce projet a été fait dans le cadre de l'UE : Introduction aux Bases de Données encadrée par le professeur Shaoyi YIN. L’objectif est de ce projet est de concevoir une base de données complète à partir d’un scénario décrivant les besoins d’une compagnie d’assurances. Le projet suit une démarche progressive allant de l’analyse du besoin jusqu’à la modélisation relationnelle finale sur Oracle et la création de requêtes SQL.

Ayant beaucoup d'appétence pour le cinéma, les tables ont été créées en utilisant l’univers Marvel comme source d’inspiration.

🐘🕶️ Anonymization & Data Masking for PostgreSQL

https://labs.dalibo.com/postgresql_anonymizer

This project is an end-to-end implementation of a Data Lakehouse on AWS. It processes raw IoT sensor data from mobile applications and physical devices into a curated dataset designed for Machine Learning model training.

Sparkify, a music streaming startup, has grown their user base and song database and is moving their data processing to the cloud. This project implements a high-performance ETL (Extract, Transform, Load) pipeline that extracts raw JSON logs and metadata from Amazon S3, stages the data in Amazon Redshift and transforms it into a Star Schema optimized for song play analysis and business intelligence.

This architecture enables the analytics team to gain deeper insights into user behavior, popular songs, and artist performance with high-concurrency and low-latency queries.

Joe helps backend engineers and DBAs troubleshoot and optimize SQL, moving really quickly. Joe works on top of Database Lab https://gitlab.com/postgres-ai/database-lab.

Proyecto Final de Grado Superior en Desarollo de Aplicaciones Web de Aaron Crespo Garcia.

A Terraform module to manage the configuration of Athena to query an S3 data source. Data cataloguing is executed by AWS Glue, which can be triggered on-demand, on a schedule, or from S3 Object Created events.

Lightweight lyrics host.