- Don't get bitten by missing foreign key indexes
Postgres doesn't give you indexes on foreign keys by default (unlike primary keys). This makes some sense when you think about it - there's no necessity for them in order to keep the constraint checking efficient.
- Cut Out the Middle Tier: Generating JSON Directly from Postgres
14 Jul 2021
PostgreSQL has built-in JSON generators that can be used to create structured JSON output right in the database, upping performance and radically simplifying web tiers.