Does Fuelphp's database class or ORM have support for full text search?
I'm trying to do full text search but I discovered that different database engines have different implementation. While mysql's implementation looks simple and straight forward, Postgres' implementation looks complicated (I'm yet to properly study it though, just a quick look) and the app I'm working on should work on both mysql (or mariadb) and postgres.
I want to know if Fuelphp's database class or ORM has a consistent way of doing full text search irrespective of which database engine being used otherwise I'll have to write different codes for different database engines.
BTW is there a way to determine the database engine being used from the DB class, ORM or any means?
No, as it is (very) platform specific. And as you have already noticed, it is not easy to come up with a consistent interface for it. Afaik, other ORM's (like Propel, Doctrine, etc) don't have support for it either.
As for your BTW, yes, the database connection class has a method for that:
\DB::instance()->driver_name()
or
\DB::instance('db-definition')->driver_name()
if you have multiple definitions in your db.php. And you'd probably want to test if the instance exists before calling a method on it. ;-)
Donate
