[ddj] data-driven-journalism Digest, Vol 49, Issue 5

Fri Apr 17 21:57:45 UTC 2015

Sam,
  Almost all RDBMS - mySQL for example have import excel functions . There
are free scripts for more complex migrations involving cleaning or user
intermediation.

Almost every ISP offers mySQL or Postgress or whatever deployable with a
few button presses and online clients like phpMyAdmin or Toad and for US5$
you can (theoretically unlimited) databases.

And ISP's tend to be a lot more enduring that statup fremium services.

If your jouno's are truly no tech you can provide screen tutorials of the
connect, migration scripts and process and how to view and search DB
tables.

I know its not a magic answer but it uses universal technologies that will
still be around in  years let alone months cost damn near to nothing (and
if you could get amazon or some university to host you - then zero
(rackspace were offering grants to socially useful projects)).

But I have seen designers and managers become capable data wranglers (in
 the analysis / reporting sense) given minimal introduction to existing
opensource  graphical DB clients.

Just a backup idea in case you dont find a matched to fit free online
service that seem durable ;)

Dan

On 18 April 2015 at 01:22, <data-driven-journalism-request at lists.okfn.org>
wrote:

> Send data-driven-journalism mailing list submissions to
>         data-driven-journalism at lists.okfn.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> or, via email, send a message with subject or body 'help' to
>         data-driven-journalism-request at lists.okfn.org
>
> You can reach the person managing the list at
>         data-driven-journalism-owner at lists.okfn.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of data-driven-journalism digest..."
>
>
> Today's Topics:
>
>    1. Re: GUI database tools for newsrooms (Friedrich Lindenberg)
>    2. Re: GUI database tools for newsrooms (Enes ABANOZ)
>    3. Re: GUI database tools for newsrooms (Sam Leon)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 17 Apr 2015 10:02:17 +0200
> From: Friedrich Lindenberg <friedrich.lindenberg at okfn.org>
> To: "List about Data Driven Journalism and Open Data in Journalism."
>         <data-driven-journalism at lists.okfn.org>
> Subject: Re: [ddj] GUI database tools for newsrooms
> Message-ID:
>         <CABGw_Bv68kdSr9xdB-hXuRrn0N5Hy=
> Vdxs4E40su+oU9Y30fdw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> I've always felt that Heroku Dataclips are just two or three features short
> of being really awesome: https://devcenter.heroku.com/articles/dataclips
>
> - Friedrich
>
> On Fri, Apr 17, 2015 at 9:49 AM, Sam Leon <sam.leon at okfn.org> wrote:
>
> > I'm looking for a secure hosted database service ideally running Postgres
> > in the backend which could be queried and updated using SQL commands but
> > also had a graphical interface for users not familiar with SQL who can
> > easily run queries and export to CSV. It's for journalists I'm working
> with
> > who have various datasets currently in Excel which is a nightmare for
> > simultaneous work and is exceptionally brittle.
> >
> > I'm aware of the the PANDA project <http://pandaproject.net/>, wondered
> > if anyone else had any tooling/service tips?
> >
> > Sam
> >
> > --
> >
> > *Sam LeonSenior analyst & trainer | skype: samedleon  |  @Noel_Mas
> > <https://twitter.com/noel_mas>The Open Knowledge Foundation
> > <http://okfn.org/>Empowering through Open Knowledgehttp://okfn.org/
> > <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>*
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
> >
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150417/5e3ac24f/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 2
> Date: Fri, 17 Apr 2015 08:11:56 -0400
> From: Enes ABANOZ <eabanoz at gmail.com>
> To: "List about Data Driven Journalism and Open Data in Journalism."
>         <data-driven-journalism at lists.okfn.org>
> Subject: Re: [ddj] GUI database tools for newsrooms
> Message-ID: <F597A89A-AE7E-4B3A-8FF0-1B61B3F9C3A6 at gmail.com>
> Content-Type: text/plain; charset="us-ascii"
>
> Hi Sam,
> DBMango may help your problem
>
> Sent from my iPhone
>
> > On Apr 17, 2015, at 3:49 AM, Sam Leon <sam.leon at okfn.org> wrote:
> >
> > I'm looking for a secure hosted database service ideally running
> Postgres in the backend which could be queried and updated using SQL
> commands but also had a graphical interface for users not familiar with SQL
> who can easily run queries and export to CSV. It's for journalists I'm
> working with who have various datasets currently in Excel which is a
> nightmare for simultaneous work and is exceptionally brittle.
> >
> > I'm aware of the the PANDA project, wondered if anyone else had any
> tooling/service tips?
> >
> > Sam
> >
> > --
> > Sam Leon
> > Senior analyst & trainer |  skype: samedleon  |  @Noel_Mas
> > The Open Knowledge Foundation
> > Empowering through Open Knowledge
> > http://okfn.org/  |  @okfn  |  OKF on Facebook  |  Blog  |  Newsletter
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150417/1452babd/attachment-0001.html
> >
>
> ------------------------------
>
> Message: 3
> Date: Fri, 17 Apr 2015 16:22:12 +0100
> From: Sam Leon <sam.leon at okfn.org>
> To: "List about Data Driven Journalism and Open Data in Journalism."
>         <data-driven-journalism at lists.okfn.org>
> Subject: Re: [ddj] GUI database tools for newsrooms
> Message-ID:
>         <
> CAE3MxAX_4YvB9cWeRuTxy3jEfytrr_p+MOxHXtW16cPkZG7Gzw at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> Thanks Friedrich
>
> @Enes - do you have a link for that?
>
> Sam
>
> On 17 April 2015 at 13:11, Enes ABANOZ <eabanoz at gmail.com> wrote:
>
> > Hi Sam,
> > DBMango may help your problem
> >
> > Sent from my iPhone
> >
> > On Apr 17, 2015, at 3:49 AM, Sam Leon <sam.leon at okfn.org> wrote:
> >
> > I'm looking for a secure hosted database service ideally running Postgres
> > in the backend which could be queried and updated using SQL commands but
> > also had a graphical interface for users not familiar with SQL who can
> > easily run queries and export to CSV. It's for journalists I'm working
> with
> > who have various datasets currently in Excel which is a nightmare for
> > simultaneous work and is exceptionally brittle.
> >
> > I'm aware of the the PANDA project <http://pandaproject.net/>, wondered
> > if anyone else had any tooling/service tips?
> >
> > Sam
> >
> > --
> >
> > *Sam LeonSenior analyst & trainer | skype: samedleon  |  @Noel_Mas
> > <https://twitter.com/noel_mas>The Open Knowledge Foundation
> > <http://okfn.org/>Empowering through Open Knowledgehttp://okfn.org/
> > <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>*
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
> >
> >
> > _______________________________________________
> > data-driven-journalism mailing list
> > data-driven-journalism at lists.okfn.org
> > https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> > Unsubscribe:
> https://lists.okfn.org/mailman/options/data-driven-journalism
> >
> >
>
>
> --
>
> *Sam LeonSenior analyst & trainer | skype: samedleon  |  @Noel_Mas
> <https://twitter.com/noel_mas>The Open Knowledge Foundation
> <http://okfn.org/>Empowering through Open Knowledgehttp://okfn.org/
> <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/data-driven-journalism/attachments/20150417/e0941cde/attachment.html
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
>
>
> ------------------------------
>
> End of data-driven-journalism Digest, Vol 49, Issue 5
> *****************************************************
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20150418/033c5311/attachment-0002.html>