Home » Hosting Encyclopedia » Hosting Terms » Database » PostgreSQL

PostgreSQL

The PostgreSQL database is based on the object-relational database model unlike MySQL, which is a relational database system. PostgreSQL is somewhere between the relational and the object-oriented database systems. Object-relational databases like Postgres might appear slightly more difficult for management but enable the creation of more complex data.

The PostgreSQL database management system is fully-featured free software available for most operating systems including Linux, Windows, Mac OS, FreeBSD, and Solaris. It is entirely ACID (Atomicity, Consistency, Isolation, Durability)-compliant and that guarantees the reliability of the database. PostgreSQL provides great security with easy backup and Point In Time Recovery options, as well as SSL encrypted communication over the database. The database also enables the usage of various programming languages.

 

PostgreSQL or MySQL?

Both MySQL and PostgreSQL are very powerful free tools with minor differences and which one you will choose largely depends on the tasks you are using your database for and your personal preferences. However, there are some dissimilarities that could be pointed out: MySQL isn’t fully ACID-compliant and this depends on the storage engine you are using with it. Still, there are various storage engines that can be used with MySQL, thus adding to the flexibility of the database. PostgreSQL runs on one storage engine but offers full support for asynchronous command processing that’s not fully available for MySQL. Postgres is also more powerful in terms of triggers, which are supported by both databases. Nevertheless, MySQL triggers execute SQL statements only, while PostgreSQL works with any user-defined functions on each of its procedural programming languages but they are harder to learn. Postgres also supports multiple trigger actions and many triggers of the same type while MySQL doesn’t. Postgres has much wider data type support and partial indexes support. On the other hand, MySQL supports more types for horizontal partitioning than PostgreSQL.

Was this article useful?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate this post.

Newest Articles:

How to Enter the WordPress Admin Panel

If you are reading this tutorial, you are probably on your way to creating your first website. In the previous tutorial, we showed you step-by-step how to install WordPress on your domain using Zacky Installer. Now you probably want to enter the WordPress admin panel...

How to Install WordPress using the Zacky Installer

WordPress is a simple and flexible content management system that allows you to create and manage the content of your website. The first thing to mention is that you don't need any programming skills or technical knowledge to use WordPress. All you have to do is read...

Second Level Domain (SLD)

The Second Level Domain or SLD is an essential part of the hierarchical Domain Name System. It is the second part of the full domain name after the Top Level Domain, on its left side. The Second Level Domain is often the same as the website name, the company or the...

Top-Level Domain (TLD)

The Top Level Domain name (TLD) is the last or right-most fragment of the domain name. The parts of the domain name are separated with dots and form their own hierarchy in the Domain Name System (DNS). There is a Top-Leveл Domain list where you can see all available...

IANA

What is IANA? Although the Internet is not really a centralized system, there are some key infrastructure elements that need to be coordinated. The Internet Assigned Numbers Authority (IANA) is an organization that was founded in 1988 by the government of the U.S.A....

Ready to Create Your Website?