Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Postgres Just Cracked the Top Fastest Databases for Analytics

mooncake.dev

Post reply on HN
Print view View original

121–126 of 126 posts

Re: Postgres Just Cracked the Top Fastest Databases for Analytics

#121

Post by mslot »

rubenvanwyk wrote: post #12
jot wrote: post #9

How is this different from Crunchy Warehouse which is also built on Postgres and DuckDB? https://www.crunchydata.com/products/warehouse

Think that use pure parquet, not iceberg tables.

We first launched it as "Crunchy Bridge for Analytics" in April last year. At the time, it could mostly query/import/export Parquet/CSV/JSON. Our goal was to build a data warehouse, but getting early feedback was helpful and we did not want to misrepresent the offering.

In November last year we added Iceberg support and managed storage, so it became a full data warehouse experience with writes and transactions and we renamed it to Crunchy Data Warehouse.

Re: Postgres Just Cracked the Top Fastest Databases for Analytics

#122

Post by stoicfungi »

moonikakiss wrote: post #99
stoicfungi wrote: post #35

what are the differences between pg_mooncake and pg_duck?

Both add the DuckDB extension. But the use-case is slightly different: 1. pg_duckdb is great for querying existing columnar files (parquet) in Postgres. 2. Our focus is on helping you write and query your existing Postgres table into a columnar format. We spent most of our time on building the table access method for columnstore tables.

Thanks a lot for the explanation. Keep up the good work :)

Re: Postgres Just Cracked the Top Fastest Databases for Analytics

#124

Post by eska »

kbolino wrote: post #104
kyrra wrote: post #75

Earlier quoted context omitted.

What are th legal issues?

Some extensions, like TimescaleDB, have licenses explicitly forbidding their use in hosted products which compete with the companies backing them. In concrete terms, this means they can't be used in any of the major cloud providers' managed database solutions (e.g AWS RDS). Others, like Citus, are licensed under the AGPL, which is basically an even stronger version of the GPL that requires anyone hosting a service to…

I asked about this in their chat 2 years ago, and the CEO responded directly. His response I believe was that you are allowed to use Timescale on managed servers, but you're not supposed to become a Timescale hoster for others.

Re: Postgres Just Cracked the Top Fastest Databases for Analytics

#126

Post by kbolino »

eska wrote: post #124
kbolino wrote: post #104

Earlier quoted context omitted.

Some extensions, like TimescaleDB, have licenses explicitly forbidding their use in hosted products which compete with the companies backing them. In concrete terms, this means they can't be used in any of the major cloud providers' managed database solutions (e.g AWS RDS). Others, like Citus, are licensed under the AGPL, which is basically an even stronger version of the GPL that requires anyone hosting a service to…

I asked about this in their chat 2 years ago, and the CEO responded directly. His response I believe was that you are allowed to use Timescale on managed servers, but you're not supposed to become a Timescale hoster for others.

That may mean that RDS could provide Timescale as an available extension without promoting it directly. However, that is a sufficiently gray legal area that I doubt Amazon wants to wade into it (instead of just making a competing product).

The only way I think one could safely thread the needle here would be for RDS to allow you to bring your own extensions, as then Amazon is definitely not hosting it for you. However, that would compromise the security model and responsibility division that RDS provides.

Post reply on HN