Laravel Sti Laravel Package

Product Decisions This Supports

• Database Schema Flexibility: Enables a single-table inheritance (STI) pattern for Eloquent models, reducing the need for complex joins or multiple tables for hierarchically related entities (e.g., User → Admin, Customer, Guest). Aligns with build vs. buy decisions favoring buy for STI functionality.
• Roadmap for Polymorphic Relationships: Supports future expansion of polymorphic relationships (e.g., Post → BlogPost, NewsPost) without schema refactoring.
• Use Cases:
  • User Roles: Consolidate users table with discriminated subtypes (e.g., Admin, Moderator).
  • Content Systems: Manage diverse content types (e.g., Article, Video, Gallery) under one table.
  • Legacy System Integration: Migrate from class-table inheritance (CTI) to STI for performance gains.
• Performance Optimization: Reduces database queries for hierarchical data by leveraging Laravel’s built-in STI resolution.
• Developer Productivity: Eliminates boilerplate for type-based model instantiation, accelerating feature development.

When to Consider This Package

• Adopt When:
  • Your application uses hierarchical models (parent-child relationships) with shared attributes but distinct behaviors.
  • You prioritize simplicity over normalization (STI trades strict normalization for query efficiency).
  • Your team is already using Laravel Eloquent and needs STI without reinventing the wheel.
  • You want to avoid N+1 query problems associated with polymorphic relationships or joins.
• Look Elsewhere If:
  • Your data model requires strict relational integrity (STI can lead to sparse tables).
  • You need multi-tenancy isolation (STI may complicate row-level security).
  • Your use case involves highly dynamic schemas (e.g., user-defined subtypes at runtime).
  • You’re using non-Laravel PHP frameworks or need a database-agnostic solution.
  • Your team prefers class-table inheritance (CTI) for clearer separation of concerns.

How to Pitch It (Stakeholders)

For Executives: "This package lets us consolidate related but distinct data types (e.g., user roles, content formats) into a single database table, reducing complexity and improving query performance. It’s a lightweight, Laravel-native solution that cuts development time for hierarchical models—ideal for scaling features like role-based access or dynamic content systems without overhauling our database schema."

For Engineers: *"Laravel-STI provides a battle-tested STI trait for Eloquent, handling type discrimination automatically. Key benefits:

• Zero boilerplate: Just add the trait to your root model and extend for subtypes.
• Seamless integration: Works with Laravel’s query builder and relationships out of the box.
• Future-proof: Supports polymorphic morph maps and eager loading.
• MIT licensed: No vendor lock-in. Perfect for projects where STI aligns with our data model, avoiding the pitfalls of manual implementation or over-engineered ORM solutions."