{"library":"simple-postgres","type":"library","category":null,"description":"A minimal PostgreSQL interface for Node.js (v5.0.0) that eliminates boilerplate by automatically connecting via the DATABASE_URL environment variable. It provides a small set of helper functions (query, rows, row, value, column) with automatic parameterization to prevent SQL injection, and supports template string queries for readability. Simple-postgres focuses on simplicity: no ORM, no query builder, no connection pool configuration, and no initialization required. It is trusted in production and has good test coverage. Alternative to node-postgres but with a much smaller API surface.","language":"javascript","status":"active","version":"5.0.0","tags":["javascript","pg","simple","postgres","postgresql","database"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install simple-postgres","imports":["import db from 'simple-postgres'","import db from 'simple-postgres';\ndb.query(...)","import db from 'simple-postgres';\ndb.identifier('table_name')"]},{"cmd":"yarn add simple-postgres","imports":[]},{"cmd":"pnpm add simple-postgres","imports":[]}],"homepage":"https://github.com/madd512/simple-postgres#readme","github":"https://github.com/madd512/simple-postgres","docs":null,"changelog":null,"pypi":null,"npm":"simple-postgres","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}