PropCanopy Engineering
Systems & Operations Blog
Honest architectural breakdowns, database security reviews, and real estate systems engineering from the team building PropCanopy.
Architecture
7 min read
The Double-Entry Property Ledger: Why Real Estate Demands Immutable Transaction Logs
Why single-entry balance fields in property management software create quiet reconciliation nightmares, and how we engineered an immutable double-entry ledger.
August 24, 2026Read Article
Operations
6 min read
Finite State Machines in Maintenance: Stopping Invoice and Status Drift
Why maintenance operations fail when treated as generic CRUD tickets, and how strict state transitions prevent unbudgeted contractor costs.
August 18, 2026Read Article
Security
8 min read
PostgreSQL Row-Level Security: One Database, Six Discrete Surfaces
How Postgres RLS policies allow landlords, residents, and contractors to operate on the same Postgres instance with zero risk of data leakage.
August 12, 2026Read Article
Security Post-Mortem
5 min read
Post-Mortem: Fixing Privilege Escalation in Self-Service Renter Insurance Verification
How a client-side insertion policy allowed tenants to submit pre-verified insurance policies, and how check constraints and server action guards resolved it.
August 26, 2026Read Article