🐘 PostgreSQL¶
The Basics¶
- MVCC multiversion concurrency control
📝 Training Notes¶
These are what I most frequently want to link to...
📆 Late 2024¶
High Performance PostgreSQL¶
This text focuses on OLTP (online transaction processing) given the focus on short duration queries running in high volume and with high concurrency. This is instead of OLAP (online analytical processing).
The text uses the andyatkinson/rideshare app.
Active Record follows the Convention over Configuration design principle.
ERD¶
- Create an Entity Relationship Diagram automatically for each release¶
Glossary¶
- CTE Common Table Expressions