SQLite Client

Use the sqlite (v5+) + sqlite3 libraries to operate SQLite databases. All APIs return ES6 Promises and support async/await.

Use Cases

• Creating SQLite databases and tables
• Executing SQL queries (SELECT/INSERT/UPDATE/DELETE)
• Database migrations
• Reading or analyzing the contents of .db files
• Importing/exporting data to/from SQLite
• Using in-memory databases for rapid prototyping

Prerequisites

Before performing any database operations, ensure dependencies are installed in the project: