Installation

1$ npm install --save node-json-database

Usage

Quick Tutorial:

1import { db } from 'node-json-database'
2
3// Create a database called 'myDB'
4const myDB = db('myDB')
5myDB.create()
6
7// Create a table in the database, called 'friends'
8const friendsTable = myDB.table('friends')
9friendsTable.create()
10
11// Set the columns
12friendsTable.columns.add([
13	{
14		name: 'firstName',
15		dataType: 'String'
16	},
17	{
18		name: 'lastName',
19		dataType: 'String'
20	},
21	{
22		name: 'birthday',
23		dataType: 'DateTime'
24	},
25	{
26		name: 'favouriteNumber',
27		dataType: 'Int'
28	}
29])
30
31// Insert values into the table
32friendsTable.insert([
33	{
34		firstName: 'John',
35		lastName: 'Doe',
36		birthday: new Date('01 Jan 1970').getTime(),
37		favouriteNumber: 42
38	},
39	{
40		firstName: 'Johnny',
41		lastName: 'Doe',
42		birthday: new Date('01 Jan 2000').getTime(),
43		favouriteNumber: 69
44	}
45])
46
47// Find all records with 'Johnny' as firstName
48const search = friendsTable.get().where(row => row.firstName == 'Johnny')
49
50console.log(search.rows)
51
52// Console output:
53
54// [
55// 	{
56// 		firstName: 'Johnny',
57// 		lastName: 'Doe',
58// 		birthday: 946684800000, // This is a UNIX timestamp
59// 		favouriteNumber: 69
60// 	}
61// ]

License

ISC © Iannis de Zwart