[datahub-discuss] [Datahub-discuss] CrowdCrafting & Datahub

[Rufus Pollock]

Hi Daniel,

Do be aware that DataHub (and CKAN) has support for storing json data in
the tables via Postgres's support for a json type:

http://docs.ckan.org/en/latest/datastore.html#field-types
http://www.postgresql.org/docs/9.3/static/functions-json.html

Obviously this would be a bit hacky in that you'd basically being storing
blobs of json but you might be able to deserialize a bit and then store
json blobs for the rest.

Rufus


On 12 September 2013 07:36, Daniel Lombraña González <teleyinex at gmail.com>wrote:

> Hi Ross,
>
> By default CrowdCrafting.org is only storing data in JSON format in CKAN.
> The most interesting data is a JSON object stored in a column named _info_.
> However I guess it would be very difficult to explode it and convert it to
> valid tables (this column could have anything in JSON format, with so many
> nested values that a 2D column scheme does not fit at all) in order to fit
> well within CKAN and get a direct rendering view like the charts, etc, etc.
>
> For CrowdCrafting.org I see the DataHub.io as a service to share the data
> with your colleagues, and also to mark it as yours, so other researchers
> can cite you without problems.
>
> For the moment I'm fine with it, I've to check a small issue that I opened
> sometime ago with DataHub.io so, we can actually start using DataHub.io
> instead of demo.ckan.org.
>
> All the best,
>
> Daniel
>
>
> On Wed, Sep 11, 2013 at 7:38 PM, Ross Jones <ross at servercode.co.uk> wrote:
>
>> Hi,
>>
>> Are there any specific CKAN features or extensions that CrowdCrafting
>> uses that might not be enabled on datahub.io?  Are there things that
>> datahub.io could do better, or provide to make the integration better?
>>
>> Ross
>>
>>
>> On 11 Sep 2013, at 12:30, Daniel Lombraña González <teleyinex at gmail.com>
>> wrote:
>>
>> Hi there,
>>
>> Rufus has written an e-mail asking about people that would like to
>> discuss about the next steps for the DataHub web service, and I'm
>> interested.
>>
>> I'm the lead developer of PyBossa/CrowdCrafting and I would like to use
>> the DataHub service as a way to share scientific data. Right now we have an
>> integration between both platforms (currently only exporting to
>> demo.ckan.org) but in the coming days it will be changed to the DataHub.
>>
>> For this reason, I would like to discuss about the usage and integration
>> of DataHub and CrowdCrafting.
>>
>> Cheers,
>>
>> Daniel
>>
>> --
>>
>> ··························································································································································
>> http://daniellombrana.es
>> http://citizencyberscience.net
>> http://www.shuttleworthfoundation.org/<http://www.shuttleworthfoundation.org/fellows/daniel-lombrana/>
>>
>> ··························································································································································
>> Por favor, NO utilice formatos de archivo propietarios para el
>> intercambio de documentos, como DOC y XLS, sino PDF, HTML, RTF, TXT, CSV
>> o cualquier otro que no obligue a utilizar un programa de un
>> fabricante concreto para tratar la información contenida en él.
>>
>> ··························································································································································
>>  _______________________________________________
>> Datahub-discuss mailing list
>> Datahub-discuss at lists.okfn.org
>> http://lists.okfn.org/mailman/listinfo/datahub-discuss
>>
>>
>>
>
>
> --
>
> ··························································································································································
> http://daniellombrana.es
> http://citizencyberscience.net
> http://www.shuttleworthfoundation.org/fellows/daniel-lombrana/
>
>
> ··························································································································································
> Por favor, NO utilice formatos de archivo propietarios para el
> intercambio de documentos, como DOC y XLS, sino PDF, HTML, RTF, TXT, CSV
> o cualquier otro que no obligue a utilizar un programa de un
> fabricante concreto para tratar la información contenida en él.
>
> ··························································································································································
>
> _______________________________________________
> datahub-discuss mailing list
> datahub-discuss at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/datahub-discuss
>
>


-- 
*

Rufus Pollock

Founder and Executive Director | skype: rufuspollock |
@rufuspollock<https://twitter.com/rufuspollock>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge
http://okfn.org/ | @okfn <http://twitter.com/OKFN> | OKF on
Facebook<https://www.facebook.com/OKFNetwork>|
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/datahub-discuss/attachments/20130912/87820a78/attachment-0001.html>