Registry / database / streamsql

streamsql

JSON →
library0.8.5jsnpmunverified

A streaming, backend-agnostic SQL ORM for Node.js, inspired by levelup. Version 0.8.5 is the latest stable release, with sparse maintenance. It supports MySQL and SQLite3 drivers, providing a stream-based API for CRUD operations on database tables. Key differentiators include a streaming interface (createReadStream, createWriteStream) and backend abstraction, but note it does not auto-install database drivers. Current status is 'deprecated' as it was last published in 2013 and has no recent updates.

database
github ↗package ↗homepage ↗
Install & Compatibility
Where this runs

No compatibility data collected yet for this library.

Code
Verified usage

Verified import paths — ran on the pinned version, not inferred.

This package is CommonJS only, no ESM support.

const streamsql = require('streamsql');

Use connect() to get a db instance; new streamsql() is not a constructor.

const db = streamsql.connect({ driver: 'sqlite3', filename: ':memory:' });

The method is table() not registerTable().

db.table('users', { fields: ['id', 'name'] });

Shows how to initialize streamsql with sqlite3, register a table, insert a row, and fetch it.

const streamsql = require('streamsql'); const db = streamsql.connect({ driver: 'sqlite3', filename: ':memory:' }); db.table('users', { fields: ['id', 'name', 'email'], primaryKey: 'id' }); const users = db.table('users'); users.put({ id: 1, name: 'Alice', email: 'alice@example.com' }, (err) => { if (err) throw err; users.get(1, (err, row) => { if (err) throw err; console.log(row); }); });
Debug
Known footguns
deprecatedPackage is deprecated with no updates since 2013.
breakingDatabase drivers must be installed separately; they are not included as dependencies.
gotchaThe connect() method does not accept a callback; it returns the db object synchronously.
gotchatable() does not create the actual table in the database; it only registers a definition.
Upgrade
Version history

Breaking-change detection hasn't run for this library yet.

Audit
Security & dependencies

CVE tracking and dependency tree are planned for a later release.

Agent activity
0 hits · last 30 days

No traffic data recorded yet.

Resources
githubgit://github.com/brianloveswords/streamsql ↗
packagestreamsql ↗
homepagehttps://github.com/brianloveswords/streamsql ↗