5 most interesting features of PostgreSQL
PostgreSQL is one of the most powerful, versatile, and reliable object-relational database system. Truly open source nature and enterprise grade features increase its demand in the market. Availability to handling exceptionally large workloads, make it first choice for many largest companies around the world. I think you knew all of that already. In this geek story we will point out 5 most interesting features of PostgreSQL.
So, let's start -
1. Create Your Own Data Types
Many database systems are more or less stuck with the data types which is pre-defined at the time of database system creation. But, PostgreSQL comes with Generalized Search Tree (GiST) indexing feature which enable users to create custom data types by allowing them to decide what to store and how to store it. This feature enabled some substantial projects, such as the OpenFTS full-text search engine and PostGIS. PostGIS provides data types that are used by geographic information systems.
The biggest weakness of relational databases is that they are not efficient to manage objects in JSON format. However, PostgreSQL comes with an excellent feature, which can index elements and make advanced searches in the JSON format. JSONB fulfilled the initial hype of PostgreSQL by making it as a truly complete document database. JSONB support in PostgreSQL only continues to become more powerful with better libraries, and its functions improving with each release.
3. Query XML Data
These days, organizations are working on different kinds of XML data. With the awesomeness of PostgreSQL, you can directly query and extract XML data, which is stored in the database. It's also possible to store an XML file, which is created in another application and query just one element from the file rather than pulling the entire file.
4. Streaming Replication
PostgreSQL offers different kinds of services that are useful to scale database. The compelling feature like streaming replication constantly sends the status to the backup servers, so that they're ready at a moment's notice. These applied changes to maintain updated copies that are stored and are in charge of the Hot Standby functionality.
5. Authentication Systems
PostgreSQL assumes that anyone who can connect to the server is authorized to access the database. It may not support every type of authentication, but the latest version support up to 12 different kinds of authentication systems. From UNIX environment to Windows with Active Directory - PostgreSQL come prepared. In addition to LDAP and Kerberos, it also supports GSSAPI, password-based authentication, RADIUS, or even "trust-based" authentication for situations when anyone that can connect to the server is assumed to be allowed to connect.