Excel-DB

A Node.js wrapper that treats Excel files as a lightweight database with a Schema-like API.

Features

• ✅ Schema-based validation - Define your data structure with types and constraints
• ✅ Primary keys and unique constraints - Automatic validation and constraint checking
• ✅ CRUD operations - Create, Read, Update, Delete with a simple API
• ✅ Automatic file management - Creates Excel files and worksheets as needed
• ✅ Modern ES6+ JavaScript - Clean, modern codebase
• ✅ Built on ExcelJS - Reliable Excel file handling

Installation

1npm install @guru322/excel-db

Quick Start

1import Model from '@guru322/excel-db';
2
3// Define a model with schema
4const User = new Model('User', {
5  id: { type: 'string', primary: true },
6  name: { type: 'string', required: true },
7  email: { type: 'string', unique: true },
8  age: { type: 'number' }
9});
10
11// Create a new user
12const user = await User.create({
13  name: 'John Doe',
14  email: 'john@example.com',
15  age: 30
16});
17
18// Find user by ID
19const foundUser = await User.find(user.id);
20
21// Get all users
22const allUsers = await User.findAll();
23
24// Update user
25const updatedUser = await User.update(user.id, { age: 31 });
26
27// Delete user
28await User.delete(user.id);

Schema Definition

Define your data structure with validation rules:

1const schema = {
2  fieldName: {
3    type: 'string|number|boolean|date',  // Data type
4    primary: true,                       // Primary key (one per model)
5    unique: true,                        // Unique constraint
6    required: true                       // Required field
7  }
8};

API Reference

Model Methods

• create(data) - Create a new record
• find(id) - Find record by primary key
• findAll() - Get all records
• update(id, data) - Update record by primary key
• delete(id) - Delete record by primary key

Error Handling

The package includes custom error types:

• ValidationError - Thrown when data doesn't match schema
• UniqueConstraintError - Thrown when unique constraints are violated

License

MIT