[ckan-dev] CKAN with different kinds of databases

Thu Sep 5 20:26:48 UTC 2013

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20130905/6d18576c/attachment-0001.html>