Skip to content
TheChatArchiveThe Chat Archive
Claudeclaude-sonnet-4-20250514· AnthropicHugging Face LMArena Human Preference 140K

SQLite vs. DuckDB - key features - performance in Node.js - example code for simple CRUD…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Geminigemini-2.5-flash’s answer.
  1. User

    SQLite vs. DuckDB

    • key features
    • performance in Node.js
    • example code for simple CRUD in Node.js
  2. Claude Assistant

    Key Features

    SQLite is a lightweight, file-based relational database that's been around since 2000. It's serverless, self-contained, and requires zero configuration. SQLite excels at traditional OLTP workloads, supports full ACID transactions, and has excellent stability with backward compatibility. It's widely adopted across platforms and has mature tooling.

    DuckDB is a newer analytical database (launched in 2019) designed for OLAP workloads. It's optimized for analytical queries with columnar storage, vectorized execution, and parallel processing. DuckDB can directly query Parquet files, CSV files, and other formats without importing data first. It supports complex analytical SQL features and integrates well with data science workflows.

    Performance in Node.js

    SQLite performs well for traditional database operations like inserts, updates, and simple queries. It's single-threaded by design, which can be a limitation for concurrent writes but ensures data integrity. For typical web application workloads with moderate data sizes, SQLite is fast and reliable.

    DuckDB shines with analytical workloads, aggregations, and complex queries on larger datasets. It can be significantly faster than SQLite for analytical operations due to its columnar storage and vectorized execution. However, for simple CRUD operations, SQLite might have less overhead.

    Example CRUD Code

    Here's how to implement basic CRUD operations with both databases:

    SQLite with better-sqlite3:

    const Database = require('better-sqlite3');
    const db = new Database('example.db');
    
    // Create table
    db.exec(`
      CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        name TEXT NOT NULL,
        email TEXT UNIQUE
      )
    `);
    
    // Create
    const insertUser = db.prepare('INSERT INTO users (name, email) VALUES (?, ?)');
    const newUser = insertUser.run('John Doe', 'john@example.com');
    console.log('Created user with ID:', newUser.lastInsertRowid);
    
    // Read
    const getUser = db.prepare('SELECT * FROM users WHERE id = ?');
    const user = getUser.get(newUser.lastInsertRowid);
    console.log('User:', user);
    
    const getAllUsers = db.prepare('SELECT * FROM users');
    const users = getAllUsers.all();
    console.log('All users:', users);
    
    // Update
    const updateUser = db.prepare('UPDATE users SET name = ? WHERE id = ?');
    updateUser.run('Jane Doe', newUser.lastInsertRowid);
    
    // Delete
    const deleteUser = db.prepare('DELETE FROM users WHERE id = ?');
    deleteUser.run(newUser.lastInsertRowid);
    
    db.close();
    

    DuckDB:

    const duckdb = require('duckdb');
    const db = new duckdb.Database(':memory:');
    
    // Create table
    db.run(`
      CREATE TABLE IF NOT EXISTS users (
        id INTEGER PRIMARY KEY,
        name VARCHAR NOT NULL,
        email VARCHAR UNIQUE
      )
    `);
    
    // Create
    db.run('INSERT INTO users (name, email) VALUES (?, ?)', 
      ['John Doe', 'john@example.com'], 
      function(err) {
        if (err) console.error(err);
        console.log('User created');
      }
    );
    
    // Read
    db.all('SELECT * FROM users WHERE name = ?', ['John Doe'], (err, rows) => {
      if (err) console.error(err);
      console.log('Users:', rows);
    });
    
    // Update
    db.run('UPDATE users SET name = ? WHERE email = ?', 
      ['Jane Doe', 'john@example.com'],
      function(err) {
        if (err) console.error(err);
        console.log('User updated');
      }
    );
    
    // Delete
    db.run('DELETE FROM users WHERE email = ?', ['john@example.com'], (err) => {
      if (err) console.error(err);
      console.log('User deleted');
    });
    
    db.close();
    

    Choose SQLite for traditional web applications, mobile apps, or when you need maximum stability and compatibility. Choose DuckDB when you're doing data analysis, working with large datasets, or need advanced analytical SQL features.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.