DuckDB is [[SQLite]], but for columnar data. It's for [[OLAP]] rather than transactional. Both DuckDB & SQLite were designed to have zero dependencies, and exist within a single file. If you want to keep things simple & portable, use [[SQLite]] for operational systems & [[DuckDB]] for analytical ones. **** # More ## Source - https://youtu.be/uHm6FEb2Re4?si=T3aYcpeEIDyM3Iio - https://duckdb.org/why_duckdb#:~:text=Thanks%20to%20having%20no%20dependencies,and%20even%20on%20mobile%20phones.