Think of PostgreSQL as the “brains” — it does the actual work of managing data.
- Type: Database management system (DBMS).
- Role: The actual database engine that stores, processes, and manages your data.
- Nature: Runs as a server process and is accessed via SQL queries (e.g., through
psql
, scripts, or applications). - Usage:
- Define schemas, tables, indexes, and relationships.
- Insert, query, update, and delete data.
- Handle transactions, concurrency, and security.
- Interface: Can be used purely via command line or programmatically through APIs/drivers (Python
psycopg2
, JDBC, etc.).
Related: