- 29 Şub 2020
- 538
- 575
PostgreSQL is an open source and completely free object-relational database system with powerful features and benefits. Taking advantage of the security, storability and scalability features of the SQL language, PostgreSQL is also used as a database manager in many areas. The story of the birth of PostgreSQL goes back to 1986. Born as part of the POSTGRES project at the University of California at Berkley, PostgreSQL's core platform has been in development for nearly 30 years. The project, which was previously sponsored by DARPA (Defense Advanced Research Projects Agency), was later sponsored by various organizations such as ARO (Army Research Office), NSF (National Science Foundation) and ESL.
After several major major releases, official support for PostgreSQL ended in 1993, when Version 4.2 was released. After 1994, an open source original version compiled from POSTGRES code was published as Postgres95. The most important change in terms of the database occurred in the 1996 version of PostQUEL, which switched to SQL. After getting rid of PostQUEL, it was thought that the name should be changed, and this database system was revised with its current name "PostgreSQL". Today, PostgreSQL is one of the most accepted database management systems in the industry, with its successful data architecture, accuracy, robust feature set, flexibility and open source advantage. PostgreSQL, especially UNIX and UNIX derivative systems; It is supported by many major operating systems such as Linux, MacOS, and Windows.
PostgreSQL, which continues to be published as open source, has been developed independently since 1996 and only with the efforts of volunteers. PostgreSQL, which has some sources of income such as fundraising, is not developed by any institution, organization or company. This makes PostgreSQL one of the most important products of true free software philosophy.
What does PostgreSQL do?
PostgreSQL helps developers and project managers manage and store the data they use while developing software, big or small, with no margin for error. Because it is free and open source, PostgreSQL is completely adaptable, unlike many database systems. For example, if you want to define your own data types, you can create custom functions and use the database without compiling it again.
Since PostgreSQL is in SQL standards, it aims to offer a stable architecture and high performance. Although it supports many prominent features of SQL, there are slight differences in some syntax functions. With PostgreSQL 10 release released in 2017, PostgreSQL offers 160 of SQL's 179 key features. According to the 2018 May ranking of DB-Engines, which ranks the most used database systems all over the world; After Oracle, MySQL and Microsoft SQL Server, PostgreSQL is one of the most preferred database systems in the world.
PostgreSQL Features
You can use PostgreSQL in many areas where you need database architecture. PostgreSQL for being supported by many major operating systems: Windows, macOS, Solaris, SuSE and OpenSuSE, Ubuntu Linux and variants, Debian GNU/Linux and variants, Red Hat Linux family (CentOS/Fedora/Scientific/Oracle and variants), other You can use it on Linux distributions, OpenBSD and FreeBSD. You can also use it with PostgreSQL supported by many programming languages: C (libpq), Embedded C (ecpg), Python (PyGreSQL), Java (jdbc) and TCL (libpgtcl).
The feature that makes PostgreSQL the most powerful against its competitors is that it has multi-version compatibility features such as transaction, subselect, trigger, view, foreign key referential integrity and sophisticated locking (user-defined types), rules, inheritance and lock to reduce conflicts. In terms of performance, PostgreSQL achieves successful metrics when compared to other commercial or open source databases. While it is fast in some respects against some database systems, it is slow in some respects.
Compared to PostgreSQL, MySQL and databases in the same class, INSERT/UPDATE operations are slower because they work on a transaction basis. However, most of the features we have mentioned above are not available in MySQL and its class databases. Although in some respects it lags behind PostgreSQL, MySQL and its class databases, it has significant advantages in terms of features, reliability and flexibility.
PostgreSQL also has many successful aspects in terms of security. In this context, PostgreSQL focuses on the reliability of the database rather than the speed. Before stable working versions are released, at least 1 month beta version tests are carried out and error-free codes are served to PostgreSQL users as much as possible.
Aside from all the highlights of PostgreSQL, this service is offered completely free of charge by open source developers. PostgreSQL, which serves free of charge for every purpose, whether commercial or not, does not impose any restrictions on its users, except for BSD license limitations. Because it is the product of an all-volunteer world, finding answers to potential problems you may have with PostgreSQL makes things as easy as commercial database systems. With developer groups, help boards, and a mailing list, anyone who needs help with PostgreSQL can find what they're looking for with minimal effort.
Maximum size for a row, table, and database in PostgreSQL
What is the maximum size for the database?
Unlimited (32 TB database available)
What is the maximum size for a table?
32TB
What is the maximum size for a row?
1.6TB
What is the maximum size for an area?
1GB
What is the maximum number of rows in the table?
Unlimited
What is the maximum number of columns in a table?
250-1600 depending on column types
What is the maximum number of indexes a table can have?
Unlimited
PostgreSQL Advantages
Open source: Among the open source database management systems, only PostgreSQL offers enterprise-class open source support. In addition, since it is completely open source, users can solve their problems and report bugs with the help of large communities.
Community-based: PostgreSQL is not affiliated with any company and is open to all developers. Anyone who needs it can customize PostgreSQL to meet their needs and use it. The fact that many users around the world use PostgreSQL also provides convenience for the modules and other tools you need. And completely free of charge…
Functions: It can be used in almost all server environments thanks to the SQL functions called Store Procedure. As with PL/SQL and Oracle, it can be used with many languages thanks to its support for PL/pgSQL, PL/Python, PL/Perl, C/C++, and PL/R.
ACID and Transaction support: PostgreSQL supports ACID (Atomicity, Consistency, Isolation, Durability).
Different indexing techniques: PostgreSQL not only includes B+ train index but also GIN (Generalized Inverted Index) and GiST (Generalized Search Tree) etc. It also offers indexing techniques.
Flexible full-text search feature: The full-text search feature can be used when searching for strings that execute vector operation and string search.
Replication variants: Supports various replication methods such as PostgreSQL, Streaming Replication, Slony-I, and cascading.
Diversified extension functions: Supports different types of techniques for geodata storage, such as PostgreSQL, PostGIS, Key Value Store, and DBLink.
Have a nice day TurkHackTeam family
See you on new topics
After several major major releases, official support for PostgreSQL ended in 1993, when Version 4.2 was released. After 1994, an open source original version compiled from POSTGRES code was published as Postgres95. The most important change in terms of the database occurred in the 1996 version of PostQUEL, which switched to SQL. After getting rid of PostQUEL, it was thought that the name should be changed, and this database system was revised with its current name "PostgreSQL". Today, PostgreSQL is one of the most accepted database management systems in the industry, with its successful data architecture, accuracy, robust feature set, flexibility and open source advantage. PostgreSQL, especially UNIX and UNIX derivative systems; It is supported by many major operating systems such as Linux, MacOS, and Windows.
PostgreSQL, which continues to be published as open source, has been developed independently since 1996 and only with the efforts of volunteers. PostgreSQL, which has some sources of income such as fundraising, is not developed by any institution, organization or company. This makes PostgreSQL one of the most important products of true free software philosophy.
What does PostgreSQL do?
PostgreSQL helps developers and project managers manage and store the data they use while developing software, big or small, with no margin for error. Because it is free and open source, PostgreSQL is completely adaptable, unlike many database systems. For example, if you want to define your own data types, you can create custom functions and use the database without compiling it again.
Since PostgreSQL is in SQL standards, it aims to offer a stable architecture and high performance. Although it supports many prominent features of SQL, there are slight differences in some syntax functions. With PostgreSQL 10 release released in 2017, PostgreSQL offers 160 of SQL's 179 key features. According to the 2018 May ranking of DB-Engines, which ranks the most used database systems all over the world; After Oracle, MySQL and Microsoft SQL Server, PostgreSQL is one of the most preferred database systems in the world.
PostgreSQL Features
You can use PostgreSQL in many areas where you need database architecture. PostgreSQL for being supported by many major operating systems: Windows, macOS, Solaris, SuSE and OpenSuSE, Ubuntu Linux and variants, Debian GNU/Linux and variants, Red Hat Linux family (CentOS/Fedora/Scientific/Oracle and variants), other You can use it on Linux distributions, OpenBSD and FreeBSD. You can also use it with PostgreSQL supported by many programming languages: C (libpq), Embedded C (ecpg), Python (PyGreSQL), Java (jdbc) and TCL (libpgtcl).
The feature that makes PostgreSQL the most powerful against its competitors is that it has multi-version compatibility features such as transaction, subselect, trigger, view, foreign key referential integrity and sophisticated locking (user-defined types), rules, inheritance and lock to reduce conflicts. In terms of performance, PostgreSQL achieves successful metrics when compared to other commercial or open source databases. While it is fast in some respects against some database systems, it is slow in some respects.
Compared to PostgreSQL, MySQL and databases in the same class, INSERT/UPDATE operations are slower because they work on a transaction basis. However, most of the features we have mentioned above are not available in MySQL and its class databases. Although in some respects it lags behind PostgreSQL, MySQL and its class databases, it has significant advantages in terms of features, reliability and flexibility.
PostgreSQL also has many successful aspects in terms of security. In this context, PostgreSQL focuses on the reliability of the database rather than the speed. Before stable working versions are released, at least 1 month beta version tests are carried out and error-free codes are served to PostgreSQL users as much as possible.
Aside from all the highlights of PostgreSQL, this service is offered completely free of charge by open source developers. PostgreSQL, which serves free of charge for every purpose, whether commercial or not, does not impose any restrictions on its users, except for BSD license limitations. Because it is the product of an all-volunteer world, finding answers to potential problems you may have with PostgreSQL makes things as easy as commercial database systems. With developer groups, help boards, and a mailing list, anyone who needs help with PostgreSQL can find what they're looking for with minimal effort.
Maximum size for a row, table, and database in PostgreSQL
What is the maximum size for the database?
Unlimited (32 TB database available)
What is the maximum size for a table?
32TB
What is the maximum size for a row?
1.6TB
What is the maximum size for an area?
1GB
What is the maximum number of rows in the table?
Unlimited
What is the maximum number of columns in a table?
250-1600 depending on column types
What is the maximum number of indexes a table can have?
Unlimited
PostgreSQL Advantages
Open source: Among the open source database management systems, only PostgreSQL offers enterprise-class open source support. In addition, since it is completely open source, users can solve their problems and report bugs with the help of large communities.
Community-based: PostgreSQL is not affiliated with any company and is open to all developers. Anyone who needs it can customize PostgreSQL to meet their needs and use it. The fact that many users around the world use PostgreSQL also provides convenience for the modules and other tools you need. And completely free of charge…
Functions: It can be used in almost all server environments thanks to the SQL functions called Store Procedure. As with PL/SQL and Oracle, it can be used with many languages thanks to its support for PL/pgSQL, PL/Python, PL/Perl, C/C++, and PL/R.
ACID and Transaction support: PostgreSQL supports ACID (Atomicity, Consistency, Isolation, Durability).
Different indexing techniques: PostgreSQL not only includes B+ train index but also GIN (Generalized Inverted Index) and GiST (Generalized Search Tree) etc. It also offers indexing techniques.
Flexible full-text search feature: The full-text search feature can be used when searching for strings that execute vector operation and string search.
Replication variants: Supports various replication methods such as PostgreSQL, Streaming Replication, Slony-I, and cascading.
Diversified extension functions: Supports different types of techniques for geodata storage, such as PostgreSQL, PostGIS, Key Value Store, and DBLink.
Have a nice day TurkHackTeam family
See you on new topics
