Love Fuel?    Donate

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
Trouble in using DB Abstraction Layer
  • pajoohpajooh
    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
  • HarroHarro
    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.
  • pajoohpajooh
    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
  • HarroHarro
    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.
Add a Comment

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories

In this Discussion