PostgreSQL 14

#1

Post by jkatz05 » Thu, Sep 30, 2021, 12:50 PM UTC

PostgreSQL 14
postgresql.org

Re: PostgreSQL 14

#2

Post by mattashii » Thu, Sep 30, 2021, 1:05 PM UTC

Once again, thanks to all the contributors that provided these awesome new features, translations and documentation.

It's amazing what improvements we can get through public collaboration.

Re: PostgreSQL 14

#3

Post by 83457 » Thu, Sep 30, 2021, 1:15 PM UTC

Can someone who uses Babelfish for PostgreSQL compatibility with SQL Server commands please describe their experience, success, hurdles, etc. We would move to PostgreSQL if made easier by such a tool. Thanks!

Re: PostgreSQL 14

#4

Post by maxpert » Thu, Sep 30, 2021, 1:16 PM UTC

I converted from MySQL (before whole MariaDB and fork), and I've been happier with every new version. My biggest moment of joy was JSONB and it keeps getting better. Can we please make the connections lighter so that I don't have to use stuff like pgbouncer in the middle? I would love to see that in future versions.

Re: PostgreSQL 14

#5

Post by postgresapp » Thu, Sep 30, 2021, 1:18 PM UTC

If you want to test the new features on a Mac, we've just uploaded a new release of Postgres.app: https://postgresapp.com/downloads.html

Re: PostgreSQL 14

#6

Post by mattashii » Thu, Sep 30, 2021, 1:21 PM UTC

83457 wrote: post #3

Can someone who uses Babelfish for PostgreSQL compatibility with SQL Server commands please describe their experience, success, hurdles, etc. We would move to PostgreSQL if made easier by such a tool. Thanks!

I haven't been able to play with it yet.

This was partly due to my lack of SQL Server projects, but mostly due to the lack of availability of the supposedly Apache-licenced sources and/or binaries (and not wanting to configure AWS for 'just testing').

Re: PostgreSQL 14

#7

Post by rolobio » Thu, Sep 30, 2021, 1:21 PM UTC

Love the JSONB subscripts! It will be so much easier to remember! I may not even have to reference the docs!

Re: PostgreSQL 14

#8

Post by candiddevmike » Thu, Sep 30, 2021, 1:26 PM UTC

How does everyone do postgresql upgrades with the least amount of downtime?

Re: PostgreSQL 14

#9

Post by paulryanrogers » Thu, Sep 30, 2021, 1:27 PM UTC

maxpert wrote: post #4

I converted from MySQL (before whole MariaDB and fork), and I've been happier with every new version. My biggest moment of joy was JSONB and it keeps getting better. Can we please make the connections lighter so that I don't have to use stuff like pgbouncer in the middle? I would love to see that in future versions.

FWIW Mysql 8 has gotten a lot better in standards compliance and ironing out legacy quirks, with some config tweaks. While my heart still belongs to PostgreSQL things like no query hints, dead tuple bloat (maybe zheap will help?), less robust replication (though getting better!), and costly connections dampens my enthusiasm.

Re: PostgreSQL 14

#10

Post by jonplackett » Thu, Sep 30, 2021, 1:28 PM UTC

If you’d like to try out PostgreSQL in a nice friendly hosted fashion then I highly recommend supabase.io

I came from MySQL and so I’m still just excited about the basic stuff like authentication and policies, but I really like how they’ve also integrated storage with the same permissions and auth too.

It’s also open source so if you can to just host it yourself you stil can.

And did I mention they’ll do your auth for you?