PostgreSQL is one of the most popular object-relational database management system (shortened to ORDBMS) and is 100% open-source. It is not purely about relations anymore: PostgreSQL is more and more about NoSQL as well. The following article is a short tutorial to set up PostgreSQL 9.5 on Fedora 24, so it can be used for a development environment. For a production deployment, it is recommended to use a different set-up and harden the service.

The set of PostgreSQL database packages in Fedora’s stable repositories are almost identical to the upstream set of RPMs. There are client tools in the postgresql package. The client library in the postgresql-libs package is often required by various connectors. The most important part of the database, the daemon, is available in the postgresql-server package. Some more server-side extensions, tools, or supporting packages may be listed by running the following command in a terminal.

Full Article on..

http://gtbensmagazine.com

What are the benefits of Postgresql over mysql database?

postgre is not as fast but its as robust and easy to use. It is also open source so it gets updates and patches quicker from individuals and communities all over the world. Postgre runs on Linux, Windows and more plus its not controlled by Oracle unlike MySQL. It will be around for a long time but MySQL can be abandoned or restrict certain support or even updates now that its owned by Oracle.

Postgres is fully feature, more so than MySQL. It has richer data types. MySQL doesn't intend to be so. MySQL is good enough for basic websites. If you wish to build your business bet on Postgres. MySQL has reliability issues and loosing your data is a possibility that sadly plenty of people have experienced. MySQL is great for a read heavy site like a news, blog or web forum. Postgres is a solid database. It supports true ACID. Atomicity, Consistency, Isolation and Durability. So is good for sites like Banks, Auction, where every action truly does what you expect. MySQL will truncate your data if you give it what it doesn't expect, meaning, it silently fails. Postgres will return an error, letting you know you are violating your data. The rumor that Postgres is not fast is a wash, I have a Postgres database with few billion records that get's pounded on every damn second for that last 5 years and it's holding up fine.

Thanks DonSegmond. kindly sign up on http://gtbensmag.com lets exchange topics on each others blog. Your contribution is needed and highly appreciated.

DonSegmond:
Postgres is fully feature, more so than MySQL. It has richer data types. MySQL doesn't intend to be so. MySQL is good enough for basic websites. If you wish to build your business bet on Postgres. MySQL has reliability issues and loosing your data is a possibility that sadly plenty of people have experienced. MySQL is great for a read heavy site like a news, blog or web forum. Postgres is a solid database. It supports true ACID. Atomicity, Consistency, Isolation and Durability. So is good for sites like Banks, Auction, where every action truly does what you expect. MySQL will truncate your data if you give it what it doesn't expect, meaning, it silently fails. Postgres will return an error, letting you know you are violating your data. The rumor that Postgres is not fast is a wash, I have a Postgres database with few billion records that get's pounded on every damn second for that last 5 years and it's holding up fine.

+1 for Postgres. I recently discovered you can't even create an index on a mysql VARCHAR/CHAR column if the length of the column is longer than 200 characters. Full text search in mysql is also not nearly as advanced as in Postgres. Your applications can also natively query data stored in other databases (eg oracle, mysql, mssql etc) through Postgres as if the data was stored in Postgres using Postgres' foreign data wrapper feature.

Mysql/mariadb is no way near Postgres in features and performance.

hassan4:
Thanks DonSegmond. kindly sign up on http://gtbensmag.com lets exchange topics on each others blog. Your contribution is needed and highly appreciated.

I also don't mind exchanging topics, since I get less busy during the weekends nowadays.

You guys seem like postgre Envangelist. I will give it a try

DanielTheGeek:


I also don't mind exchanging topics, since I get less busy during the weekends nowadays.

Deal then.