News for hackers. Stuff that matters.
Re:Features I'd Like in PostgreSQL by threeseed on Saturday January 28, 2023 @04:32PM (#34562162)
It means that when you upgrade PostgreSQL you don't have to worry if the extensions are compatible and have been fully tested not just for functionality but security etc as well.

And most importantly it means you don't have to worry if that extension will move to a freemium model which (a) often has important features out of your price range and (b) is generally unacceptable in enterprise environments.

Re:Features I'd Like in PostgreSQL by ahachete on Saturday January 28, 2023 @07:27PM (#34563532)
Right, those are compulsory steps for every upgrade.

Yet in the particular case of Citus, history (so far) has shown a) that they update the extension regularly and fast, so by the time you want to upgrade to a newer major version you already have Citus updated too; b) they are going exactly in the opposite direction of "freemium", they actually open sourced even the previous proprietary bits; c) as OSS, it can always be forked and if one day closed source, being such an important project, it would be definitely forked.

(I don't have any stakes on Citus)

Re:Features I'd Like in PostgreSQL by Keyframe on Sunday January 29, 2023 @12:23AM (#34565208)
Citus is Microsoft for quite awhile now. Take what you will from that.
Re:Features I'd Like in PostgreSQL by threeseed on Sunday January 29, 2023 @01:11AM (#34565440)
The "you can always fork Citus" argument is not workable.

Scaling databases is an expert skill that is far out of reach for almost everyone.

Far easier just to pick another database that includes HA and horizontal scalability out of the box.

Re:Features I'd Like in PostgreSQL by ahachete on Sunday January 29, 2023 @09:08AM (#34568203)
Sharding databases is not such a dark, magic art. Citus relies on Postgres for many key features; and Citus does the rest. It's already quite "feature complete".

If Citus would become proprietary overnight, my main concerns of maintaining a fork would be around the codebase and the language expertise more than the sharding concepts.

Note that sharding is different from a purely distributed database. The latter is an entirely different class (and more complex system).

Re:Features I'd Like in PostgreSQL by threeseed on Sunday January 29, 2023 @10:42AM (#34569066)
The more likely scenario is that Citus simply disappears entirely and becomes an internal feature of Azure.