Description:
Object-relational database system
|
|
Type: Formula
|
Latest Version: 12.22@0
|
Tracked Since: Nov 10, 2025
|
|
Links:
Homepage |
@postgresql |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
database
sql
postgresql
relational
rdbms
|
|
Install:
brew install postgresql@12
|
About:
PostgreSQL 12 is a powerful, open-source object-relational database system known for its reliability and feature robustness. This version introduced significant performance improvements, including improved table partitioning and generated column support. It is an excellent choice for applications requiring complex data workloads and strong transactional integrity.
|
Key Features:
- ACID-compliant transaction processing
- Advanced indexing (B-tree, GiST, SP-GiST, GIN, BRIN)
- Robust foreign key and join support
- Stored procedures and functions (PL/pgSQL)
- JSON support and native data types
|
Use Cases:
- Back-end database for web applications
- Online Transaction Processing (OLTP) systems
- Complex data analysis and reporting
|
Alternatives:
-
postgresql@13
– Newer version with logical replication improvements and performance enhancements.
-
mysql
– Simpler configuration but lacks advanced features like table functions and richer indexing options.
-
sqlite
– Serverless and file-based, better for embedded systems but not for high-concurrency network applications.
|
| Detected |
Version |
Rev |
Change |
Commit |
| Nov 10, 2025 2:15pm |
|
2 |
VERSION_BUMP |
2742cf7c |
| Nov 26, 2024 9:02am |
|
0 |
VERSION_BUMP |
076b02ae |
| Nov 14, 2024 3:55pm |
|
0 |
VERSION_BUMP |
3131d866 |
| Oct 31, 2024 3:51pm |
|
3 |
VERSION_BUMP |
c1e07122 |
| Oct 31, 2024 8:40am |
|
3 |
VERSION_BUMP |
1f2bde49 |
| Oct 22, 2024 3:00am |
|
2 |
VERSION_BUMP |
dd98941b |
| Sep 28, 2024 3:38pm |
|
0 |
VERSION_BUMP |
3f10ef7a |
| Aug 2, 2024 5:42pm |
|
0 |
VERSION_BUMP |
d3075ef5 |
| May 9, 2024 3:49pm |
|
0 |
VERSION_BUMP |
88caae6c |
| Feb 8, 2024 3:27pm |
|
0 |
VERSION_BUMP |
458d84eb |
| Feb 9, 2023 6:06pm |
|
0 |
VERSION_BUMP |
573f1dd0 |
| Feb 9, 2023 6:06pm |
|
0 |
VERSION_BUMP |
e364112a |
| Jan 15, 2023 11:01pm |
|
1 |
VERSION_BUMP |
b25a7e24 |
| Jan 15, 2023 11:00pm |
|
1 |
VERSION_BUMP |
cd24dad2 |
|