Slonik is a mature, battle-tested PostgreSQL client library for Node.js, designed with a strong emphasis on type safety, runtime validation, and extensibility. It is structured as a monorepo with multiple packages including the core `slonik` library, `@slonik/sql-tag` for building SQL queries via tagged template literals, `@slonik/errors` for a rich error hierarchy mapping PostgreSQL error codes, `@slonik/driver` and `@slonik/pg-driver` for abstracted database connectivity, and ecosystem packages like interceptors (logging, caching, field name transformation) and dataloaders for GraphQL-style batching and cursor pagination. The library enforces strict query result assertions (e.g., `one`, `many`, `maybeOne`) and integrates with Zod for runtime schema validation of query results. Its architecture revolves around an interceptor pattern that hooks into the query lifecycle (before/after query execution, row transformation, connection events), enabling powerful middleware without modifying core logic. The connection pool features advanced capabilities such as idle timeout, maximum connection age, minimum pool size, warmup, and graceful termination. Slonik is ESM-only since v48.0.0 and requires Node.js >=24. It is actively maintained with frequent releases, comprehensive test coverage (unit and integration tests using Docker), and a benchmark suite comparing performance with other PostgreSQL clients.
porsager/postgres is a PostgreSQL client library for Node.js, Deno, and Cloudflare Workers. It provides a full-featured, performant interface to PostgreSQL using tagged template literals for safe, parameterized queries. The library implements the PostgreSQL wire protocol from scratch with zero runtime dependencies, supporting advanced features like connection pooling, prepared statements, cursors, COPY streams, logical replication, large objects, and custom type mapping. The architecture is a factory function that returns a `sql` tagged template function, which lazily connects to the database and pipelines queries over persistent connections. The codebase is well-structured across `src/` with separate modules for connection management, query execution, protocol message building, type serialization/parsing, and error handling. It also includes transpiled builds for CommonJS, Deno, and Cloudflare Workers, each with platform-specific polyfills. The library is actively maintained, has extensive test coverage, and is published under a public domain license.
PostgresGUI is a native macOS PostgreSQL client application built with SwiftUI and SwiftData. It provides a desktop interface for managing PostgreSQL database connections, executing queries, browsing schemas, and manipulating data. The application features SSH tunneling support for secure connections, credential storage via macOS Keychain, query result editing capabilities, and export functionality. Built with a protocol-oriented MVVM-like architecture, it emphasizes separation of concerns through distinct layers for networking, data persistence, UI presentation, and state management. The app handles complex concerns like connection lifecycle management, result set normalization, and concurrent operations using modern Swift concurrency patterns.