Description:
Object-relational database system
|
|
Type: Formula
|
Tracked Since: Nov 13, 2024
|
|
Links:
Homepage |
@postgresql |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
database
sql
rdbms
open-source
data-persistence
|
|
Install:
brew install postgresql@11
|
About:
PostgreSQL is a powerful, open-source object-relational database system known for its reliability, feature robustness, and standards compliance. It provides advanced capabilities like complex queries, foreign keys, triggers, updatable views, and transactional integrity, making it suitable for demanding enterprise applications.
|
Key Features:
- ACID compliance for data integrity
- Advanced SQL compliance and extensibility
- Support for JSON and other NoSQL-style data types
- Sophisticated query planner and optimizer
- Robust replication and high availability options
|
Use Cases:
- Serving as the primary data store for web and mobile applications
- Powering complex, data-driven enterprise systems and data warehouses
|
Alternatives:
-
MySQL
– More common for web applications, but PostgreSQL offers stronger standards compliance and advanced features.
-
SQLite
– Embedded database library, not a client-server system like PostgreSQL.
|
| Detected |
Version |
Rev |
Change |
Commit |
| Nov 13, 2024 9:11am |
|
3 |
VERSION_BUMP |
222c4b74 |
| Nov 3, 2024 9:11am |
|
3 |
VERSION_BUMP |
9873c07b |
| Oct 31, 2024 3:51pm |
|
3 |
VERSION_BUMP |
35d18a96 |
| Oct 31, 2024 8:40am |
|
3 |
VERSION_BUMP |
82ed5a05 |
| Sep 14, 2024 9:53pm |
|
1 |
VERSION_BUMP |
6a8068f5 |
| Aug 2, 2024 5:42pm |
|
1 |
VERSION_BUMP |
0e8d2a69 |
| Nov 18, 2023 10:32am |
|
0 |
VERSION_BUMP |
060d3adc |
| Sep 28, 2023 7:49am |
|
0 |
VERSION_BUMP |
7cb3d4f9 |
| Feb 9, 2023 6:05pm |
|
0 |
VERSION_BUMP |
d24f7e1c |
| Feb 9, 2023 6:05pm |
|
0 |
VERSION_BUMP |
36a8abe1 |
| Jan 15, 2023 11:01pm |
|
1 |
VERSION_BUMP |
21086409 |
| Jan 15, 2023 11:00pm |
|
1 |
VERSION_BUMP |
420db5cc |
|