Quick note - Using DuckDB as CLI for SQLite and PostgreSQL
2024-03-12
With the introduction of multi-database support in DuckDB 0.10.0, it's possible to use it as a frontend for MySQL, Postgres and SQLite databases.
This comes in addition to the file based DuckDB storage format and native Parquet support.
After using DuckDB for analyzing GTFS data in CSV format, I got used to the nice CLI and decided to give it a try as frontend for my most often used Postgres and SQLite databases.
Continue Reading →