7

Is there any site where one can easily publish a small database (<5MB)? Ideally, the data should be published in a way that it could be sql selected by number of parameters. Just like any national statistical office (for example, Sweden).

Of course, I only need to publish small datasets. But the key feature, it the possibility to select a subset of the data easily.

  • What is the data, and whom would be the target audience for using the data? – Andrew - OpenGeoCode Aug 25 '15 at 20:44
  • I would assume it'd be more likely to find companies willing to host dumps -- allowing SQL queries are more costly (memory, etc.) and riskier (issues of database security). Unfortunately, WebSQL was removed from the HTML5 standard ... however, most major browsers support it, so provided people aren't using Firefox or IE, you can serve static files (database dump + javascript to set up a client-side search interface) – Joe Aug 26 '15 at 0:03
  • 2
    Hey, I work at OpenDataSoft. We are working on a free offer to publish, explore, visualize and share Open Data. I'm confident it'll be live at the end of september. If you want to beta test it don't hesitate to ping me: nicolas [dot] terpolilli [at] opendatasoft.com – Terpo Aug 26 '15 at 14:04
  • @Terpo, I knew the feature has to appear soon! I searched through the web with all my might and didn't find anything. Of course, I want to betta-test the feature (ping sent) – ikashnitsky Aug 26 '15 at 14:16
  • 1
    @Franck, by small I mean something less than 5 MB – ikashnitsky Aug 26 '15 at 18:44
3

If it's really simple, you can use the CSV viewer from Github, which has a built-in search tool.

A similar tool is datapipes and for HTML from OKFN Labs. See the demo.


For a more complicated dataset, with more than one table, then another simple option is to export the database as a .SQL file and then let users import it into the SQL database of their choice. You can host the .sql file anywhere, but Github and Datahub.io are two good choices. Here is a simple example.

I can expand this answer for tips on how to do this if that is the direction you go.


Another option is then to use visualization tool or other Javascript library for display CSV data. See for example D3.js + CSV. There are hosts of other CSV-editors and viewers for the browser.

  • Thanks for the answer! My main concern is, data selection (filtering) should be easily available for a person with basic computer skills. Something like a simple data sheet with the ability to filter by each column and easy export to csv and xlsx would do. – ikashnitsky Aug 26 '15 at 19:55
  • @Ilya - are you planning on hosting the site yourself, or using a free hosting solution (like datahub or github)? – philshem Aug 27 '15 at 6:08
  • 1
    taking into account the small amount of my data, I would prefer some ready-made solution. – ikashnitsky Aug 27 '15 at 7:32
2

If you're looking for completely out of the box solution, datahubs.io or opendata.socrata.com (*) are your best bets.

With all datasets posted on Socrata, you get an embeddable and filterable view (such as https://opendata.socrata.com/d/iu3z-yanc) in addition to an automatically documented API (such as http://dev.socrata.com/foundry/#/opendata.socrata.com/iu3z-yanc)

* In full disclosure, I work for Socrata

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.