I have to make some filters, such as get persons who are in a given departement, and I was wondering about the best way to do it.
I espacially would like to know about the databases compatibility. I mean if tommorow I change from MySQL to SQLite, would my requests still run?
I found that about Query Builder:
It offers certain degree of DB abstraction, which simplifies migration to different DB platforms.
Is it the same for the CDbCriteria objects? Is it better?
If anyone knows a bit more about this subject, you're welcom.
Have a nice day