levelup vs lowdb vs mongodb-memory-server vs nedb vs pouchdb vs sqlite3
Node.js Database Libraries
leveluplowdbmongodb-memory-servernedbpouchdbsqlite3Similar Packages:

Node.js Database Libraries

Node.js Database Libraries are tools that allow Node.js applications to interact with various types of databases, including relational, NoSQL, and in-memory databases. These libraries provide APIs for performing CRUD (Create, Read, Update, Delete) operations, managing connections, and executing queries. They abstract the complexities of database interactions, making it easier for developers to integrate data storage and retrieval functionalities into their applications. Examples include mongoose for MongoDB, sequelize for SQL databases, and knex for query building.

Npm Package Weekly Downloads Trend

3 Years

Github Stars Ranking

Stat Detail

Package
Downloads
Stars
Size
Issues
Publish
License
levelup04,076-05 years agoMIT
lowdb022,53322.9 kB152 years agoMIT
mongodb-memory-server02,8284.54 kB1518 days agoMIT
nedb013,549-20910 years agoSEE LICENSE IN LICENSE
pouchdb017,5625.53 MB1732 years agoApache-2.0
sqlite306,4143.4 MB1682 months agoBSD-3-Clause

Feature Comparison: levelup vs lowdb vs mongodb-memory-server vs nedb vs pouchdb vs sqlite3

Database Type

  • levelup:

    levelup is a Node.js library that provides a simple, high-level API for interacting with LevelDB and other key-value stores. It is designed for applications that require fast, low-latency access to data stored as key-value pairs.

  • lowdb:

    lowdb is a small local JSON database powered by Lodash. It is a simple and lightweight solution for storing data in JSON format, making it ideal for small projects, prototypes, or applications that need a quick and easy way to manage data without the complexity of a full database system.

  • mongodb-memory-server:

    mongodb-memory-server is a Node.js package that allows you to spin up a MongoDB server in memory for testing purposes. It is particularly useful for automated tests, as it eliminates the need for a separate MongoDB instance and allows for quick setup and teardown of the database.

  • nedb:

    nedb is a lightweight, embedded NoSQL database for Node.js applications. It stores data in JSON format and provides a simple API for CRUD operations, making it easy to integrate into projects that require a fast and efficient way to manage data without the overhead of a full database server.

  • pouchdb:

    pouchdb is an open-source JavaScript database that syncs with CouchDB and other compatible servers. It is designed for web and mobile applications, providing offline storage and synchronization capabilities, making it ideal for apps that need to work seamlessly without an internet connection.

  • sqlite3:

    sqlite3 is a Node.js driver for SQLite, a self-contained, serverless, and lightweight relational database. It provides a simple API for executing SQL queries and managing database files, making it a popular choice for small to medium-sized applications that require a reliable and easy-to-use database solution.

Use Case

  • levelup:

    levelup is ideal for applications that require fast, low-latency access to key-value data, such as caching, real-time analytics, and lightweight data storage solutions.

  • lowdb:

    lowdb is perfect for small projects, prototypes, or applications that need a simple, file-based database without the complexity of a full database system.

  • mongodb-memory-server:

    mongodb-memory-server is designed for testing environments where you need a temporary MongoDB instance for running automated tests without the overhead of managing a real database server.

  • nedb:

    nedb is suitable for small to medium-sized applications that need a simple, embedded database for quick data access, such as desktop applications, small web apps, and IoT devices.

  • pouchdb:

    pouchdb is ideal for web and mobile applications that require offline data storage and synchronization with a remote database, providing a seamless experience for users with intermittent internet connectivity.

  • sqlite3:

    sqlite3 is a great choice for applications that need a lightweight relational database with full SQL support, such as mobile apps, desktop applications, and small web applications.

Data Storage

  • levelup:

    levelup stores data as key-value pairs in LevelDB or other compatible backends, providing fast read and write operations with low latency.

  • lowdb:

    lowdb stores data in JSON format within a single file, allowing for easy read and write operations using a simple API.

  • mongodb-memory-server:

    mongodb-memory-server stores data in a MongoDB-compatible format, allowing you to perform standard MongoDB operations in an in-memory environment.

  • nedb:

    nedb stores data in JSON format, either in memory or on disk, depending on the configuration, allowing for fast access and simple data management.

  • pouchdb:

    pouchdb stores data in a JSON format, supporting both local storage and synchronization with remote CouchDB-compatible databases.

  • sqlite3:

    sqlite3 stores data in a structured format using tables, rows, and columns, allowing for complex queries and data relationships.

Code Example

  • levelup:

    levelup Example

    const levelup = require('levelup');
    const leveldown = require('leveldown');
    
    const db = levelup(leveldown('./mydb'));
    
    db.put('key1', 'value1', (err) => {
      if (err) return console.error('Error writing to database:', err);
      db.get('key1', (err, value) => {
        if (err) return console.error('Error reading from database:', err);
        console.log('Retrieved value:', value);
      });
    });
    
  • lowdb:

    lowdb Example

    const { Low, JSONFile } = require('lowdb');
    
    const db = new Low(new JSONFile('db.json'));
    
    db.read();
    
    db.data ||= { posts: [] };
    
    db.data.posts.push({ id: 1, title: 'Lowdb is awesome' });
    
    db.write();
    
    console.log(db.data);
    
  • mongodb-memory-server:

    mongodb-memory-server Example

    const { MongoMemoryServer } = require('mongodb-memory-server');
    const mongoose = require('mongoose');
    
    const startServer = async () => {
      const mongoServer = await MongoMemoryServer.create();
      await mongoose.connect(mongoServer.getUri());
      console.log('Connected to in-memory MongoDB');
    };
    
    startServer();
    
  • nedb:

    nedb Example

    const Datastore = require('nedb');
    const db = new Datastore({ filename: 'data.db', autoload: true });
    
    db.insert({ name: 'Alice' }, (err, newDoc) => {
      if (err) console.error(err);
      console.log('Inserted:', newDoc);
    });
    
    db.find({ name: 'Alice' }, (err, docs) => {
      if (err) console.error(err);
      console.log('Found:', docs);
    });
    
  • pouchdb:

    pouchdb Example

    const PouchDB = require('pouchdb');
    const db = new PouchDB('mydb');
    
    db.put({ _id: 'doc1', title: 'Hello, PouchDB!' }).then(() => {
      return db.get('doc1');
    }).then((doc) => {
      console.log('Retrieved document:', doc);
    }).catch((err) => {
      console.error('Error:', err);
    });
    
  • sqlite3:

    sqlite3 Example

    const sqlite3 = require('sqlite3').verbose();
    const db = new sqlite3.Database(':memory:');
    
    db.serialize(() => {
      db.run('CREATE TABLE user (id INT, name TEXT)');
      const stmt = db.prepare('INSERT INTO user VALUES (?, ?)');
      stmt.run(1, 'Alice');
      stmt.finalize();
    
      db.each('SELECT * FROM user', (err, row) => {
        console.log(row);
      });
    });
    
    db.close();
    

How to Choose: levelup vs lowdb vs mongodb-memory-server vs nedb vs pouchdb vs sqlite3

  • levelup:

    Choose levelup if you need a simple, high-level API for interacting with LevelDB or other key-value stores. It is suitable for applications that require fast, low-latency data access with a focus on simplicity and performance.

  • lowdb:

    Choose lowdb if you need a lightweight, file-based JSON database for small projects or prototyping. It is easy to set up and use, making it ideal for applications that do not require a full-fledged database system.

  • mongodb-memory-server:

    Choose mongodb-memory-server if you need a lightweight, in-memory MongoDB instance for testing purposes. It is perfect for automated tests and CI/CD pipelines, allowing you to run tests without needing a real MongoDB server.

  • nedb:

    Choose nedb if you need a simple, embedded NoSQL database for Node.js applications. It is lightweight, fast, and stores data in JSON format, making it suitable for small to medium-sized applications that require quick data access without the overhead of a full database server.

  • pouchdb:

    Choose pouchdb if you need a client-side database that syncs with CouchDB and other compatible servers. It is ideal for applications that require offline capabilities and data synchronization across devices.

  • sqlite3:

    Choose sqlite3 if you need a self-contained, serverless SQL database that is easy to set up and use. It is suitable for small to medium-sized applications, mobile apps, and projects that require a lightweight relational database with full SQL support.

README for levelup

levelup

level badge npm Node version Test Coverage Standard Common Changelog Donate

Table of Contents

Click to expand

Introduction

Fast and simple storage. A Node.js wrapper for abstract-leveldown compliant stores, which follow the characteristics of LevelDB.

LevelDB is a simple key-value store built by Google. It's used in Google Chrome and many other products. LevelDB supports arbitrary byte arrays as both keys and values, singular get, put and delete operations, batched put and delete, bi-directional iterators and simple compression using the very fast Snappy algorithm.

LevelDB stores entries sorted lexicographically by keys. This makes the streaming interface of levelup - which exposes LevelDB iterators as Readable Streams - a very powerful query mechanism.

The most common store is leveldown which provides a pure C++ binding to LevelDB. Many alternative stores are available such as level.js in the browser or memdown for an in-memory store. They typically support strings and Buffers for both keys and values. For a richer set of data types you can wrap the store with encoding-down.

The level package is the recommended way to get started. It conveniently bundles levelup, leveldown and encoding-down. Its main export is levelup - i.e. you can do var db = require('level').

Supported Platforms

We aim to support Active LTS and Current Node.js releases as well as browsers. For support of the underlying store, please see the respective documentation.

Sauce Test Status

Usage

If you are upgrading: please see UPGRADING.md.

First you need to install levelup! No stores are included so you must also install leveldown (for example).

$ npm install levelup leveldown

All operations are asynchronous. If you do not provide a callback, a Promise is returned.

var levelup = require('levelup')
var leveldown = require('leveldown')

// 1) Create our store
var db = levelup(leveldown('./mydb'))

// 2) Put a key & value
db.put('name', 'levelup', function (err) {
  if (err) return console.log('Ooops!', err) // some kind of I/O error

  // 3) Fetch by key
  db.get('name', function (err, value) {
    if (err) return console.log('Ooops!', err) // likely the key was not found

    // Ta da!
    console.log('name=' + value)
  })
})

API

levelup(db[, options[, callback]])

The main entry point for creating a new levelup instance.

  • db must be an abstract-leveldown compliant store.
  • options is passed on to the underlying store when opened and is specific to the type of store being used

Calling levelup(db) will also open the underlying store. This is an asynchronous operation which will trigger your callback if you provide one. The callback should take the form function (err, db) {} where db is the levelup instance. If you don't provide a callback, any read & write operations are simply queued internally until the store is fully opened, unless it fails to open, in which case an error event will be emitted.

This leads to two alternative ways of managing a levelup instance:

levelup(leveldown(location), options, function (err, db) {
  if (err) throw err

  db.get('foo', function (err, value) {
    if (err) return console.log('foo does not exist')
    console.log('got foo =', value)
  })
})

Versus the equivalent:

// Will throw if an error occurs
var db = levelup(leveldown(location), options)

db.get('foo', function (err, value) {
  if (err) return console.log('foo does not exist')
  console.log('got foo =', value)
})

db.supports

A read-only manifest. Might be used like so:

if (!db.supports.permanence) {
  throw new Error('Persistent storage is required')
}

if (db.supports.bufferKeys && db.supports.promises) {
  await db.put(Buffer.from('key'), 'value')
}

db.open([options][, callback])

Opens the underlying store. In general you shouldn't need to call this method directly as it's automatically called by levelup(). However, it is possible to reopen the store after it has been closed with close().

If no callback is passed, a promise is returned.

db.close([callback])

close() closes the underlying store. The callback will receive any error encountered during closing as the first argument.

You should always clean up your levelup instance by calling close() when you no longer need it to free up resources. A store cannot be opened by multiple instances of levelup simultaneously.

If no callback is passed, a promise is returned.

db.put(key, value[, options][, callback])

put() is the primary method for inserting data into the store. Both key and value can be of any type as far as levelup is concerned.

options is passed on to the underlying store.

If no callback is passed, a promise is returned.

db.get(key[, options][, callback])

Get a value from the store by key. The key can be of any type. If it doesn't exist in the store then the callback or promise will receive an error. A not-found err object will be of type 'NotFoundError' so you can err.type == 'NotFoundError' or you can perform a truthy test on the property err.notFound.

db.get('foo', function (err, value) {
  if (err) {
    if (err.notFound) {
      // handle a 'NotFoundError' here
      return
    }
    // I/O or other error, pass it up the callback chain
    return callback(err)
  }

  // .. handle `value` here
})

The optional options object is passed on to the underlying store.

If no callback is passed, a promise is returned.

db.getMany(keys[, options][, callback])

Get multiple values from the store by an array of keys. The optional options object is passed on to the underlying store.

The callback function will be called with an Error if the operation failed for any reason. If successful the first argument will be null and the second argument will be an array of values with the same order as keys. If a key was not found, the relevant value will be undefined.

If no callback is provided, a promise is returned.

db.del(key[, options][, callback])

del() is the primary method for removing data from the store.

db.del('foo', function (err) {
  if (err)
    // handle I/O or other error
});

options is passed on to the underlying store.

If no callback is passed, a promise is returned.

db.batch(array[, options][, callback]) (array form)

batch() can be used for very fast bulk-write operations (both put and delete). The array argument should contain a list of operations to be executed sequentially, although as a whole they are performed as an atomic operation inside the underlying store.

Each operation is contained in an object having the following properties: type, key, value, where the type is either 'put' or 'del'. In the case of 'del' the value property is ignored. Any entries with a key of null or undefined will cause an error to be returned on the callback and any type: 'put' entry with a value of null or undefined will return an error.

const ops = [
  { type: 'del', key: 'father' },
  { type: 'put', key: 'name', value: 'Yuri Irsenovich Kim' },
  { type: 'put', key: 'dob', value: '16 February 1941' },
  { type: 'put', key: 'spouse', value: 'Kim Young-sook' },
  { type: 'put', key: 'occupation', value: 'Clown' }
]

db.batch(ops, function (err) {
  if (err) return console.log('Ooops!', err)
  console.log('Great success dear leader!')
})

options is passed on to the underlying store.

If no callback is passed, a promise is returned.

db.batch() (chained form)

batch(), when called with no arguments will return a Batch object which can be used to build, and eventually commit, an atomic batch operation. Depending on how it's used, it is possible to obtain greater performance when using the chained form of batch() over the array form.

db.batch()
  .del('father')
  .put('name', 'Yuri Irsenovich Kim')
  .put('dob', '16 February 1941')
  .put('spouse', 'Kim Young-sook')
  .put('occupation', 'Clown')
  .write(function () { console.log('Done!') })

batch.put(key, value[, options])

Queue a put operation on the current batch, not committed until a write() is called on the batch. The options argument, if provided, must be an object and is passed on to the underlying store.

This method may throw a WriteError if there is a problem with your put (such as the value being null or undefined).

batch.del(key[, options])

Queue a del operation on the current batch, not committed until a write() is called on the batch. The options argument, if provided, must be an object and is passed on to the underlying store.

This method may throw a WriteError if there is a problem with your delete.

batch.clear()

Clear all queued operations on the current batch, any previous operations will be discarded.

batch.length

The number of queued operations on the current batch.

batch.write([options][, callback])

Commit the queued operations for this batch. All operations not cleared will be written to the underlying store atomically, that is, they will either all succeed or fail with no partial commits.

The optional options object is passed to the .write() operation of the underlying batch object.

If no callback is passed, a promise is returned.

db.status

A readonly string that is one of:

  • new - newly created, not opened or closed
  • opening - waiting for the underlying store to be opened
  • open - successfully opened the store, available for use
  • closing - waiting for the store to be closed
  • closed - store has been successfully closed.

db.isOperational()

Returns true if the store accepts operations, which in the case of levelup means that status is either opening or open, because it opens itself and queues up operations until opened.

db.createReadStream([options])

Returns a Readable Stream of key-value pairs. A pair is an object with key and value properties. By default it will stream all entries in the underlying store from start to end. Use the options described below to control the range, direction and results.

db.createReadStream()
  .on('data', function (data) {
    console.log(data.key, '=', data.value)
  })
  .on('error', function (err) {
    console.log('Oh my!', err)
  })
  .on('close', function () {
    console.log('Stream closed')
  })
  .on('end', function () {
    console.log('Stream ended')
  })

You can supply an options object as the first parameter to createReadStream() with the following properties:

  • gt (greater than), gte (greater than or equal) define the lower bound of the range to be streamed. Only entries where the key is greater than (or equal to) this option will be included in the range. When reverse=true the order will be reversed, but the entries streamed will be the same.

  • lt (less than), lte (less than or equal) define the higher bound of the range to be streamed. Only entries where the key is less than (or equal to) this option will be included in the range. When reverse=true the order will be reversed, but the entries streamed will be the same.

  • reverse (boolean, default: false): stream entries in reverse order. Beware that due to the way that stores like LevelDB work, a reverse seek can be slower than a forward seek.

  • limit (number, default: -1): limit the number of entries collected by this stream. This number represents a maximum number of entries and may not be reached if you get to the end of the range first. A value of -1 means there is no limit. When reverse=true the entries with the highest keys will be returned instead of the lowest keys.

  • keys (boolean, default: true): whether the results should contain keys. If set to true and values set to false then results will simply be keys, rather than objects with a key property. Used internally by the createKeyStream() method.

  • values (boolean, default: true): whether the results should contain values. If set to true and keys set to false then results will simply be values, rather than objects with a value property. Used internally by the createValueStream() method.

db.createKeyStream([options])

Returns a Readable Stream of keys rather than key-value pairs. Use the same options as described for createReadStream() to control the range and direction.

You can also obtain this stream by passing an options object to createReadStream() with keys set to true and values set to false. The result is equivalent; both streams operate in object mode.

db.createKeyStream()
  .on('data', function (data) {
    console.log('key=', data)
  })

// same as:
db.createReadStream({ keys: true, values: false })
  .on('data', function (data) {
    console.log('key=', data)
  })

db.createValueStream([options])

Returns a Readable Stream of values rather than key-value pairs. Use the same options as described for createReadStream() to control the range and direction.

You can also obtain this stream by passing an options object to createReadStream() with values set to true and keys set to false. The result is equivalent; both streams operate in object mode.

db.createValueStream()
  .on('data', function (data) {
    console.log('value=', data)
  })

// same as:
db.createReadStream({ keys: false, values: true })
  .on('data', function (data) {
    console.log('value=', data)
  })

db.iterator([options])

Returns an abstract-leveldown iterator, which is what powers the readable streams above. Options are the same as the range options of createReadStream() and are passed to the underlying store.

These iterators support for await...of:

for await (const [key, value] of db.iterator()) {
  console.log(value)
}

db.clear([options][, callback])

Delete all entries or a range. Not guaranteed to be atomic. Accepts the following range options (with the same rules as on iterators):

  • gt (greater than), gte (greater than or equal) define the lower bound of the range to be deleted. Only entries where the key is greater than (or equal to) this option will be included in the range. When reverse=true the order will be reversed, but the entries deleted will be the same.
  • lt (less than), lte (less than or equal) define the higher bound of the range to be deleted. Only entries where the key is less than (or equal to) this option will be included in the range. When reverse=true the order will be reversed, but the entries deleted will be the same.
  • reverse (boolean, default: false): delete entries in reverse order. Only effective in combination with limit, to remove the last N records.
  • limit (number, default: -1): limit the number of entries to be deleted. This number represents a maximum number of entries and may not be reached if you get to the end of the range first. A value of -1 means there is no limit. When reverse=true the entries with the highest keys will be deleted instead of the lowest keys.

If no options are provided, all entries will be deleted. The callback function will be called with no arguments if the operation was successful or with an WriteError if it failed for any reason.

If no callback is passed, a promise is returned.

What happened to db.createWriteStream?

db.createWriteStream() has been removed in order to provide a smaller and more maintainable core. It primarily existed to create symmetry with db.createReadStream() but through much discussion, removing it was the best course of action.

The main driver for this was performance. While db.createReadStream() performs well under most use cases, db.createWriteStream() was highly dependent on the application keys and values. Thus we can't provide a standard implementation and encourage more write-stream implementations to be created to solve the broad spectrum of use cases.

Check out the implementations that the community has produced here.

Promise Support

Each function accepting a callback returns a promise if the callback is omitted. The only exception is the levelup constructor itself, which if no callback is passed will lazily open the underlying store in the background.

Example:

const db = levelup(leveldown('./my-db'))
await db.put('foo', 'bar')
console.log(await db.get('foo'))

Events

levelup is an EventEmitter and emits the following events.

EventDescriptionArguments
putKey has been updatedkey, value (any)
delKey has been deletedkey (any)
batchBatch has executedoperations (array)
clearEntries were deletedoptions (object)
openingUnderlying store is opening-
openStore has opened-
readyAlias of open-
closingStore is closing-
closedStore has closed.-
errorAn error occurrederror (Error)

For example you can do:

db.on('put', function (key, value) {
  console.log('inserted', { key, value })
})

Multi-process Access

Stores like LevelDB are thread-safe but they are not suitable for accessing with multiple processes. You should only ever have a store open from a single Node.js process. Node.js clusters are made up of multiple processes so a levelup instance cannot be shared between them either.

See Level/awesome for modules like multileveldown that may help if you require a single store to be shared across processes.

Contributing

Level/levelup is an OPEN Open Source Project. This means that:

Individuals making significant and valuable contributions are given commit-access to the project to contribute as they see fit. This project is more like an open wiki than a standard guarded open source project.

See the Contribution Guide for more details.

Big Thanks

Cross-browser Testing Platform and Open Source ♥ Provided by Sauce Labs.

Sauce Labs logo

Donate

Support us with a monthly donation on Open Collective and help us continue our work.

License

MIT