{"library":"slonik-utilities","type":"library","category":null,"description":"Slonik Utilities provides a set of helper functions designed to simplify common data manipulation operations within a PostgreSQL database when using the Slonik client library. It abstracts away the direct construction of parameterized SQL queries for tasks such as `UPDATE`, `UPDATE ... DISTINCT`, and `UPSERT`, allowing developers to express these operations using JavaScript objects. The library is currently at stable version 2.0.2 and receives updates primarily to maintain compatibility with new major versions of Slonik (e.g., supporting Slonik v29). Its key differentiators include enhancing developer productivity by reducing boilerplate SQL, improving type safety through its TypeScript definitions, and mitigating SQL injection risks by leveraging Slonik's tagged template literals internally. It does not replace Slonik but complements it by offering a higher-level, opinionated API for frequent DML patterns.","language":"javascript","status":"active","version":"2.0.2","tags":["javascript","postgresql","slonik","utilities","typescript"],"install":[{"cmd":"npm install slonik-utilities","imports":["import { update } from 'slonik-utilities';","import { updateDistinct } from 'slonik-utilities';","import { upsert } from 'slonik-utilities';"]},{"cmd":"yarn add slonik-utilities","imports":[]},{"cmd":"pnpm add slonik-utilities","imports":[]}],"homepage":null,"github":"https://github.com/gajus/slonik-utilities","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/slonik-utilities","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/slonik-utilities/compatibility"},"provenance":{"verified_status":null,"verified_at":null,"last_verified":"Wed Jun 17","next_check":"Tue Jul 21","install_tag":null}}