[ckan-dev] CKAN on top of Existing DBs

[Alfredo Serafini]

Hi having some sort of database abstraction could be indeed a strategic
improvement!
For example I'm currently working for a client which uses only SQLServer,
and I cannot avoid that. If i'd have support for this database, I could
suggest them to install python on windows and start using CKAN as platform.
Generally speaking the database is often the real lock-in, because there
are many cases where it's simply impossible to migrate data, or even link
data on other platform (using ODBC, for example). Providing an abstraction
layer could be a real big improvement, for my point of view too.

If such component does not exist at the moment, are there any chance to
start developing it?
Does anybody have suggestion on where to start, and how much effort would
be required?
I mean: the code is in python, but it probably use things like SQLAlchemy
for most of the code, which should be as far as I know the closest thing to
a JDBC in the python context. This should imply that there are probably
many small points to check where still exist postgres dialect commands, but
it's not clear how much work could be needed to convert thos parts.

thank in advance

Alfredo



> Message: 1
> Date: Wed, 16 Jul 2014 18:54:36 +0000
> From: "Rimar, Steve" <srimar at qualcomm.com>
> To: "ckan-dev at lists.okfn.org" <ckan-dev at lists.okfn.org>
> Subject: [ckan-dev] CKAN on top of Existing DBs
> Message-ID: <CFEC1879.F21B%srimar at qualcomm.com>
> Content-Type: text/plain; charset="windows-1252"
>
> Hi - we're trying to use CKAN for our organization?s data registry and
> were wondering how we would use this on top of existing datasets that are
> in databases such as Oracle or SQL Server? When you add a dataset in CKAN
> you have 3 options: File, Link or API. Looks like there's an option missing
> for Database or JDBC/ODBC? Is this available as an add-on or plug-in? Can
> we build this out ourselves if not?
>
> Thanks,
> Steve
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/ckan-dev/attachments/20140717/d5f45af9/attachment-0003.html>