alt Hacker NewsDuckDB's come up a lot since I started my little journey to be honest.
Everything I've read says you're absolutely right about the performance boost lol. It very well may be the next piece I check out, thank you.
DuckDB's come up a lot since I started my little journey to be honest.
Everything I've read says you're absolutely right about the performance boost lol. It very well may be the next piece I check out, thank you.
DuckDB is amazing.
I swapped out some data analytics processing that was originally implemented with Python & Postgres to DuckDB and have been immensely pleased with the outcome. Stuff that would take 6+ hours to do with Python/Postgres now takes me around half an hour to complete.
It's a great addition to an existing Postgres database as it has very tight integration with it's native Postgres extension, which allows you to do things like select data from your Postgres database, process it locally with DuckDB, then insert back into your Postgres database.
I'd highly recommend giving it a try.