3 ms·

SQLite is primarily a transactional, row-oriented (OLTP) database, whereas DuckDB is an analytical, column oriented (OLAP) database.

• monkey26 4y ago
  Can you expand on that a little?
  • maxmcd 4y ago
    More info here and in the linked paper: https://simonwillison.net/2022/Sep/1/sqlite-duckdb-paper/ https://simonwillison.net/2022/Sep/1/sqlite-duckdb-paper/