Registry / database / juttle-sqlite-adapter

juttle-sqlite-adapter

library0.6.0jsnpmunverified

SQLite adapter for the Juttle data flow language, enabling read and write operations on SQLite databases. Version 0.6.0 is the latest stable release, though the project appears to be in maintenance mode with no recent updates. It supports time-series data via a timeField option, raw SQL queries, and debug output. Unlike generic database adapters, it integrates seamlessly with Juttle's streaming query model. Installation requires side-by-side setup with the juttle engine.

database

npm install juttle-sqlite-adapter

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · JUTTLE-SQLITE-ADAP

juttle-sqlite-adapter

databasejavascriptv0.6.0

harness data pending

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.

Adapter

✓ import { Adapter } from 'juttle-sqlite-adapter';

✗ const Adapter = require('juttle-sqlite-adapter').Adapter;

The package exports an Adapter class for programmatic use, but typically used via Juttle config.

default

✓ import juttleSqliteAdapter from 'juttle-sqlite-adapter';

✗ const juttleSqliteAdapter = require('juttle-sqlite-adapter');

Default import provides the adapter plugin for Juttle registration.

juttle-sqlite-adapter

✓ module.exports = require('juttle-sqlite-adapter');

In CommonJS, require the package directly; the exported object contains the Adapter class and config helper.

Shows installation, configuration, and basic read/write Juttle programs using the SQLite adapter.

// Install juttle and adapter // npm install juttle juttle-sqlite-adapter // Configure ~/.juttle/config.json: // { // "adapters": { // "sqlite": { // "filename": "/tmp/mydb.sqlite" // } // } // } // Sample Juttle program (run with juttle command): // read sqlite -table 'users' -timeField 'created_at' -from :1 day ago: // Write example: // emit -from :0: -limit 1 | put message='hello' | write sqlite -table 'logs'

Debug

Known issues

deprecatedPackage is no longer actively maintained; no updates since 2019.

fix

Consider migrating to a modern alternative or forking the repository.

affects: >=0.0.0

breakingRequires Juttle engine as a peer dependency; will fail if Juttle is not installed.

fix

Install juttle package alongside: npm install juttle juttle-sqlite-adapter

affects: >=0.1.0

gotchaRead option 'raw' accepts a raw SQL query string; using it without proper escaping can lead to SQL injection.

fix

Prefer using the -table option with filter conditions instead of raw SQL.

affects: >=0.1.0

gotchaThe 'filename' config option must point to an existing SQLite database file; adapter will not create one automatically.

fix

Ensure the SQLite file exists before running Juttle queries.

affects: >=0.1.0

Errors

Common errors & fixes

Error: Cannot find module 'juttle'

Juttle engine not installed as a peer dependency.

fix

Run: npm install juttle

Error: Invalid value for table: must be a string

The -table option requires a string value.

fix

Ensure -table is followed by a table name in quotes, e.g., -table 'my_table'

Error: SQLITE_ERROR: no such table: my_table

The specified table does not exist in the database.

fix

Verify table name and database path in config; create table if needed.

Upgrade

Version history

0.6.0latest on npm

Audit

Dependencies

juttlerequiredpeer dependency: the adapter requires the Juttle runtime to function

Agent activity

6 hits · last 30 days

node

Resources

githubhttps://github.com/juttle/juttle-sqlite-adapter ↗

packagejuttle-sqlite-adapter ↗

homepagehttps://github.com/juttle/juttle-sqlite-adapter ↗