Loading content
PostgreSQL is an object-relational database management system known for its extensibility and SQL compliance. It supports a wide variety of data types and offers features such as transactions, subselects, and complex queries. PostgreSQL is commonly used in web applications, data analysis, and as a backend for various software solutions.
Use this profile to understand the building block briefly, place it in the model, and switch to the 360° assessment when needed.
Technical building block: can be automated, integrated, or operated.
Concrete cog in the system that works inside larger relationships.
PostgreSQL is a free object-relational database system for reliable, transactional, and complex data processing.
PostgreSQL grew from the POSTGRES project started in 1986 by Michael Stonebraker and his team at the University of California, Berkeley. The project became PostgreSQL in 1996; an independent global community maintains it today.
An application sends SQL statements to the PostgreSQL server. Tables, data types, constraints, and indexes describe the data, while transactions protect related changes. Extensions, such as geospatial or full-text capabilities, add to the core. Operators must plan for versions, backups, access control, and scaling limits.
Data is stored in tables with relationships, data types, and integrity rules.
Several changes execute atomically and consistently, or are rolled back together.
Extensions and custom data types adapt the database core to specialised use cases.
PostgreSQL is a strong data foundation for web applications, analytics, and integration systems. Choosing it requires decisions about operations, high availability, query behaviour, and privacy.
Where this building block is located in the topic model.
Explore how this building block connects to concepts, methods, technologies, and tools.
These sources establish the term and its professional meaning.
All direct connections of the current building block in a compact text view.
This classification shows where the building block typically matters, how demanding it is, and what kind of impact it has in the model.
The level within the organization (enterprise, domain, team) at which the AssetBlock is applied.