You can use npm or yarn to install @junsiklee/vscode-sqlite3:
- (recommended) Latest published package:
npm install @junsiklee/vscode-sqlite3
# or
yarn add @junsiklee/vscode-sqlite3Add a string to the .vscodeignore file inside the vscode extension project
!node_modules/@junsiklee/vscode-sqlite3/**/**/**Example code
const sqlite3 = require('@junsiklee/vscode-sqlite3').verbose();
const db = new sqlite3.Database(':memory:');
db.serialize(() => {
db.run('CREATE TABLE lorem (info TEXT)');
const stmt = db.prepare('INSERT INTO lorem VALUES (?)');
for (let i = 0; i < 10; i++) {
stmt.run('Ipsum ' + i);
}
stmt.finalize();
db.each('SELECT rowid AS id, info FROM lorem', (err: any, row: any) => {
console.log(row.id + ': ' + row.info);
});
});
db.close();