im beginning a new project. The core is a “search engine” , meaning FullText search in multiple table. Raw SQL is my first choice but…
So my question is : what is the best compromize using slim between maintanability and performance ? and if ORM, which one ?
Thank you for your advice !
Keep yourself away from Doctrine, make your own ORM if you have to
for now, im gonna use the CakePHP/database querybuilder
If it"s just about the query builder, you should definitely stop thinking of Doctrine and stay with what you have or even write something “tailor-made” by your own. On the other hand if somehow you’re convinced database object relational mapping is something you just can’t live without, but you need something light and flexible it means that PDO::FETCH_CLASS might be your best friend ever related to your own DAO’s and DTO’s with value objects. You can even play with aggregates (in case of table relations) in quite simple way still accompanied by the old pal - PDO .
I use Slim 4 along with Eloquent as the ORM. It feels good.