# PostgreSQL

Group: Data

PostgreSQL is my default for SaaS data. The AI form builder, the immigration portal and the quote engine run on it, with indexes and row-level security doing real work.

## What I do with PostgreSQL

- Normalised models with an audit trail
- Indexes and denormalised hot paths
- Row-level security for tenants

## Projects that use it

- [AI form builder](https://venuspaneliya.com/work/ai-form-builder/): Forms in seconds, not minutes
- [Insurance quote engine](https://venuspaneliya.com/work/insurance-quote-engine/): From 10+ minutes to under 2
- [Immigration case portal](https://venuspaneliya.com/work/immigration-case-portal/): 40% fewer support calls

## Notes

- [That’s not multi-tenancy. That’s a filter.](https://venuspaneliya.com/writing/not-multi-tenancy-a-filter/)
- [Fix the foundation before you add AI](https://venuspaneliya.com/writing/fix-the-foundation-before-ai/)

Hire me for PostgreSQL: https://venuspaneliya.com/contact/