Link to the official documentation: https://duckdb.org/
- Column-oriented
- Python API available
- Portable – no need to get admin rights on computer / server to install.
- Made for OLAP / analytics use case; unlike SQLite which is transactional oriented
Anthony Skolozdrzyk-Ardouin