arlet-db v1.0.8

Arlet-Db

Arlet-Db is a simple file-based database manager for Node.js, designed for managing tables with basic CRUD operations and additional functionalities like auto-increment and unique identifiers.

Installation

Install arlet-db via npm:

npm install arlet-db

Usage

Initialize Database

const ArletDb = require('arlet-db');

// Initialize a new database instance
const database = new ArletDb('./', 'exampleDatabase');

Methods

• createTable
• createTableIfNotExists
• updateTable
• getTableSchema
• getTables
• tableExists
• clearTable
• clearTableNoForce
• deleteTable
• columnExists
• getColumns
• getColumnsType
• getAutoIncrementColumn
• getAutoIncrementValue
• resetAutoIncrement
• insert
• insertIfNotExists
• getAll
• query
• getById
• count
• countWhere
• sum
• avg
• selectJoin
• select
• update
• delete