Introduction to PostgreSQL – Overview – PostgreSQL Tutorial
An overview of the features and functions of #PostgreSQL, along with a discussion about why you might choose to use it over another #database, PostgreSQL Tutorial.
Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔
📺 Subscribe To Our Channel + Turn on the 🔔 and Get More videos about #OpenSource #Databases, and many other things.
https://percona.tv/subscribe
What is PostgreSQL?
#PostgreSQL is a general-purpose object-relational #database management system.
-add customs functions developed using different programming languages such as c/c++, Java, etc.
-PostgreSQL is designed to be extensible.
Define your own data types, index types, functional languages, etc.
Develop a custom plugin to enhance any part of the system to meet your requirements
PostgreSQL is #OpenSource
Is 100% free and open source software. Licensed under the PostgreSQL License.
Based on #Postgres 4.2, developed at University of California, Berkeley Computer Science Department.
In use at Apple, Fujitsu, Red Hat, Cisco, Juniper Network and many more companies and organizations.
PostgreSQL vs MySQL
Security in PostgreSQL: Use roles and inherited Roles to set and maintain permissions. ative SSL Support for connections to encrypt client/server communication. Se-PostgreSQl provides additional access controls based on security enhanced linux policy.
Security in MySQL: Uses Access Control Lists (acls) for connections, queries and other operations. Support For SSL encrypted connections between client and server.
JSON/noSQL Support in PostgreSQL: Supports Json and other NoSQL features like native XML support and key-value pairs with HSTORE. Supports indexing JSON data for faster access.
JSON/noSQL Support in MySQL: Support JSON, No indexing for JSON Data.
Materialized Veiws in PostgreSQL: Supported.
Materialized Veiws in MySQL: not supported.
Geospatial Data in PostgreSQL: Supported via the #PostGIS extension. Dedicated types and functions exist for geospatial data.
Geospatial Data in MySQL: Supported
Programming languages in PostgreSQL: Supports a wide variety of programing languages including c/c++, Java, JavaScript, .Net, R, Perl, Python, Ruby, Tcl, and others. Supports running user-supplied code in separate processes as background workers.
Programming languages in MySQL: Support for server side, programming in a single language.
Extensibillity in PostgreSQL: Supports addition of new types, functions, index types, etc.
Extensibillity in MySQL: No support for extensibillity.
Why Choose PostgreSQL?
Desire to do development on an open source platform but port production to oracle.
PostgreSQl is more compliant with Oracle Standards
PostgreSQL is fully Acid compliant.
Requirement for custom features.
Need for high concurrency without read locks thanks to the implementation of Multiversion Concurrency control (MVCC).
Desire to “build your own Box”.
Percona Adds Support for PostgreSQL:
-Extends Percona’s enterprise-grade #Database support expertise to PostgreSQL.
-Provides a single enterprise-grade vendor for MySQL, MariaDB, MongoDB, and PostgreSQL.
-Resolve issues faster, reduce costs.
-Focus on your business, not your Database.
-On-premise or in the cloud.
You can find more information about #PostgreSQL #Databases and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻
https://per.co.na/postgresql-support
https://per.co.na/postgresql-info
https://per.co.na/lGkGc9
https://per.co.na/pl2020
https://per.co.na/postgresql
Connect With us on our Social Networks 👇🏻👇🏻👇🏻
Follow Percona on Twitter: https://per.co.na/twitter
Follow Percona on Facebook: https://per.co.na/facebook
Follow Percona on Instagram: https://per.co.na/instagram
Follow Percona on LinkedIn: https://per.co.na/linkedin