{"library":"fortune-postgres","type":"library","category":null,"description":"A PostgreSQL adapter for Fortune.js that maps Fortune's data interface directly to SQL statements without ORM overhead. Supports non-destructive table setup, array foreign keys for performance, and optimized query building. Current stable version is 1.6.11, last updated in 2020 with sporadic maintenance. Requires PostgreSQL 9.4+. Unlike ORM-based adapters, it delegates foreign key enforcement to Fortune.js and avoids junction tables by using array columns. The adapter also exposes the underlying pg-pool for raw queries. Release cadence is low; no major changes expected.","language":"javascript","status":"maintenance","version":"1.6.11","tags":["javascript","fortune","postgres","postgresql","sql","adapter"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install fortune-postgres","imports":["const postgresAdapter = require('fortune-postgres')","const store = fortune(schema, { adapter: [postgresAdapter, { url }] })","store.adapter.pool"]},{"cmd":"yarn add fortune-postgres","imports":[]},{"cmd":"pnpm add fortune-postgres","imports":[]}],"homepage":"https://github.com/fortunejs/fortune-postgres#readme","github":"https://github.com/fortunejs/fortune-postgres","docs":null,"changelog":null,"pypi":null,"npm":"fortune-postgres","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}