SQL

An entity is a table where each row has something that identifies it.

A foreign key is the column that points to the primary key of another table.

pgTAP is a unit-testing extension for Postgres — enable it, then use its assertion functions to verify your schema and your queries.

Sample PostgreSQL databases — AdventureWorks, airline flights, DVD rental, OMDB and Scott — used across the PostgreSQL activities.

Helm Charts for Postgresql Clusters with CNPG

Generates repository classes from SQLAlchemy models (async and sync) so standard CRUD comes for free and you only hand-write the non-standard queries.

Databases basics: ER modeling, relational design, SQL (SELECT/JOIN/DML) and a NoSQL/MongoDB lesson. Eight self-contained lessons with sqlite-runnable exercises and solutions.

The server back-end for the REKO Rings network.

Analysis of Kilter Board data, along with predictive models for V-grades based on holds and angle.

Analysis of Tension Board 2 data, along with predictive models for V-grades based on holds and angle.

Key platform data integrations repo

Notepaper is a full-stack, multi-user, cloud-based note management Single-Page Application (SPA) built with Laravel Livewire 3.

SparkyBot is a personal-assistance mobile application for electricians in the Oceania regions. The app was designed & developed under fully compliance of the official standards of AS/NZS 3008 that covers both: cable sizing, voltage drop.

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.

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

Rebuilding Bitwarden MSSQL image to run on machines with less than 2GB of physical memory

Fluent SQL query builder for Kit

SQLite bindings for Kit

PostgreSQL bindings for Kit using libpq