{"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,"search_vec":"'0.2.129':19 'api':3 'basic':21 'capabl':26 'client':62 'comprehens':46 'connect':9 'crud':22 'data':33 'databas':2,16,61 'design':48 'develop':40 'document':47 'earli':39 'ecosystem':52 'frequent':42 'general':59 'general-purpos':58 'integr':53 'interact':12 'javascript':6,63 'lack':45 'librari':7 'lightweight':5 'manag':34 'ocurupo':1,15,51 'oper':23 'packag':36 'point':30 'point-of-sal':29 'provid':20 'purpos':60 'queri':25 'releas':43 'sale':32 'specif':49 'system':17 'tailor':27 'version':18","created_at":"2026-05-01T13:47:51.774450+00:00","updated_at":"2026-05-01T13:47:51.774450+00:00","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,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":"","cli_version":null,"type":"library","homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/ocurupos.database.api","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-05-01","next_check":"2026-07-30","install_tag":null}}