Welcome to WebmasterWorld Guest from 50.19.34.255

Forum Moderators: open

PostrgreSQL Version 10 is a significant upgrade

     
4:37 pm on Oct 9, 2017 (gmt 0)

Senior Member from CA 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 25, 2003
posts:1107
votes: 264


PostgreSQL version 10 was released a few days ago.

Yes, I know most webdevs use MySQL because that is what WordPress likes and their hosts offer, that some have made the sidestep to MariaDB; however a few of us find Postgres the better database for our requirements.
Note: I use PostgreSQL [postgresql.org] as my production DB and, naturally, as my development/staging DB.
Note: Where I differ from almost everyone is that I also use Postgres-XL [postgres-xl.org] to deliver real time bot identification/intervention and visitor personalisation/contextual delivery; also for non-real time analytics.

* New in Postgres 10 [wiki.postgresql.org], 05-October-2017.
* Appendix E. Release Notes [postgresql.org], 05-October-2017.

To date I'm still testing the upgrade in my staging setup. So far only minor hiccups, mostly from not RTFM - the release notes are a critical resource! Now it's a matter of reliability testing before rolling out live.
Note: there is no such thing as enough thanks from the heart to the Postgres documentation maintainers and the wider helpful community. A poster child for open source.
4:53 pm on Oct 9, 2017 (gmt 0)

Senior Member from GB 

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month

joined:Nov 16, 2005
posts:2747
votes: 110


Significant upgrades, and quite a lot of backward compatibility.

I like Postgres too, and while I can understand why people use MySQL when they want to use something that requires it (like Wordpress) I cannot understand why people use MySQL even when using a stack that works better with Postgres (e.g. Django ).