2 ms·
How's DuckDB better than using SQLite on an in-memory DB?
by Daishiman 2y ago
How's DuckDB better than using SQLite on an in-memory DB?
- pantsforbirds 2y agoIt's designed for analytics work. Some examples: * You could run a bunch of analytics queries directly on a jsonlines, csv, or parquet file (or even glob of files). * You can output directly to a pandas or polars dataframe * You can use numeric python functions inside of queries * You can also attach to S3 buckets, postgres databases, or sqlite databases and query them directly.