sqlite-gui-node

library1.4.0jsnpmunverified

sqlite-gui-node v1.4.0 is an open-source, TypeScript-powered GUI for SQLite databases in Node.js applications, designed for rapid prototyping and debugging. It provides a web-based interface to browse, query, and manage databases without external tools. Key differentiators: zero-config setup (starts on localhost:8080), optional Express middleware integration, and full CRUD support. Release cadence is low (last major update 2023), with basic documentation and limited community adoption.

database devops

npm install sqlite-gui-node

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · SQLITE-GUI-NODE

sqlite-gui-node

databasejavascriptv1.4.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.

SqliteGuiNode

✓ const { SqliteGuiNode } = require('sqlite-gui-node')

✗ const SqliteGuiNode = require('sqlite-gui-node')

Named export, not default. Use destructuring.

SqliteGuiNode

✓ import { SqliteGuiNode } from 'sqlite-gui-node'

ESM named import works if project supports ES modules.

SqliteGuiNodeMiddleware

✓ const { SqliteGuiNodeMiddleware } = require('sqlite-gui-node')

✗ const SqliteGuiNodeMiddleware = require('sqlite-gui-node').SqliteGuiNodeMiddleware

Same destructuring pattern.

createSqliteGuiApp

✓ const { createSqliteGuiApp } = require('sqlite-gui-node')

✗ const createSqliteGuiApp = require('sqlite-gui-node')

Named export for async function.

Initialize standalone GUI server with an in-memory SQLite database and start Express on port 4000.

const express = require('express'); const sqlite3 = require('sqlite3').verbose(); const db = new sqlite3.Database(':memory:'); const { SqliteGuiNode } = require('sqlite-gui-node'); const app = express(); SqliteGuiNode(db).catch(err => { console.error('Error starting the GUI:', err); }); app.listen(4000, () => console.log('Server running on port 4000')); // Access GUI at http://localhost:8080/home

Debug

Known issues

gotchaSqliteGuiNode() starts its own HTTP server on port 8080 by default; if port is occupied it will throw an error.

fix

Pass a custom port as second argument or use Middleware/integration mode to avoid port conflict.

affects: >=1.0.0

gotchaThe middleware SqliteGuiNodeMiddleware requires both app and db arguments; omitting app will cause runtime errors.

fix

Always call with (app, db).

affects: >=1.0.0

gotchacreateSqliteGuiApp returns a promise; must be awaited before use with app.use().

fix

Use await createSqliteGuiApp(db) or handle with .then().

affects: >=1.0.0

Errors

Common errors & fixes

TypeError: Cannot destructure property 'SqliteGuiNode' of 'require(...)' as it is undefined.

Requiring the package without destructuring when it only exports named exports.

fix

Use const { SqliteGuiNode } = require('sqlite-gui-node');

Error: listen EADDRINUSE :::8080

Default port 8080 is already in use by another process or the GUI server is started twice.

fix

Specify a different port: SqliteGuiNode(db, 3005); or kill the process using port 8080.

TypeError: sqliteGuiApp is not a function

Calling createSqliteGuiApp without awaiting it, so sqliteGuiApp is a Promise instead of a router.

fix

Use const sqliteGuiApp = await createSqliteGuiApp(db);

Upgrade

Version history

1.4.0latest on npm

Audit

Dependencies

expressoptionalMiddleware mode requires Express app instance

sqlite3requiredDatabase driver passed as parameter

Agent activity

15 hits · last 30 days

node