Post

Mehmet Hakan Satman
@jbytecode.bsky.social

DuckDB is an excellent alternative to SQLite. It compressed my 114 MB historical price database down to just 8 MB while significantly speeding up query performance. Furthermore, it offers seamless integration with Julia via the DuckDB.jl package. #JuliaLang

1 repost7 likes

Mehmet Hakan Satman
@jbytecode.bsky.social

DuckDB stores the data by columns, so column-wise queries are faster whereas SQLite stores the data by rows. It also zips the data so the size of databases is shorter. The REPL also has a more modern look and feel. SQLite has better speed-up in insert into type queries.