Instruction file imported from StratoKit/strato-db (.cursor/rules/DB.mdc). Copyright stays with the author.

DB Module (src/DB)

This module provides the core database interaction layer, abstracting the underlying SQLite database.

Core Components

DB.js

• Purpose: Provides a high-level abstraction for database connections and operations. It likely manages connection pooling and simplifies common database tasks.
• Key Features: (To be determined by analyzing the file)
• Dependencies: SQLite.js, Statement.js

SQLite.js

• Purpose: Wraps the sqlite3 library to provide a more promise-based and potentially enhanced interface for interacting directly with SQLite.
• Key Features: (To be determined by analyzing the file)
• Dependencies: sqlite3, Statement.js

Statement.js

• Purpose: Represents a prepared SQL statement, likely offering methods for binding parameters and executing the statement efficiently.
• Key Features: (To be determined by analyzing the file)
• Dependencies: sqlite3

Usage

(To be determined by analyzing the code and tests)

Dependencies

• sqlite3: The underlying Node.js driver for SQLite.
• async-sema: Likely used for managing concurrency or locking around database operations.
• dataloader: Potentially used for batching and caching database reads.
• debug: Used for logging debug information.
• lodash: Utility library, potentially used for various data manipulations.

Structure

src/
└── DB/
    ├── DB.js           # High-level DB abstraction
    ├── DB.test.js
    ├── SQLite.js       # sqlite3 wrapper
    ├── SQLite.test.ts
    ├── Statement.js    # Prepared statement representation
    ├── Statement.test.js
    └── index.js        # Module entry point (re-exports)