@cotter45/jsdb NPM

JSDB

A lightweight, file-based JSON database manager for Node.js. This is especially useful for small-scale applications, prototyping or for when a full-blown database setup is unnecessary.

Features

Supports basic CRUD operations (Create, Read, Update, Delete) as well as full text search on JSON collections.
Each collection is managed separately, allowing for high flexibility.
Asynchronous operations using Promises.
File-based storage, each collection is created in it's own directory and manages it's own documents.
Data consistency is ensured by using a promise-based queue to manage operations.

Installation

Install via npm:

npm install @cotter45/jsdb

Usage

import JSDB from '@cotter45/jsdb';

// Initialize JSDB with an absolute or relative path
// This will create a new database if it doesn't exist
// or load an existing one if it does
const db = new JSDB('./data');

// Create a collection, specify the name and the maximum size of each document in bytes - default is 100KB
// If the collection already exists, it will be loaded
const users = db.createCollection('users', 10 * 1024 * 1024);

// Mthods on collections are async
const user = await users.insert({
  name: 'Alice',
  email: 'alice@wonderland.com',
});

// Delete a collection
await db.deleteCollection('users');

Collection Operations

Operations on a collection can be performed using the methods provided by the JsonCollectionManager class. For example:

Create the collection first

import JSDB from '@cotter45/jsdb';

// Initialize JSDB with an absolute or relative path
const db = new JSDB('./data');

// Create a collection
const users = db.createCollection('users');

Insert

// Insert a record, automatically generates an id<number>
const insertUser = await users.insert({
  name: 'Alice',
  email: 'alice@wonderland.com',
});
// insertUser = { id: 1, name: 'Alice', email: 'alice@wonderland' }

Get

// Get a record, will throw an error if the record doesn't exist
const getUser = await users.get(1);
// getUser = { id: 1, name: 'Alice', email: 'alice@wonderland' }

Update

// Update a record, don't change the id and report a bug please...
const updateUser = await users.update(1, {
  name: 'Bob',
  email: 'bob@example.com',
});
// updateUser = { id: 1, name: 'Bob', email: 'bob@example' }

Delete

// Delete a record, will return the deleted record
const deleteUser = await users.delete(1);
// deleteUser = { id: 1, name: 'Bob', email: 'bob@example' }

Search

// Search for records using Fuse.js
// Limit and offset are optional
const searchUser = await users.search('bob@exa', {
  keys: ['email'],
  limit: 1,
  offset: 0,
});
// searchUser = [{ id: 1, name: 'Bob', email: 'bob@example' }]

Where

// Custom filter function, passed as callback to Array.filter()
// Limit, offset, and order are optional
const whereUser = await users.where({
  filter: (user) => user.name === 'Bob',
  limit: 1,
  offset: 0,
  order: 'desc',
});
// whereUser = [{ id: 1, name: 'Bob', email: 'bob@example' }]