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

PolarDB, yet another open source database system based on PostgreSQL

github.com

Post reply on HN
Print view View original

71–80 of 103 posts

Re: PolarDB, yet another open source database system based on PostgreSQL

#71

Post by craigkerstiens »

hashhar wrote: post #53
he0001 wrote: post #21

What more db’s are based on Postgres?

Greenplum Hadapt Netezza PipelineDb Postgres-XL Redshift AgensGraph TimescaleDB Fujitsu Enterprise Postgres PolarDB CrunchyBridge

A quick note on Crunchy Bridge, it is pure Postgres, not "based" on Postgres. We haven't forked or modified code at all. And some of the above (Timescale) are extensions which do not change Postgres, but hook into the extension APIs.

Re: PolarDB, yet another open source database system based on PostgreSQL

#72

Post by craigkerstiens »

wirelesspotat wrote: post #52
joelp wrote: post #40

What are people/companies using currently to make their postgres database distributed these days? Currently running my app + db on Heroku in the EU and would like to scale out since latency is abysmal for users in Australia and Asia.

fly.io[1] supports Postgres clusters with read replicas in different cities[2] It looks like AWS's Aurora Postgres doesn't support cross-region read replicas, but apparently their Aurora "Global Database" offering does[3] - [1] https://fly.io - [2] https://fly.io/docs/reference/postgres/#scaling-horizontally... - [3] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide...

For fully managed (similar to Heroku Postgres) Crunchy Bridge [1] supports replicas across regions including say EU to AU. Which would actually couple really well with Fly.io for the app side.

- [1] https://www.crunchydata.com/products/crunchy-bridge/

Re: PolarDB, yet another open source database system based on PostgreSQL

#73

Post by mb4nck »

pella wrote: post #65
the-dude wrote: post #46

Earlier quoted context omitted.

Are there any stability fixes you have in mind? In my recollection, there is not much instability in PG releases.

IMHO: with the latest fix -> more stable search for "crash": https://www.postgresql.org/docs/release/11.3/ ( 11x ) https://www.postgresql.org/docs/release/11.4/ ( 4x ) https://www.postgresql.org/docs/release/11.5/ ( 1x ) https://www.postgresql.org/docs/release/11.6/ ( 3x ) https://www.postgresql.org/docs/release/11.7/ ( 14x ) https://www.postgresql.org/docs/release/11.8/ ( 5x ) https://www.postgresql.org/docs/release…

OTOH the PolarDB specific changes seem to be contained enough that if you decide to run it in production, you can probably just apply most of the changes from the v11 branch yourself.

But I agree it's not a very good look to code-drop something on a .2 release when there's been 2,5 years of fixes.

Re: PolarDB, yet another open source database system based on PostgreSQL

#74

Post by antoncohen »

JoelJacobson wrote: post #57

No commit history? It would have been interesting to follow the development work to see what changes they've made compared to PostgreSQL.

This is effectively required when open sourcing something that was previously internal. I've done it at a company. There could be company internal things that leak in old revisions of code and commit messages. Even if the latest commit on master is clean, it is really hard to know that every revisions, throughout the whole history is clean.

Re: PolarDB, yet another open source database system based on PostgreSQL

#75

Post by wanghq »

wanghq wrote: post #15

Oh, what's going on here? > OceanBase, the database of Alibaba's fintech company Ant Group, will be open-source soon, possibly as early as June 1, according to Sina Tech. https://cntechpost.com/2021/05/27/ant-groups-in-house-databa... Also the team published many papers about PolarDB. https://scholar.google.com/scholar?hl=en&as_sdt=0%2C48&q=%22...

Sorry I didn't make myself clear. I was surprised because two databases from Alibaba are open sourced or to be open sourced.

Re: PolarDB, yet another open source database system based on PostgreSQL

#76

Post by mst »

ziftface wrote: post #26
jeltz wrote: post #23

Earlier quoted context omitted.

Greenplum, Postgres-XL and PipelineDB.

I'm still really upset that confluence bought and ruined pipeline db. It solved my problem perfectly and I haven't seen one yet that fits what I needed as well.

Looks to me like an acquihire of a team that would otherwise (probably) have ended up winding up the company, sadly.

Re: PolarDB, yet another open source database system based on PostgreSQL

#79

Post by rad_gruchalski »

speedgoose wrote: post #5
sail0rm00n wrote: post #3

Earlier quoted context omitted.

There’s no need for consolidation when Postgres already exists.

Sometimes I dream about a highly available multi primary postgresql.

I would recommend having a look at Yugabyte.
Post reply on HN