{"library":"postgres-gen-dao","type":"library","category":null,"description":"A simple DAO library for PostgreSQL built on postgres-gen and pg, providing basic CRUD operations with automatic marshalling between objects and tables. Current stable version is 0.18.2 (mature, infrequent releases). Key differentiators: uses promise-based query methods compatible with generators, supports object-relation mapping with automatic ID and timestamp handling, offers a ql query language for referencing multiple DAO tables in SQL, and includes upsert functionality that determines insert vs update based on record state. Minimal dependencies and simple API focused on reducing boilerplate for common patterns.","language":"javascript","status":"active","version":"0.18.2","tags":["javascript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install postgres-gen-dao","imports":["const dao = require('postgres-gen-dao');","const { ql } = require('postgres-gen-dao');","const dao = require('postgres-gen-dao'); const books = dao({ db: db, table: 'books' });"]},{"cmd":"yarn add postgres-gen-dao","imports":[]},{"cmd":"pnpm add postgres-gen-dao","imports":[]}],"homepage":"https://github.com/evs-chris/postgres-gen-dao","github":"https://github.com/evs-chris/postgres-gen-dao","docs":null,"changelog":null,"pypi":null,"npm":"postgres-gen-dao","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}