# 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:

```bash
npm install arlet-db
```

## Usage

### Initialize Database

```javascript
const ArletDb = require('arlet-db');

// Initialize a new database instance
const database = new ArletDb('./', 'exampleDatabase');
```
### Methods

- [createTable](./docs/createTable.md)
- [createTableIfNotExists](./docs/createTableIfNotExists.md)
- [updateTable](./docs/updateTable.md)
- [getTableSchema](./docs/getTableSchema.md)
- [getTables](./docs/getTables.md)
- [tableExists](./docs/tableExists.md)
- [clearTable](./docs/clearTable.md)
- [clearTableNoForce](./docs/clearTableNoForce.md)
- [deleteTable](./docs/deleteTable.md)
- [columnExists](./docs/columnExists.md)
- [getColumns](./docs/getColumns.md)
- [getColumnsType](./docs/getColumnsType.md)
- [getAutoIncrementColumn](./docs/getAutoIncrementColumn.md)
- [getAutoIncrementValue](./docs/getAutoIncrementValue.md)
- [resetAutoIncrement](./docs/resetAutoIncrement.md)
- [insert](./docs/insert.md)
- [insertIfNotExists](./docs/insertIfNotExists.md)
- [getAll](./docs/getAll.md)
- [query](./docs/query.md)
- [getById](./docs/getById.md)
- [count](./docs/count.md)
- [countWhere](./docs/countWhere.md)
- [sum](./docs/sum.md)
- [avg](./docs/avg.md)
- [selectJoin](./docs/selectJoin.md)
- [select](./docs/select.md)
- [update](./docs/update.md)
- [delete](./docs/delete.md)



