PostgreSQL 15 Performance Improving With Faster Sorting, Many New Features

[phoronix]

Phoronix: PostgreSQL 15 Performanace Improving With Faster Sorting, Many New Features

The PostgreSQL 15 database server will be releasing in a few months and is yet another major release to this open-source relational database system when it comes to performance...

https://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-15-Faster-Sort

[uid313]

I am sure the performance and features are great, but the userspace CLI sucks, everything is scattered under different commands, some with the pg_ prefix, some not. At least in Git all commands are under the git program, same with apt and dotnet.

Also the license, even though it is OSI-approved, it it still a vanity license.

[ferry]

I am sure the performance and features are great, but the userspace CLI sucks, everything is scattered under different commands, some with the pg_ prefix, some not. At least in Git all commands are under the git program, same with apt and dotnet.

Also the license, even though it is OSI-approved, it it still a vanity license.

But Pgadmin is very good

[uid313]

But Pgadmin is very good

If you know how to setup it up on a web server. It would be be nice with a desktop application.

[numacross]

If you know how to setup it up on a web server. It would be be nice with a desktop application.

It is a desktop application when installed via APT, RPM or under Windows and macOS.

[curfew]

I am sure the performance and features are great, but the userspace CLI sucks, everything is scattered under different commands, some with the pg_ prefix, some not. At least in Git all commands are under the git program, same with apt and dotnet.

Also the license, even though it is OSI-approved, it it still a vanity license.

This re-tarded shit surely doesn't need to be copy-pasted into every comment thread regarding PostgreSQL?

[Setif]

Microsoft developer talks about PostgreSQL. Isn't it an alternative to MS SQL Server.

[numacross]

Microsoft developer talk about PostgreSQL. Isn't it an alternative to MS SQL Server.

It is, but that doesn't stop them from selling it alongside MSSQL.

[ferry]

If you know how to setup it up on a web server. It would be be nice with a desktop application.

Yeah, pgAdmin 3 was a nice desktop application that I miss. But pgAdmin 4 is pretty much the same to set up (on Ubuntu). Psychologically, I find it irritating to know that there is an unnecessary web server running in the background. Other then that, it's brilliant and for me makes it the goto sql server. Good client support from LibreOffice Base too.

[ferry]

It is, but that doesn't stop them from selling it alongside MSSQL.

Haha, that's brilliant. I was already wondering why MS was putting resources into a FOSS competitor. Great news, thanks MS!