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.
Install arlet-db via npm:
npm install arlet-dbconst ArletDb = require('arlet-db');
// Initialize a new database instance
const database = new ArletDb('./', 'exampleDatabase');- 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