DuckDB 2.0 on a MySQL analytical replica: what we measured
DuckDB 2.0 runs our heaviest analytical queries up to 44% faster. Some mid-size joins got slower, so we found why and reported it to the DuckDB…
Tag
dbtrail
InnoDB for the fast. DuckDB for the heavy. Same connection for both.
Use InnoDB and DuckDB at the same time, on the MySQL you already run. Reports ran 10 times faster. Open source, no migration, no DuckDB to…
Introducing the MySQL Analytical Replica (Parquet + DuckDB)
Your reports run on your production MySQL. DBTrail keeps a copy of your tables as Parquet files and lets you query it with DuckDB.
DB Trail Open Source now has a UI
DB Trail now has a web console. You no longer need to remember command flags to find which rows a bad query touched.