⚙️ @junsiklee/vscode-sqlite3

Installing

You can use npm or yarn to install @junsiklee/vscode-sqlite3:

• (recommended) Latest published package:

1npm install @junsiklee/vscode-sqlite3
2# or
3yarn add @junsiklee/vscode-sqlite3

Add a string to the .vscodeignore file inside the vscode extension project

1!node_modules/@junsiklee/vscode-sqlite3/**/**/**

Example code

1const sqlite3 = require('@junsiklee/vscode-sqlite3').verbose();
2const db = new sqlite3.Database(':memory:');
3
4db.serialize(() => {
5	db.run('CREATE TABLE lorem (info TEXT)');
6
7	const stmt = db.prepare('INSERT INTO lorem VALUES (?)');
8	for (let i = 0; i < 10; i++) {
9		stmt.run('Ipsum ' + i);
10	}
11	stmt.finalize();
12
13	db.each('SELECT rowid AS id, info FROM lorem', (err: any, row: any) => {
14		console.log(row.id + ': ' + row.info);
15	});
16});
17
18db.close();

Reference

⚙️ node-sqlite3