#245 open
explody

Add support for PostgreSQL

Reported by explody | May 27th, 2009 @ 12:17 AM | in 1.0

The MySQL requirement is very limiting, especially now considering MySQL's future is somewhat uncertain. In our case, we have an established postgres infrastructure and the MySQL requirement is pretty much a showstopper.

Thanks!

-Mike

Comments and changes to this ticket

  • Gaspard Bucher

    Gaspard Bucher May 27th, 2009 @ 12:35 AM

    • Title changed from “Add support for PostgresQL” to “Add support for PostgreSQL”
    • Tag set to enhancement, up
    • State changed from “new” to “open”

    Hi Mike !

    I am not very familiar with PostgreSQL, but you are right, it's important to support this database. We have isolated all the database specific code in the MysqlAdapter module, so I hope porting will not be too hard (hopefully).

    We just needed someone motivated by this feature to get our hands on it !

    We will first finish the transition to rails 2.x with some enhanced features RubyLess and API stabilization and then PostgreSQL and other enhancements. From the projects we have to work on for customers, we need to have zena on rails 2.x this summer so things should be moving quite fast.

  • David Lee

    David Lee July 15th, 2010 @ 10:44 AM

    • Milestone order changed from “0” to “0”

    Hi, it seems like with the most recent commit, PostgreSQL is supported, no?

  • Gaspard Bucher

    Gaspard Bucher July 15th, 2010 @ 02:52 PM

    Support is not perfect yet: there are some issues with the templating language and the SQL that is generated to build queries.

    As soon as I can throw out a beta release of the 1.0 branch, I will work on these issues.

    But until PostgreSQL support is as good as MySQL, it will take some time and "real world" experience with a beta.

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

Anyone knows how to use formatting here ?

Git repository: http://github.com/zena

Official website: http://zenadmin.org

Shared Ticket Bins

People watching this ticket

Pages