PostgreSQL
An open-source object-relational database system for structured storage and querying of data.
What is PostgreSQL?
PostgreSQL is an open-source database management system with a relational model and extensible data types and functions. It uses and extends SQL. Tables, relationships, transactions and data constraints help store and process structured data. PostgreSQL is a specific system, whereas SQL names the language. Features used depend on the version and application design.
In a fictional service portal, PostgreSQL stores customers and related requests. Appropriately configured foreign keys can prevent invalid references. Who may view or edit a request must additionally be defined in the intended permission model. The team also plans backups, recovery, updates and operations. Choosing the database product alone establishes neither those workflows nor business correctness of every stored value.
Sources
Related terms
- DatabaseAn organised collection of data that software can access selectively and apply changes to.
- Relational data modelModelling data in tables with rows, columns and explicitly described relationships.
- SQLA language for defining, querying and changing data.
- Open sourceSoftware whose licence meets the freedoms and conditions defined for open source.
- Object-relational mappingConnecting program objects to data in a relational database.
- Database queryA database query requests data under defined conditions. Selection, result scope and ordering should fit the work being done.
Your project with ASES
Describe your project to us. We will get back to you with an initial assessment.