@alt-javascript/jsdbc-core

Core interfaces for JSDBC — a JDBC-inspired database access facade for JavaScript. This package provides the abstract base classes that all JSDBC drivers implement.

Part of the @alt-javascript/jsdbc monorepo.

Install

npm install @alt-javascript/jsdbc-core

Interfaces

| Class | Role | |---|---| | Driver | Creates connections to a specific database. Self-registers with DriverManager. | | DriverManager | Static registry. Matches JSDBC URLs to registered drivers. | | Connection | A session to a database. Creates statements, manages transactions. | | Statement | Executes ad-hoc SQL (DDL). | | PreparedStatement | Executes parameterised SQL with ? placeholders (DML, queries). | | ResultSet | Query results with cursor-based and bulk access. | | DataSource | Connection factory. Create once, call getConnection() per unit of work. | | SingleConnectionDataSource | Returns the same connection repeatedly. For in-memory databases. |

Usage

You don't use jsdbc-core alone — install it alongside a driver:

npm install @alt-javascript/jsdbc-core @alt-javascript/jsdbc-sqlite

import { DataSource } from '@alt-javascript/jsdbc-core';
import '@alt-javascript/jsdbc-sqlite'; // self-registers

const ds = new DataSource({ url: 'jsdbc:sqlite:./myapp.db' });
const conn = await ds.getConnection();

const ps = await conn.prepareStatement('SELECT * FROM users WHERE id = ?');
ps.setParameter(1, 42);
const rs = await ps.executeQuery();
console.log(rs.getRows());

rs.close();
await conn.close();

Writing a Driver

Implement four classes extending the core abstractions. See the Driver Guide.

License

MIT