Skip to content

🐘 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

📚 Recommendable Reading