[ckan-dev] CKAN with different kinds of databases

Fri Sep 6 14:50:30 UTC 2013

Cletus,

There are subtle differences between the SQL syntax. CKAN doesn't
always use sqlalchemy. So I expect you'll have to make code changes in
a number of places to use a different DB. Just look at the tests which
skip on SQLite, for example.

You'll find that a customer will probably be running a different
version/flavour of Linux, so you'll want a fresh server or VM for CKAN
anyway. Then installing postgres with all the other dependencies is a
simple step.

David

On 6 September 2013 02:03, 李政國 <Cletus at cht.com.tw> wrote:
> Hi,
>
>
>
> Thanks for sharing the extension of Mongodb, Ben.
>
> Since CKAN uses sqlalchemy, I also think it should be possible to use other
> databases.
>
> Our customer might have installed Oracle or SQL server already, so it’ll
> definitely reduce overhead if CKAN can work on the same database.
>
>
>
>
>
> Best,
>
> Cletus
>
>
>
>
>
>
>
> sqlalchemy is certainly capable of supporting other databases. The testing
> documents mention SQLite
> (http://docs.ckan.org/en/latest/test.html#testing-with-sqlite), although
> I've only been able to run nosetests with Postgres.
>
>
>
> I would like to hear how this goes. If CKAN, for instance, supported MySQL,
> I could host my CMS (Wordpress / Drupal) and CKAN in the same installation,
> reducing overhead.
>
>
>
> On Wed, Sep 4, 2013 at 7:50 AM, Ben Scott <bnm at benscott.co.uk> wrote:
>
> Hi -
>
>
>
> Ive never tried using it, but I did come across this mongodb extension,
> which looks to replace the postgresql datastore with mongo. Might be worth a
> look?
>
>
>
> https://github.com/alexbyrnes/ckanext-mongodb
>
>
>
> Cheers,
>
> Ben
>
>
>
> On 4 Sep 2013, at 12:03, Sean Hammond <sean.hammond at okfn.org> wrote:
>
>
>
> We are currently facing a problem about using other kinds of
> databases(ex: oracle, mysql, sql server…etc) with CKAN.  Can anyone
> share experiences of using other databases except PostgreqSQL with
> CKAN(for the core schema and datastore)?  Will they cause any
> unpredictable issues?
>
>
> I don't know of anyone who has tried this. It's certainly not supported,
> the CKAN dev team only tests CKAN with PostgreSQL and I think using a
> different database server could cause issues. I wouldn't recommend it.
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>
>
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>
>
>
>
>
> --
> Dave Caraway
>
> Owner
>
> Fog Mine
>
> dave at fogmine.com
>
> Cell: (937) 985-0867
>
> Fax: (866) 238-3120
>
>
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: http://lists.okfn.org/mailman/options/ckan-dev
>