Hi, is there any good EAV implementation for Phalcon? Making one by setting manually relationships for every single attribute would be very inelegant and dirty job.
What I'm trying to do is a mysql table for storing notifications and data for them. Let's say that I've got a few types of notifications and every type needs a few different attributes. I can see only three way of solving it:
- add all attributes to same table and set nulls for unused ones (in my opinion inelegant, makes table large)
- store all non universal attributes in json attribute (come on, no filtering in selects? inacceptable)
- EAV - long phql code or hand made relationships for every attribute (both are kinda dirty)
I'm out of ideas, can anyone think of a better idea?