9 ms·
Which one is better for querying CSV from both command line and programmatically? 1. SQLite 2. DucksDB 3. clickhouse-local
by magundu 3y ago
Which one is better for querying CSV from both command line and programmatically?
1. SQLite
2. DucksDB
3. clickhouse-local
- pradeepchhetri 3y agoDefinitely clickhouse ecosystem. - For querying csv data from command line, I use clickhouse-local. - For querying csv data programmatically using a library, I use chdb (embedded version of clickhouse) - For querying large amount of csv data programmatically, I offload it to clickhouse cluster which can do processing in distributed fashion. If you are looking from query performance perspective, this blog is useful: https://www.vantage.sh/blog/clickhouse-local-vs-duckdb https://www.vantage.sh/blog/clickhouse-local-vs-duckdb