Slashdot Mirror

← Back to Stories (view on slashdot.org)

Large, Free, and Interesting SQL-ready Datasets?

Posted by Cliff on from the drop-in-data dept.

Jon H asks: "I'd like to teach myself various platforms or technologies, involving accessing databases. The problem is, my ideas for projects to learn on usually are boring, toy projects, involving lots of boring data entry in order to create a useful database. Things like personal library databases. This doesn't particularly interest me. It would be much easier if I had a big, interesting dataset which I could load into an SQL database without too much trouble. Then I could spend my time on the php, or WebObjects, or JBoss, or whatever. I'd like something more real than the usual toy demo databases. Something weighty, 20 megabytes and up, big enough for poor software design to cause performance issues which might not be seen in smaller databases. Ideally, it'd be in a form that could easily be loaded into an SQL database, perhaps even including a schema. Any links would be appreciated. Do such beasts exist?

3 of 73 comments (clear)

  1. USDA by L.+VeGas · · Score: 5, Informative

    One I've used for laughs is the USDA Nutrient Database. It gives you, well, nutrient information on just about any food you can think of. It's normalized, and just complicated enough to have fun with.

    You're going to have to google it yourself, though.

    --
    Best Windows Freeware
  2. NIST databases by bmwm3nut · · Score: 5, Interesting

    nist has a bunch of data. i remember a while ago downloading handwritten characters to make handwriting recognition software. they have data for just about everything, the chemistry data is probably some of the best to put in a relational database. check out: http://www.nist.gov/srd/index.htm

  3. IMDb by br0ck · · Score: 5, Informative

    Use IMDbPY to populate a database with all data from the downloadable files from the Internet Movie Database.