{"library":"pgsql-client","type":"library","category":null,"description":"pgsql-client is a PostgreSQL client utility specifically designed as a core component of the constructive-io ecosystem. It provides robust query helpers, integrated Row-Level Security (RLS) context management, and tools for database administration, emphasizing a database-first approach to application development. This library ships with comprehensive TypeScript types, enabling developers to build type-safe, modular PostgreSQL applications by treating the database as a version-controlled system. Its current stable version, 3.9.3, reflects ongoing development within the constructive-io framework. The project's release cadence is tied to the broader constructive-io ecosystem, which maintains active development. Key differentiators include its deep integration with RLS for fine-grained access control, support for modular database design via tools like `pgpm`, and rich developer tooling to streamline secure and scalable PostgreSQL backend development. It is important to distinguish this package from the `postgresql-client` NPM package, which was renamed to `postgrejs`.","language":"javascript","status":"active","version":"3.9.3","tags":["javascript","postgres","postgresql","client","pg","rls","row-level-security","database","admin","typescript"],"install":[{"cmd":"npm install pgsql-client","imports":["import { Client } from 'pgsql-client'","import { ConnectionOptions } from 'pgsql-client'","await client.setContext({...})"]},{"cmd":"yarn add pgsql-client","imports":[]},{"cmd":"pnpm add pgsql-client","imports":[]}],"homepage":"https://constructive.io","github":"https://github.com/constructive-io/constructive","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/pgsql-client","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":{"summary":{"python_range":"18–22","success_rate":0,"avg_install_s":null,"avg_import_s":null,"wheel_type":null},"url":"https://checklist.day/v1/registry/pgsql-client/compatibility"},"provenance":{"verified_status":null,"verified_at":null,"last_verified":"Wed Jun 17","next_check":"Tue Jul 21","install_tag":null}}