Up:: PostgreSQL X:: SQL (Structured Query Language)
This note is still with a touch of AI, will rewrite this one soon, sorry!
- Relational Model: Uses tables, rows, and columns, similar to other SQL databases.
- ACID Compliance: Ensures atomicity, consistency, isolation, and durability of transactions.
- Extensibility: Allows custom data types, operators, and functions.
- JSON Support: Can store and query JSON data for semi-structured data.
- Procedural Languages: Supports languages like PL/pgSQL, PL/Tcl, PL/Perl, and PL/Python.
- Indexes: Supports various indexing techniques (B-tree, hash, GiST, SP-GiST, GIN, BRIN).
- Full-Text Search: Built-in support for searching text.
- Concurrency Control: Uses Multi-Version Concurrency Control (MVCC) for handling concurrent transactions without locking.