{"id":26036,"library":"ocurupos.database.api","title":"OcuruPOS Database API","description":"A lightweight JavaScript library for connecting to and interacting with the OcuruPOS database system. Version 0.2.129 provides basic CRUD operations and query capabilities tailored for point-of-sale data management. The package is in early development with frequent releases but lacks comprehensive documentation. Designed specifically for OcuruPOS ecosystem integration, it is not a general-purpose database client.","status":"active","version":"0.2.129","language":"javascript","source_language":"en","source_url":null,"tags":["javascript"],"install":[{"cmd":"npm install ocurupos.database.api","lang":"bash","label":"npm"},{"cmd":"yarn add ocurupos.database.api","lang":"bash","label":"yarn"},{"cmd":"pnpm add ocurupos.database.api","lang":"bash","label":"pnpm"}],"dependencies":[],"imports":[{"note":"Package may support both CJS and ESM; check module type.","wrong":"const Database = require('ocurupos.database.api')","symbol":"default","correct":"import Database from 'ocurupos.database.api'"},{"note":"Named export, not default.","wrong":"import connect from 'ocurupos.database.api'","symbol":"connect","correct":"import { connect } from 'ocurupos.database.api'"},{"note":"Function export is lowercase.","wrong":"import { Query } from 'ocurupos.database.api'","symbol":"query","correct":"import { query } from 'ocurupos.database.api'"}],"quickstart":{"code":"import { connect, query } from 'ocurupos.database.api';\n\nasync function main() {\n  const db = await connect({ host: 'localhost', port: 5432 });\n  const result = await query(db, 'SELECT * FROM products LIMIT 10');\n  console.log(result);\n  await db.close();\n}\nmain().catch(console.error);","lang":"typescript","description":"Connects to the OcuruPOS database, runs a query to fetch products, and logs results."},"warnings":[{"fix":"Use connect({ host, port, user, password }) instead of connect(host, port, user, password).","message":"The connect() function signature changed in v0.2.0: first argument is now an object, not separate parameters.","severity":"breaking","affected_versions":">=0.2.0"},{"fix":"Replace db.execute(sql) with query(db, sql).","message":"The method db.execute() is deprecated as of v0.2.100, use query() instead.","severity":"deprecated","affected_versions":">=0.2.100"},{"fix":"Reuse a single connection or implement a connection pool externally.","message":"The library does not support connection pooling; opening multiple connections may lead to resource exhaustion.","severity":"gotcha","affected_versions":"all"}],"env_vars":null,"last_verified":"2026-05-01T00:00:00.000Z","next_check":"2026-07-30T00:00:00.000Z","problems":[{"fix":"Upgrade to version >=0.2.50 or use 'end' method: await db.end();","cause":"The close method is not available on the connection object in older versions.","error":"TypeError: db.close is not a function"},{"fix":"Use exact string in import: import ... from 'ocurupos.database.api'; Ensure the package is installed.","cause":"Package name contains dots; certain module bundlers may misinterpret it.","error":"Module not found: Error: Can't resolve 'ocurupos.database.api'"},{"fix":"Explicitly set host to '127.0.0.1' in connection options.","cause":"Default host is localhost; IPv6 resolution may fail if service listens on IPv4 only.","error":"Error: connect ECONNREFUSED ::1:5432"}],"ecosystem":"npm","meta_description":null,"install_score":null,"install_tag":null,"quickstart_score":null,"quickstart_tag":null}