اتصال به دیتابیس SQLite در برنامه‌های NodeJS

npm install sqlite3

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

const app = express();
const db = new sqlite3.Database('db/database.db');

db.serialize(() => {
  db.run("CREATE TABLE IF NOT EXISTS lorem (info TEXT)");
  const stmt = db.prepare("INSERT INTO lorem VALUES (?)");
  for (let i = 0; i < 10; i++) {
      stmt.run("Ipsum " + i);
  }
  stmt.finalize();
});

app.once('started', () => {
  app.get('/', async (req, res) => {
    db.all("SELECT rowid AS id, info FROM lorem", (err, rows) => {
      if (err) {
        return res.status(500).send('Error retrieving data from database');
      }
      res.send(rows.map(row => `${row.id}: ${row.info}`).join('<br>'));
    });
  });
});

app.listen(3000, () => {
  console.log('Server is running on port 3000');
  app.emit('started');
});

{
    "disks": [
        {
            "name": "database",
            "mountTo": "db"
        }
    ]
}