PostgreSQL
Advanced open source relational database with SQL support and extensibility
SQL
Standard language for relational databases
Typing: static Created: 1974
Paradigms
declarative
Pros and Cons
Ventajas
- + Universal standard for DBs
- + Declarative and expressive
- + Powerful for complex queries
- + Essential for any dev
Desventajas
- - Variations between vendors
- - Not a general-purpose language
- - Limited for procedural logic
- - Can be complex to optimize
Casos de Uso
- Database queries
- Data warehousing
- ETL and data pipelines
- Reports and analysis