7 Reasons You Should Be Using PostgreSQL
Published: 2017-12-05 20:42:08

---
title: 7 Reasons You Should Be Using PostgreSQL
published: true
description: 
tags: 
---

[PostgreSQL](http://www.postgresql.org) is an open source object-relational database system that has had more than 15 years of active development. Here are 7 reasons you should be using PostgreSQL.


# Free
PostgreSQL is completely free to use. It has a license similar to BSD and MIT which means you can use it with no restrictions whatsoever, unlike other open-source databases such as MySQL.

# Easy to setup
Want to test PostgreSQL on macOS? You can use [Postgres.app](http://postgresapp.com/) to get a working PostgreSQL database just by running a single app with no installation required at all.

Even if you need to install PostgreSQL, easy installers are also available with pre-built binaries for [Windows, macOS and Linux](http://www.postgresql.org/download/).

If you need more support you can turn to [EnterpriseDB](http://www.enterprisedb.com/), which offers PostgreSQL with support.

Often you don’t even have to bother with installing PostgreSQL because many server hosts automatically provide it as an option that you can easily turn on or configure. For example, with [Xojo Cloud](http://www.xojo.com/cloud), you can enable PostgreSQL with a single click in its [Control Panel](http://developer.xojo.com/xojo-cloud-control-panel).

With other hosting companies you may have to install PostgreSQL yourself, but steps are often provided. For example, Digital Ocean provides these [steps](https://www.digitalocean.com/community/tutorials/how-to-install-and-use-postgresql-on-centos-7) for installing PostgreSQL in CentOS 7.

# Powerful
PostgreSQL has all the professional-grade features you expect in a server database. You can have multiple users, multiple databases, stored procedures, robust types for your tables, views, full SQL, backups and more.

# Secure
PostgreSQL has SSL for secure connections. It is updated regularly and is used by many, many organizations ensuring that it is kept up-to-date with security updates as necessary. For more information about this, refer to the full [PostgreSQL security report](http://www.postgresql.org/support/security/).

# Flexible
You can use PostgreSQL with any programming language. Because PostgreSQL is so ubiquitous, nearly any programming language easily connects to it. In Xojo, your code would look like this:

    Dim pg As New PostgreSQLDatabase
    pg.Host = “sheep”
    pg.DatabaseName = “Mary”
    pg.Port = 5432
    pg.UserName = “lamb”
    pg.Password = “foo”
    If pg.Connect Then
      // Connected
    End If

In PHP, your code looks like this:

    $dbconn3 = pg_connect("host=sheep port=5432 dbname=mary user=lamb password=foo");

# Lots of Tools
Working with PostgreSQL is much easier when you use a GUI tool. There are many, many tools available such a pgAdmin, Navicat and SQLPro. For a complete list, refer to the [PostgreSQL tool wiki page](https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools).

# Documentation
If you do happen to get stumped while working with PostgreSQL, you’ll find there is lot of information and documentation available. As always, the [official documentation](http://www.postgresql.org/docs/) a great place to start.

There are also dozens of books and information that you can easily find on how to use PostgreSQL, many of which are listed [on the official doc page](http://www.postgresql.org/docs/).

Want to learn even more? Watch this PostgreSQL video:

{%youtube 3zNeePbHn48 %}

As the PostgreSQL site says, it is “the world’s most advanced open source database”. Once you give it a try, you will most definitely agree!

This post originally appeared on the [Xojo Blog](https://blog.xojo.com/2017/06/19/7-reasons-you-should-be-using-postgresql/)