FuelPHP Forums

pajooh

Hello all,
I'm trying to start a new application with FuelPHP+Postgresql,
I found out that Fuels DB related classes (DBUtin, Migrate, ...) is tied to MySQL, even in the PDO driver!!!
For example:
- using 'if not exist' which is not a valid query in Postgresql < 9.1
- using display width constraint for integers which is MySQL specific syntax,
- Using auto_increment, however Postgresql prefers serial
- and more ... so, I had many troubles starting the framework.
I wonder if it's possible to replace core DB Abstraction Layer with something else,
like Doctrine's DBAL, or Zend framework's DB Abstraction layer
any help to do that would be highly appreciated

Harro

We are aware of this. There is a rewrite of the Query Builder on the roadmap for v2.0, which will utilize platform specific drivers to generate the SQL.

pajooh

Harro Verton wrote on Saturday 12th of November 2011:

We are aware of this. There is a rewrite of the Query Builder on the roadmap for v2.0, which will utilize platform specific drivers to generate the SQL.

I know that. what i want to know is the best way to make my Fuel app with PostgreSQL up and running.
also, is there any help needed implementing new Query Builder to make it ready sooner? thanks

Harro

It's going to be a complete rewrite (the current one is a Kohana derivative), so it will not be introduced into a '1.x' branch. For now, the best option is to extend or replace the offending classes by your own, by copying them from fuel to app, and replace any MySQL specific code.

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion