PostgreSQL is an open source object-relational database system that’s had more than 15 years of active development. Here are 7 reasons you should be using PostgreSQL.
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 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.
If you need more support you can turn to EnterpriseDB, 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, you can enable PostgreSQL with a single click in the 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 for installing PostgreSQL in CentOS 7.
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.
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. You can find the full PostgreSQL security report here.
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.
If you do happen to get stumped while working with PostgreSQL, you’ll find there is lot of information and documentation available. The official documentation is available online here.
There are also dozens of books and information that you can easily find on how to use PostgreSQL, many of which are listed here.
Want to learn even more? Watch this PostgreSQL video.
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!