TDS 5.0 Sybase ASE database driver for Node.js/TypeScript.
- Pure TypeScript — no native dependencies
- Promise/async-await API, no callbacks
- Prepared statements, server-side cursors, transactions, connection pool
- Cleanroom implementation from the Sybase TDS 5.0 protocol specification
npm install sybase-tdsimport { Connection } from 'sybase-tds';
const conn = await Connection.connect({
host: 'myserver',
port: 5000,
username: 'sa',
password: 'secret',
});
// Simple query
const { rows } = await conn.query('SELECT id, name FROM users WHERE active = 1');
for (const [id, name] of rows) {
console.log(id, name);
}
// Prepared statement
import { DataFormat } from 'sybase-tds';
import { DataType } from 'sybase-tds/constants';
const stmt = await conn.prepare(
'SELECT * FROM users WHERE id = ?',
[new DataFormat(DataType.INT4)], // Optional
);
const result = await stmt.execute([42]);
await stmt.close();
// Transaction
const txn = conn.transaction();
await txn.begin();
try {
await conn.query("INSERT INTO log VALUES ('test')");
await txn.commit();
} catch {
await txn.rollback();
}
await conn.end();import { ConnectionPool } from 'sybase-tds';
const pool = ConnectionPool.create(
{ host: 'myserver', port: 5000, username: 'sa', password: 'secret' },
{ min: 2, max: 10, idleTimeout: 30_000 },
);
const conn = await pool.acquire();
try {
await conn.query('SELECT 1');
} finally {
pool.release(conn);
}
await pool.end();const cursor = conn.cursor('SELECT * FROM big_table');
await cursor.open();
const rows = await cursor.fetch(100);
await cursor.close();| TDS Type | JS/TS type |
|---|---|
| INT1, INT2, INT4 | number |
| INT8, UINT8 | bigint |
| FLT4, FLT8, FLTN | number |
| DECN, NUMN | string ("123.45") |
| MONEY, SHORTMONEY | string ("1.0000") |
| DATE, TIME, DATETIME, SHORTDATE | Date |
| VARCHAR, CHAR, TEXT, LONGCHAR | string |
| UNITEXT | string (UTF-16 LE) |
| BINARY, VARBINARY, IMAGE | Buffer |
| BIT | boolean |
| NULL | null |
All server errors are thrown as SybaseError which extends Error:
import { SybaseError } from 'sybase-tds';
try {
await conn.query('SELECT FROM'); // syntax error
} catch (err) {
if (err instanceof SybaseError) {
console.error(err.errorNumber, err.severity, err.message);
}
}MIT