How to fix node-sqlite3: SQLITE_CANTOPEN: unable to open database file in SQLite

const sqlite3 = require('sqlite3').verbose();
const fs = require('fs');
const path = require('path');

const dbPath = './database.db';

// Check if file exists
if (!fs.existsSync(dbPath)) {
  console.log('Database file does not exist at:', path.resolve(dbPath));
} else {
  console.log('Database file found at:', path.resolve(dbPath));
}

const path = require('path');

// Bad: Relative path
const db = new sqlite3.Database('./database.db');

// Good: Absolute path
const dbPath = path.join(__dirname, 'database.db');
const db = new sqlite3.Database(dbPath);

// Or for project root
const dbPath = path.join(process.cwd(), 'data', 'database.db');

# Check file permissions
ls -la database.db

# Fix permissions (give owner read/write)
chmod 644 database.db

# Fix ownership if needed
sudo chown $USER:$USER database.db

# Check parent directory permissions (must be writable)
ls -la $(dirname database.db)
chmod 755 /path/to/database/directory

const sqlite3 = require('sqlite3').verbose();
const fs = require('fs');
const path = require('path');

const dbPath = path.join(__dirname, 'data', 'database.db');
const dbDir = path.dirname(dbPath);

// Create directory if it doesn't exist
if (!fs.existsSync(dbDir)) {
  fs.mkdirSync(dbDir, { recursive: true });
}

// Open database with create flag
const db = new sqlite3.Database(dbPath, sqlite3.OPEN_READWRITE | sqlite3.OPEN_CREATE, (err) => {
  if (err) {
    console.error('Error opening database:', err.message);
  } else {
    console.log('Connected to database successfully');
  }
});

# On Linux, check what process has the file open
lsof database.db

# Or using fuser
fuser database.db