The hackable quick.db
npm install @devsnowflake/quick.dbjson.sqlite file as database.
js
const { Database } = require("@devsnowflake/quick.db");
const db = new Database("./data/storage.db", { path: "./data", table: "ROOT" }); // you can also specify custom path/name
// add some data
db.set("foo", "bar");
db.set("hello", "world");
// log all data. You can also use db.all()
for (const data of db) {
console.log(data);
}
`
Basic Example
`js
// Setting an object in the database:
console.log(db.set('userInfo', { difficulty: 'Easy' }))
// -> { difficulty: 'Easy' }
// Pushing an element to an array (that doesn't exist yet) in an object:
console.log(db.push('userInfo.items', 'Sword'))
// -> { difficulty: 'Easy', items: ['Sword'] }
// Adding to a number (that doesn't exist yet) in an object:
console.log(db.add('userInfo.balance', 500))
// -> { difficulty: 'Easy', items: ['Sword'], balance: 500 }
// Repeating previous examples:
console.log(db.push('userInfo.items', 'Watch'))
// -> { difficulty: 'Easy', items: ['Sword', 'Watch'], balance: 500 }
console.log(db.add('userInfo.balance', 500))
// -> { difficulty: 'Easy', items: ['Sword', 'Watch'], balance: 1000 }
// Fetching individual properties
console.log(db.get('userInfo.balance')) // -> 1000
console.log(db.get('userInfo.items')) // ['Sword', 'Watch']
`
Creating a table
`js
const mytable = db.createTable("tableName");
db.set("foo", "bar");
mytable.set("foo", 123);
db.get("foo"); // bar
mytable.get("foo"); // 123
`
List all tables
`js
const tables = db.tables();
console.log(tables);
// { count: 2, tables: [ 'JSON', 'tableName' ] }
`
Executing SQL query
`js
const sqlite = db.database;
const statement = sqlite.prepare("SELECT * FROM JSON WHERE ID IS NOT NULL");
for (const item of statement.iterate()) {
console.log(item);
}
`
Static usage
This db behaves like quick.db.
$3
`js
const db = require("@devsnowflake/quick.db").static();
db.set("foo", "bar");
console.log(db.get("foo"));
`
$3
`js
const db = require("@devsnowflake/quick.db").static("./json.db");
db.set("foo", "bar");
console.log(db.get("foo"));
`
Quick.db API
db.all(options)
This method returns currently used table (or specified table) as array.
db.fetchAll(options)
Alias of db.all().
db.add(key, number, options)
This method can be used for addition (numbers).
db.delete(key, options)
This method can be used to remove specific data with its key.
db.fetch(key, options)
This method can be used to get data from the database.
db.get(key, options)
Alias of db.fetch.
db.set(key, value, options)
This method can be used to update existing data or add new data.
db.subtract(key, number, options)
Similar to db.add, this method can be used for subtraction.
db.has(key, options)
Returns true if it finds the requested key in the database.
db.type(key, options)
Returns data type of the value assigned to this key.
db.push(key, valueOrValues)
This method can be used to push the data (Similar to Array.prototype.push).
Non-quick.db API
Methods
$3
Similar to Array.prototype.find.
$3
Similar to Array.prototype.some.
$3
Similar to Array.prototype.map.
$3
Similar to Array.prototype.flatMap.
$3
Similar to Array.prototype.forEach.
$3
Similar to Array.prototype.every.
$3
Similar to Array.prototype.findIndex.
$3
Similar to Array.prototype.indexOf.
$3
Similar to Array.prototype.reduce.
$3
Similar to Array.prototype.reduceRight.
$3
Similar to Array.prototype.sort.
$3
Returns all table name.
$3
If not available, creates a new table with the given name otherwise uses existing table and returns new database with that table as root table.
$3
Drops current table or specified table.
$3
Returns array of keys.
$3
Returns array of values.
$3
Returns array of this table.
$3
Division for existing data with the given number.
$3
Multiplication for existing data with the given number.
$3
Modulus for existing data with the given number.
$3
Similar to db.all but easier method to sort by key.
$3
Similar to db.all but easier method to sort by key.
$3
Used to pull data from the array stored inside the database. (Reverse .push)
$3
Deletes all data from the specified table.
$3
File size of this db.
$3
Allows you to evaluate anything inside Database class using this.
$3
A method that just creates table rather than returning new database.
$3
Exports database into json data.
$3
This method updates current database manager with a new one. Database parameter can either be Database instance or BetterSQLite3.Database instance.
$3
Returns array of all tables with their table name.
$3
This method is similar to db.allTableArray but returns whole data as single array (like db.all).
Properties
$3
Current database manager.
$3
Number of rows in this table.
$3
Database path.
$3
Database file name.
$3
Root table name used while instantiating this database.
$3
Alias of db.rowCount`.