sql.js-as-sqlite3
const database = new sqlJsAsSqlite3.Database(':memory:', () => {
console.log('open')
database.run('CREATE TABLE users (name TEXT)', () => {
database.all('INSERT INTO users (name) VALUES (\'john\')', () => {
database.each('UPDATE users SET name=\'smith\' WHERE name=\'john\'')
database.get('SELECT * FROM users WHERE rowid = 1', (error, row) => {
// Prints: "name: smith"
console.log(row.columns[0] + ': ' + row.values[0][0])
database.close(() => {
console.log('closed')
})
})
})
})
})