postgres-client

PostgreSQL client library for AICore (aic), with typed values, prepared statements, COPY, cursor streaming, transaction helpers, and live integration coverage.

Requirements

• aic CLI installed and configured
• Docker (for integration tests)

Project Layout

• src/pg: client/config/errors/types/codec modules
• tests/unit: unit test suites
• tests/integration: live PostgreSQL integration suites
• examples: runnable end-to-end examples
• docs: feature docs and support matrices

Run Tests

aic test tests/unit

docker compose -f docker/postgres.compose.yml up -d
AIC_TEST_NO_REAL_IO=0 AIC_TEST_IO_CAPTURE=0 aic test tests/integration

Run Full Example

docker compose -f docker/postgres.compose.yml up -d
aic run examples/full_database_ops.aic

Type Coverage Notes

• Typed decode and typed bind support are verified by unit + live integration tests.
• Outbound binary parity includes temporal/network, broad arrays (1D/2D), ranges/multiranges (int4/ts families), and geometric families.
• numeric[] and numeric range/multirange outbound params currently use explicit text-path policy.