JSON File Database

In small projects, it's not necessary to use actual databases.

I often use JSON files to store data.

However, using JSON and fs is very inconvenient, so this project is designed for this demand.

Features

• Pure TypeScript, helping you make fewer mistakes about types.

• Whenever you change the collection, it will start a debounced timer.

• Uses binary-search to maintain the data, meaning the best time complexity would be O(log n).

Note

There are breaking changes in version 2.x, aiming to provide a customizable primary key rather than id only.

Usage

First, download it by pnpm(or npm, yarn, etc.).

1pnpm add json-file-database

And then use it in your project like this:

1import { connect } from 'json-file-database'
2
3/**
4 * The type of elements must have an `id` property
5 * to make them unique and sorted in the collection.
6 */
7type User = { id: number, name: string }
8
9/**
10 * Connect to the database.
11 * If there is no specified file yet, it will create one after running this program.
12 */
13const db = connect({
14  file: './db.json',
15  init: {
16    users: [
17      { id: 1, name: 'San Zhang' },
18      { id: 2, name: 'Si Li' },
19      { id: 3, name: 'Wu Wang' },
20    ]
21  }
22})
23
24/**
25 * Specify the type of element as `User`.
26 * 
27 * You can go to the documentation to see how to customize all
28 * options, including the `comparator` to compare the elements.
29 */
30const users = db<User>({
31  name: 'users',
32  primaryKey: 'id',
33})
34
35/**
36 * Find the element with its id.
37 */
38console.log('The user whose id is 1 is:', users.find({ id: 1 }))
39
40
41/**
42 * Find all elements that match given condition.
43 */
44console.log('All users whose id <= 2 are:', users.findAll(u => u.id <= 2))
45
46
47/**
48 * Check whether this collection has the element.
49 */
50console.log('Whether the collection has a user whose id is 5:', users.has({ id: 5 }))
51
52
53/**
54 * Insert an element and return whether it has been inserted.
55 */
56console.log('Insert a user whose id is 2:', users.insert({ id: 2, name: 'Liu Zhao' }))
57
58
59/**
60 * List all elements.
61 * 
62 * You can also use `[...users]` or `for...of` because
63 * it has implemented Iterable.
64 */
65console.log('All users are:', Array.from(users))
66
67
68/**
69 * Remove the element and return whether it has been removed.
70 */
71console.log('Remove the user whose id is 1:', users.remove({ id: 1 }))
72
73
74/**
75 * Remove all elements that match the condition, and return the number of them.
76 */
77console.log('Remove all users whose id < 3, the number of them is:',
78        users.removeAll(u => u.id < 3))
79
80
81/**
82 * Update the element with id, and return whether it has been updated.
83 */
84console.log('Update the user whose id is 3:', users.update({ id: 3, name: 'Liu Zhao' }))

The first time you run it, it will create a new file db.json and all outputs are expected. However, when you try to run it again, the outputs are not the same.

This is because if there is no file, it will use the init property when you try to connect the database; otherwise it will read it directly.