1.8.0 • Published 28 days ago

@hedystia/db v1.8.0

Weekly downloads
-
License
ISC
Repository
github
Last release
28 days ago

Installation

npm i @hedystia/db

yarn add @hedystia/db

Nodejs Version

  • v18.0.0 or higher

Links

Example

const Database = require("@hedystia/db");

// Create a file named database.ht and enter the password
const database = new Database("./database.ht", "password");

// You can only use it once to create the table after that you can no longer use it.
database.createTable("users", ["id", "name", "email"]);

database.insert("users", { id: "1", name: "John Doe", email: "jdoe@example.com" });

database.insert("users", { id: "2", name: "María", email: "maria@example.com" });

const users = database.select("users");

console.log("----------------------------------");

console.log(users);

database.addColumn("users", "phone");

database.addColumn("users", "lang", "en-US");

const newUsersPhone = database.select("users");

console.log("----------------------------------");

console.log(newUsersPhone);

database.deleteColumn("users", "phone");

const oldUsersPhone = database.select("users");

console.log("----------------------------------");

console.log(oldUsersPhone);

const userJohn = database.select("users", { name: "John Doe" });

console.log("----------------------------------");

console.log(userJohn);

database.delete("users", { name: "María" });

const users2 = database.select("users");

console.log("----------------------------------");

console.log(users2);

database.update("users", { id: "1" }, { name: "Jane Doe", lang: "es-ES" });

const users3 = database.select("users");

console.log("----------------------------------");

console.log(users3);

Functions

FunctionDescription
readTablesTo read the tables from the database
createTableTo create a table
deleteTableTo delete a table
createTableIfNotExistsTo create a table if it does not exist
deleteTableIfExistsTo delete a table if it exists
addColumnTo add a column to an already created table
deleteColumnTo remove a column to an already created table
insertTo insert a data in the table
updateTo update a data in the table
selectTo search for information in a table
deleteTo delete a data from the table
1.8.0

28 days ago

1.7.0

29 days ago

1.6.2

1 month ago

1.6.1

1 month ago

1.6.0

1 month ago

1.5.0

1 month ago

1.4.0

1 month ago

1.3.7

2 months ago

1.3.6

2 months ago