v2.0.0

• Package got renamed, yay

v1.0.5

• Partially supports WHERE with SELECT
• Result from SELECT now has parse method to parse the data properly

v1.0.4

• fix module name

v1.0.3

• fix typings

v1.0.2

• support for UPDATE
• support for DELETE

v1.0.1

• supports memory db

v1.0.0

JSQL

Use JSON as SQL.

Installing

$ npm i --save @devsnowflake/jsql

Note: This library is very new and does not support most of the statements

Example

const { Database } = require("@devsnowflake/jsql");
const db = new Database("./database.json");

// creating a table
db.prepare(`CREATE TABLE IF NOT EXISTS "DEMO" ("key" TEXT, "value" TEXT)`).run();

// inserting data
db.prepare(`INSERT INTO "DEMO" ("key","value") VALUES ("test_key", "test_value")`).run();

// fetching data
db.prepare(`SELECT * FROM "DEMO"`).run();

// fetching data in limit
db.prepare(`SELECT * FROM "DEMO" LIMIT 3`).run(); // returns 3 items if available

// drop a table
db.prepare(`DROP TABLE "DEMO"`).run();