search

square / kochiku

Shard your builds for fun and profit
Apache License 2.0
599 stars 51 forks source link

Support Postgresql? #37

Closed fire closed 10 years ago

fire commented 10 years ago

Is it possible to support postgresql?

jkingdon commented 10 years ago

Shouldn't be too hard. I'd start by editing database.yml to use postgres and then running the testsuite. That should give some idea of how close it is.

robolson commented 10 years ago

Echoing @jkingdon, it is possible. Kochiku uses the ActiveRecord ORM which is database agnostic. However, I do not think it will work out of the box because Kochiku contains a couple manually crafted SQL queries that would need to be adjusted for PostgreSQL.

These two places I know of with hand written SQL:

I am closing this issue because it is just a question. We would be happy to entertain pull-requests to make Kochiku PostgreSQL compatible. What are your reasons for wanting to use PostgreSQL with Kochiku instead of MySQL?