24 ms·
Our database is heroku postgresql database. What's the best way to get this working with DuckDB? I see there's a postgresql connector but I'm not totally follow
by wasd 4y ago
Our database is heroku postgresql database. What's the best way to get this working with DuckDB? I see there's a postgresql connector but I'm not totally following how to deploy it. Would I just spin up a dyno with the docker image / custom build pack and connect it to the DB?
- chrisjc 4y agoDoesn't postgres have a columnar option? If so, you could prob get better performance for your analytical interactions if you switched some tables to columnar. Otherwise check out postgres scanner. https://github.com/duckdblabs/postgres_scanner https://github.com/duckdblabs/postgres_scanner They have a blog entry about it too: https://motherduck.com/blog/duckdb-ecosystem-newsletter-two/ https://motherduck.com/blog/duckdb-ecosystem-newsletter-two/