grimoire list @effect/sql-pg @effect/sql-pg
effect-ts/effect
PostgreSQL client for Effect SQL — connection pooling, streaming, LISTEN/NOTIFY, migrations
Topics
- Package Overview
grimoire show @effect/sql-pg overviewWhat @effect/sql-pg is and how it fits into the Effect SQL ecosystem - PgClient Interface and Tag
grimoire show @effect/sql-pg pg-client-interfaceThe PgClient type, its capabilities beyond SqlClient, and the Context tag - Client Configuration
grimoire show @effect/sql-pg configurationPgClientConfig options for connection, pooling, transforms, and SSL - Layers and Construction
grimoire show @effect/sql-pg layers-and-constructionHow to create PgClient instances via make, fromPool, and Layer constructors - SQL Statements and Compiler
grimoire show @effect/sql-pg sql-statements-compilerTagged template SQL, the Pg compiler, helpers (insert, update, in, and), and custom types - Connection Management and Pooling
grimoire show @effect/sql-pg connection-managementHow connections are acquired, released, and pooled via pg.Pool - Streaming Queries
grimoire show @effect/sql-pg streamingCursor-based streaming via pg-cursor and Effect Stream - LISTEN/NOTIFY
grimoire show @effect/sql-pg listen-notifyPostgreSQL pub/sub via sql.listen() and sql.notify() - Migrations
grimoire show @effect/sql-pg migrationsDatabase migration support via PgMigrator wrapping @effect/sql/Migrator - Name Transforms
grimoire show @effect/sql-pg name-transformsAutomatic camelCase/snake_case conversion for query identifiers and result columns - SQL Resolvers and Batching
grimoire show @effect/sql-pg resolvers-and-batchingBatched database access using SqlResolver with Effect's request batching - Error Handling
grimoire show @effect/sql-pg error-handlingSqlError, MigrationError, and error patterns in the Pg client - Observability and Span Attributes
grimoire show @effect/sql-pg observabilityOpenTelemetry span attributes and tracing integration - Testing Patterns
grimoire show @effect/sql-pg testing-patternsTest setup with testcontainers, layer composition, and test utilities
grimoire add @effect/sql-pg