{"library":"postgres-schema-builder","type":"library","category":null,"description":"A TypeScript library for building PostgreSQL schemas and writing typesafe queries. Version 1.3.0, last updated in 2020 (no recent releases). It uses a declarative schema definition with TableSchema, automatic TypeScript type inference from column types, and a Table API for CRUD operations. Key differentiator: strong TypeScript type safety for schema and queries, including compile-time checks for nullable columns and foreign keys. Not actively maintained; no query builder for joins or aggregations. Alternative: kysely or drizzle-orm.","language":"javascript","status":"maintenance","version":"1.3.0","tags":["javascript","postgres","postgresql","typescript","typesafe","schema","query","builder","database"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install postgres-schema-builder","imports":["import { TableSchema } from 'postgres-schema-builder'","import { ColumnType } from 'postgres-schema-builder'","import { Table } from 'postgres-schema-builder'","import { SQL } from 'postgres-schema-builder'","import { NativeFunction } from 'postgres-schema-builder'","import { JSONType } from 'postgres-schema-builder'","import { ForeignKeyUpdateDeleteRule } from 'postgres-schema-builder'"]},{"cmd":"yarn add postgres-schema-builder","imports":[]},{"cmd":"pnpm add postgres-schema-builder","imports":[]}],"homepage":"https://github.com/yss14/","github":"https://github.com/yss14/postgres-schema-builder","docs":null,"changelog":null,"pypi":null,"npm":"postgres-schema-builder","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}