OutlineDev
Back to Guides
Node.jsSQLiteDatabaseLocal-FirstPerformance

Native SQLite in Node.js: Do You Even Need a Database Server?

B
Backend Architect
Featured Guide 18 min read

Delete your docker-compose.yml.

For years, the first step of any Node.js project was "spin up a Postgres container".

With modern NVMe SSDs and Node.js 22.5+, a local SQLite file using the native driver often creates a simpler, faster, and zero-latency architecture for 99% of microservices.

02. Zero Dependencies

No npm install better-sqlite3. No python compilation errors. It's built right into the binary.

// index.js
import
{'{'} Database {'}'}
from
'node:sqlite';

// Synchronous (Fast!)
const
db =
new
Database('./data.db');

// Prepared Statements
const
query = db.prepare('SELECT * FROM users WHERE id = ?');
const
user = query.get(1);

03. It Scales (WAL Mode)

"But SQLite doesn't handle concurrency!"
False. In WAL (Write-Ahead Logging) mode, readers do not block writers. You can handle thousands of reads per second on a single file.

db.exec('PRAGMA journal_mode = WAL');

04. The Senior Engineer's Take

Complexity is the enemy.

If your service has < 100GB of data and runs on a single node (even with replicas using LiteFS), Postgres is over-engineering.

The reliability of a simple file on disk is unmatched. Backups are just cp data.db backup.db.

⚡ Interactive Playground

import React, { useState } from 'react';

// 🗄️ Database Architecture Visualizer

export default function DbDemo() {
    const [arch, setArch] = useState('postgres'); // postgres | sqlite
    const [requests, setRequests] = useState([]);
    const [latency, setLatency] = useState({ p95: 0, last: 0 });

    const simulateRequest = () => {
        const id = Math.random();
        
        // Simulating network latency vs disk latency
        // Postgres: App -> Network -> DB -> Network -> App (~5-10ms)
        // SQLite: App -> Disk -> App (~0.1ms)
        
        const tripTime = arch === 'postgres' ? 800 : 150; // Visual ms
        const realLatency = arch === 'postgres' ? 12 : 0.4; // Text ms

        setRequests(prev => [...prev, { id, status: 'sent', startTime: Date.now() }]);
        setLatency({ p95: realLatency, last: realLatency });

        setTimeout(() => {
            setRequests(prev => prev.filter(r => r.id !== id));
        }, tripTime);
    };

    return (
        <div className="bg-slate-50 dark:bg-slate-950 p-8 rounded-3xl border border-slate-200 dark:border-slate-800 shadow-xl">
             <div className="flex justify-between items-center mb-10">
                <h3 className="text-2xl font-black text-gray-900 dark:text-white flex items-center gap-3">
                    <span className="text-blue-500">🗄️</span> Architecture Latency
                </h3>
                <div className="flex bg-slate-200 dark:bg-slate-900 p-1 rounded-xl">
                    <button 
                        onClick={() => setArch('postgres')}
                        className={`px-6 py-2 rounded-lg font-bold text-sm transition-all ${arch === 'postgres' ? 'bg-white dark:bg-slate-800 shadow text-blue-500' : 'text-slate-500'}`}
                    >
                        Traditional (Postgres)
                    </button>
                    <button 
                        onClick={() => setArch('sqlite')}
                        className={`px-6 py-2 rounded-lg font-bold text-sm transition-all ${arch === 'sqlite' ? 'bg-white dark:bg-slate-800 shadow text-green-500' : 'text-slate-500'}`}
                    >
                        Embedded (SQLite)
                    </button>
                </div>
            </div>

            <div className="grid grid-cols-1 lg:grid-cols-2 gap-12 relative min-h-[300px]">
                
                {/* Application Server */}
                <div className="bg-white dark:bg-slate-900 p-6 rounded-2xl border border-slate-200 dark:border-slate-800 z-10 flex flex-col items-center justify-center shadow-lg">
                    <div className="bg-gray-100 dark:bg-slate-800 p-4 rounded-full mb-4">
                        <span className="text-3xl">🖥️</span>
                    </div>
                    <div className="font-bold text-gray-800 dark:text-white">Node.js API</div>
                    <button 
                        onClick={simulateRequest}
                        className="mt-6 px-6 py-2 bg-blue-600 hover:bg-blue-700 text-white rounded-lg font-bold shadow-md active:scale-95 transition-transform"
                    >
                        Make Query
                    </button>
                    
                    {/* SQLite Architecture: DB Inside App */}
                    {arch === 'sqlite' && (
                        <div className="mt-4 p-2 bg-green-50 dark:bg-green-900/20 border border-green-200 dark:border-green-800 rounded-lg flex items-center gap-2 animate-in fade-in zoom-in">
                            <span className="text-green-600">📄</span>
                            <span className="text-xs font-bold text-green-700 dark:text-green-400">Running In-Process (data.db)</span>
                        </div>
                    )}
                </div>

                {/* Database Server / Disk */}
                <div className={`bg-white dark:bg-slate-900 p-6 rounded-2xl border border-slate-200 dark:border-slate-800 z-10 flex flex-col items-center justify-center transition-all duration-500 ${arch === 'sqlite' ? 'opacity-30 blur-sm scale-90' : 'shadow-lg'}`}>
                     <div className="bg-blue-50 dark:bg-blue-900/20 p-4 rounded-full mb-4">
                        <span className="text-3xl">🗄️</span>
                    </div>
                    <div className="font-bold text-gray-800 dark:text-white">Postgres Server</div>
                    <div className="text-xs text-gray-400 mt-2">Requires TCP/IP Connection</div>
                </div>

                {/* Animation Layer */}
                 <div className="absolute inset-0 pointer-events-none flex items-center justify-center">
                    {requests.map(r => (
                        <div 
                            key={r.id}
                            className="absolute flex items-center"
                            style={{ 
                                left: arch === 'postgres' ? '25%' : '25%', // Start at App
                            }}
                        >
                            {/* The Request Bolt */}
                            <div className={`p-2 rounded-full shadow-xl z-50 ${arch === 'postgres' ? 'bg-blue-500 animate-network-trip' : 'bg-green-500 animate-disk-flash'}`}>
                                <span className="text-white text-xs">⚡</span>
                            </div>
                        </div>
                    ))}
                 </div>
                 
                 {/* Metrics */}
                 <div className="absolute top-0 right-0 lg:left-1/2 lg:-translate-x-1/2 -mt-16 bg-black text-green-400 font-mono text-sm p-2 rounded border border-green-900">
                    Latency: {latency.p95}ms
                 </div>

            </div>
            
             <div className="mt-12 text-center text-sm text-gray-500">
                {arch === 'postgres' 
                    ? "Network Roundtrip: 1-10ms (Docker Network / Cloud VPC)"
                    : "Function Call Overhead: 0.05ms (Direct File I/O via C+ Binding)"}
            </div>

        </div>
    );
}
Open on CodeSandboxOpen Sandbox