Hire Expert
SQLite Developers

import Database from 'better-sqlite3';

const db = new Database('app.db');

db.exec(`
  CREATE TABLE IF NOT EXISTS users (
    id    INTEGER PRIMARY KEY AUTOINCREMENT,
    email TEXT UNIQUE NOT NULL,
    name  TEXT NOT NULL,
    created_at TEXT DEFAULT (datetime('now'))
  )
`);

const insert = db.prepare('INSERT INTO users (email, name) VALUES (?, ?)');
const getAll = db.prepare('SELECT * FROM users ORDER BY created_at DESC');

// Transaction for batch insert
const insertMany = db.transaction((users) => {
  for (const u of users) insert.run(u.email, u.name);
});

insertMany([{ email: 'a@b.com', name: 'Alice' }, { email: 'b@b.com', name: 'Bob' }]);