Breaking News: Grepper is joining You.com. Read the official announcement!

express.js sqlite

Jerome Scott answered on January 1, 2023 Popularity 10/10 Helpfulness 3/10

answer express.js sqlite

express.js sqlite

Comment

const express = require('express');
const sqlite3 = require('sqlite3').verbose();

const app = express();

// open a database connection
const db = new sqlite3.Database('mydb.sqlite3');

// create a table
db.run('CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, name TEXT)');

// insert a new row
db.run('INSERT INTO users (name) VALUES (?)', 'Alice');

// select rows
db.all('SELECT * FROM users', (err, rows) => {
  console.log(rows);
});

// update a row
db.run('UPDATE users SET name = ? WHERE id = ?', 'Bob', 1);

// delete a row
db.run('DELETE FROM users WHERE id = ?', 1);

// close the database connection
db.close();

app.listen(3000, () => {
  console.log('Listening on port 3000');
});

Popularity 10/10 Helpfulness 3/10 Language javascript

Source: Grepper

Tags: crud javascript sqlite

Link to this answer
Share Copy Link

Contributed on Jan 01 2023

Jerome Scott

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

express.js sqlite

Contents

More Related Answers

express.js sqlite

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.