Dynamic Website Builder Platform

Problem

Needed a builder where users can create arbitrary entity types and fields without DB migrations. Plus data isolation between clients.

Solution

Implemented EAV (Entity-Attribute-Value) pattern with multi-tenancy at the database level. Users create their entities and fields through the interface, data is stored in a universal and extensible structure.

Technical Details

• EAV pattern for dynamic schema without migrations
• Multi-tenancy with isolated databases per client
• Type-safe storage of different data types

Results

• Users create entities without developer involvement
• Complete data isolation between clients
• Zero downtime for schema changes
• System adapts to different business domains

Lessons Learned

• EAV provides maximum flexibility but requires query optimization
• Multi-tenancy at DB level is the most reliable isolation
• Type-safe storage prevents data corruption

Architecture Diagrams