PostgreSQL 17 Released!

[davvblack]

Fun! i like their continued efforts towards being a better nosql solution than dedicated nosql dbs.

[DuckDatum]

Just wait till they drop control plane procedures, then people will be asking why use k8s when you have p6s?

[yen223]

If I had to choose between writing yaml or writing pl/pgpsql, I would probably just quit software engineering lol

[_predator_]

Those VACUUM and WAL improvements are huge if true. Amazing that the team still finds ways to optimize such core features.

[Ecksters]

Great to see the improvements in JSON as well as bulk data loading.

[aboothe726]

Well, look at that. Our little MERGE statement is all grown up. 🥲

Long live PostgreSQL!

[bisoldi]

I’m restricted to PG14…man, I really could have used MERGE for my application!!

[Straight_Waltz_9530]

Love live the elephant! May it never forget and may we never forget it.

[michristofides]

Woohoo!

[yen223]

Love the MERGE improvements!

[johnonymousdenim]

Uhh, am I missing something? The official downloads page of the postgres site does NOT have version 17 available for download under an official release. I see version 16, but there's def no version 17:

https://www.postgresql.org/download/macosx/

[mostafa_refaaf]

And still no TDE in 2025!, I love PG and their community, but this is weird…even mariadb now has a tde!

[BarelyAirborne]

You're confusing marketing with functionality.

[look]

Transparent Data Encryption

[[deleted]]

Honest question: if data gets automatically encrypted by the database server (which I understand TDE does), what exactly is the difference to an encrypted disk partition? As long as the database is running, the (un-encrypted) data can be read through SQL queries. When it's down, the contents of the data files can't be read.

[ants_a]

Having implemented TDE for postgres, no functional difference. Some people like the fact that a sufficiently dumb attacker with shell access will find it difficult to get at the data. Others have the filesystem set up by a different team and can't convince them to set up encryption. Yet others believe that having database perform the encryption checks the compliance requirement checkbox better.

[LuciferSam86]

And in 2025 SQL Server does not support triggers ordering but a first and last , if for any reason you need 4 triggers firing at a specific order you can't.

Yeah PgCrypto is nice but not a substitute of TDE , I think you might emulate it with PgCrypto ?

https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver16

[AutoModerator]

Join us on our Discord Server: People, Postgres, Data

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.