Request extension support
Hello, I would like to know if it's possible to get pg_duckdb extension. Thanks a lot !!
17 Replies
probable-pink•9mo ago
we have pg_mooncake, have you tried that?
take a look here: https://www.mooncake.dev/blog/pgmooncake-neon
pg_mooncake + Neon: serverless analytics in Postgres
How we accidentally built the best serverless database for analytics
probable-pink•9mo ago
and we have some new guides coming
genetic-orangeOP•8mo ago
Yes, I'm working with pg_mooncake. Thank you !!
probable-pink•8mo ago
We're looking into adding pg_duckdb as well. I'll try to keep you posted.
genetic-orangeOP•8mo ago
is there a plan to add it in the near future ?
probable-pink•8mo ago
We are trying, next two weeks should find out
genetic-orangeOP•8mo ago
is this what ur team working ? https://github.com/neondatabase/neon/pull/10350
GitHub
feat(compute): Add pg_duckdb extension v0.2.0 by ololobus · Pull Re...
We want to host pg_duckdb on Neon.
Use cases
faster OLAP queries
access to datelake files (e.g. parquet) on S3 buckets from Neon PostgreSQL
Because neon does not provide superuser role to neon cu...
probable-pink•8mo ago
Yes
genetic-orangeOP•8mo ago
Great, I'm gonna keep updating from it. Thanks
Hi @bryan , any update for pg_duckdb ?
probable-pink•8mo ago
not yet. the work stalled out as the team got pulled away to other things. not sure if they'll pick it back up next week.
genetic-orangeOP•8mo ago
Got it. Thanks mate !
genetic-orangeOP•7mo ago
Hi @bryan , I just want to check that will pg_duckdb be added to the next version ? Because I see your repo added it, https://github.com/neondatabase/neon/blob/df264380b91a1d4f065b09a19bf4773a78536405/compute/compute-node.Dockerfile#L1477
GitHub
neon/compute/compute-node.Dockerfile at df264380b91a1d4f065b09a19bf...
Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero. - neondatabase/neon
probable-pink•7mo ago
We shipped it internall but found it conflicted with mooncake (they ship different versions of the library) so we had to hold off on making it more broadly available until we have that fixed
genetic-orangeOP•7mo ago
Thanks for your update @bryan !!
hi @bryan , how is the pg_duckdb going ?
probable-pink•7mo ago
We've put it on hold for now while doing other things. I don't have a good date for release yet. This was supposed to be fairly simple but turned into a much more complicated ship.
genetic-orangeOP•7mo ago
I see. Thanks for your update !!
extended-salmon•2mo ago
Any further updates to whether
pg_duckdb will be added in the future? If the issue is pg_mooncake is it possible to make them mutually exclusive, i.e. one or the other, but not both?