PostgreSQL Database

## What problem does it solve? PostgreSQL is a powerful database, but integrating it with FreePascal Lazarus requires repetitive boilerplate code, error handling, and SQL mapping. This Skill provides structured guidance and reusable patterns to simplify connection setup, data mapping, common PostgreSQL features (JSONB, UPSERT, FTS), and migrations.

## Core Features & Use Cases

• PostgreSQL connection setup with SQLdb/Zeos
• Mapping PostgreSQL data types to FreePascal Lazarus types
• Implementing UPSERT, JSONB, FTS, CTEs, and partitioning
• Migration scripts and best practices for schema versioning
• Use Case: configure a repository layer for a Lazarus app interfacing with PostgreSQL

Quick Start

Start with configuring your connection factory in your Lazarus project, initialize a TSQLConnection, and execute a parameterized query to fetch data.