{"library":"futoin-database","type":"library","category":null,"description":"futoin-database is a neutral database interface designed for microservices, providing advanced Query and a unique 'revolutionary' Transaction builder. As a reference implementation for FTN17: FutoIn Interface - Database, it focuses on enforcing specific patterns by design, notably lacking direct support for large result sets, cursors, and explicit client-side transaction control to prevent common database anti-patterns. The library leverages a 'single call' transaction pattern, executing multiple statements on the DB side within a single transaction, with back references for sequential query data. It supports auto-configuration through environment variables for connection pooling and works with MySQL, PostgreSQL, and SQLite out of the box. The current stable version is 1.9.12, and it appears to be actively maintained, often with minor version updates. Its core differentiators include its opinionated approach to database interaction and its tight integration with the FutoIn ecosystem, requiring `futoin-asyncsteps`, `futoin-executor`, and `futoin-invoker` as peer dependencies.","language":"javascript","status":"active","version":"1.9.12","tags":["javascript","futoin","async","db","database","querybuilder","transaction","postgresql","mysql"],"last_verified":"Wed May 27","install":[{"cmd":"npm install futoin-database","imports":["import { AutoConfig } from 'futoin-database';","import { QueryBuilder } from 'futoin-database';","import { IDataBaseService } from 'futoin-database';"]},{"cmd":"yarn add futoin-database","imports":[]},{"cmd":"pnpm add futoin-database","imports":[]}],"homepage":"https://futoin.org","github":"https://github.com/futoin/core-js-ri-database","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/futoin-database","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/futoin-database/compatibility"}}