Databases & Data Warehouses
In-Process Analytical Database
★ 4.8
Distributed Columnar Streaming Database
★ 3.7
pip install duckdbN/A — Scala-based, no pip installpip install duckdbN/A — Scala-based, no pip installPython data engineers use DuckDB to run fast analytical SQL queries directly on Parquet files in a data lake without a database server. `duckdb.query('SELECT * FROM parquet_scan("s3://bucket/file.parquet")')` returns an Arrow table convertible to pandas — enabling complex aggregations on large files in seconds without loading them fully into memory.
Python data engineers working in observability infrastructure use FiloDB as a long-term storage backend for Prometheus metrics. Python scripts query FiloDB via its HTTP API to pull historical metric data for anomaly detection models or SLA reporting — enabling ML-driven monitoring use cases that require more data history than Prometheus retains locally.
Databases & Data Warehouses
MongoDB vs PostgreSQL
Databases & Data Warehouses
PostgreSQL vs Redis
Databases & Data Warehouses
Apache Cassandra vs PostgreSQL
Databases & Data Warehouses
Neo4j vs PostgreSQL
Databases & Data Warehouses
InfluxDB vs PostgreSQL
Databases & Data Warehouses
Elasticsearch vs PostgreSQL
Individual Tool Pages