![]() ![]() PostgreSQL is present as read-to-use installers or packages for several platforms, also the source code extracts if we wish to make it by own. Accent-insensitive and Case-insensitive collations.Support for many sets of international character, e.g.Several extensions that facilitate additional functionality, and PostGIS.Justifiable Storage interface for many tables.Procedural Languages: Python, Perl, PL/PGSQL (and many others).Multi-factor authentication along with the certificates and additional method.Authentication: Certificate, SCRAM-SHA-256, LDAP, SSPI, GSSAPI, and other.Active standbys, PITR (Point-in-time recovery).Replication: Logical, Synchronous, Asynchronous.JIT (Just-In-Time) expression's compilation.Every transaction separation levels specified inside the SQL standard, adding Serialization.Making B-tress indexes, Read query's parallelization.MVCC (Multi-Version concurrency Control).Multicolumn statistics, Index-only scans, Sophisticated query optimizer/planner.Indexing: Partial, Expressions, Multicolumn.Advanced Indexing: Bloom filters, Covering Indexes, BRIN, GIN, KNN Gist, SP-Gist, Gist.Customizations: Custom Types, Composite.Document: Key-value (Hstrore), XML, JSON/JSONB. ![]() Primitives: Boolean, String, Numeric, Integer.Structured: UUID, Range, Array, Date/Time.The following are some essential aspects detected in PostgreSQL, these aspects are included in all the major release. Besides of being open and free source, it is a highly extensible database.įor example, we can define our data types, made custom functions, and write code through programming languages of different types without recompiling our database. It also supports us for managing our data. It comes with several aspects aimed to support administrators for protecting integrity of data, developers for building applications and build an environment, i.e., fault tolerance. It has become an open source type of relational database for various organizations and people. PostgreSQL has strong add-ons like the popular geospatial database extender, i.e., PostGIS. PostgreSQL delivers innovative and performant solutions consistently. PostgreSQL has made a solid reputation for the reliability, architecture, data integrity, extensibility, robust aspect set, and open source community's dedication. PostgreSQL's origins back to date 1986 at the California University at Berkeley as the POSTGRES project. It extends and uses the languages of SQL that consisted of various aspects that safely scale and store sophisticated data workloads. PostgreSQL is an open-source, powerful object-relational type of database system. Next → ← prev Install PostgreSQL MAC PostgreSQL Introduction ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |