Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Hot answers tagged

8

After some additional search, I found the worked link among of lots, which point to 404 pages. The worked ones are: — https://s3.amazonaws.com/rjurney_public_web/images/enron.mysql.5.5.20.sql.gz — http://www.ahschulz.de/pub/R/data/enron-mysqldump_v5.sql.gz Detailed information about these datasets: — http://hortonworks.com/blog/the-data-lifecycle-part-one-...


8

No, there are no SQL versions of the XML dump files. The page Data dumps/Tools for importing on meta.wikimedia.org describes how to work around that: You can either use ImportDump.php to import the XML file directly (apparently suitable only for small wikis), or you can use a tool like mwdumper to convert the XML into SQL and then import that.


6

Below are a couple of sites that have API access to bible text. http://bibles.org/pages/api - This site has a well-documented API and serve a number of versions. They may have a version that suits your purposes - although NIV is not listed it is mentioned in the API documentation. http://labs.bible.org/api_web_service - This site has what looks to be a ...


5

Regarding your first question, Open Product Data provides guidelines for data importing which suggests using software such as BigDump to handle importing the data. Now, to answer your second question: Outpan is my personal project focusing specifically on creating a free database of all barcoded products. The database currently includes more than 18 ...


4

You might be able to create an SQL DB by using FERC Enron XERA web application: http://fercenron.omega-caci.com/default.html (user guide). You'd use the search feature of XERA based on fields, and then export the result to a delimited file, then convert to SQL database for additional queries.


4

Not exactly SQL but SPARQL: NL-SPARQL: A Dialog-System Challenge Set for Converting Natural Language to Structured Queries NL-SPARQL is a data set of natural language (NL) utterances to a conversational system in the movies domain and corresponding queries to Freebase in SPARQL. This dataset was collected via Crowdsourcing as described below. The ...


4

Here is some information on how to get closer to what you might be looking for. One well-organized source for information like this is a site called GeoNames.org. GeoNames has a number of APIs as well as downloads ("dumps") which are discussed on their export page. For your use case, an export seems to make sense. Each country's POIs (points of interest) ...


4

looks like possibly same question on stackoverflow: https://stackoverflow.com/questions/12835572/how-to-use-pure-sql-for-exploratory-data-analysis most results i found recommend using R http://www.renzeconsulting.com/presentations/exploratory-data-analysis-with-r.pdf looks like these two solutions cost: http://science.nature.nps.gov/im/units/arcn/...


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 ...


3

First you will need to define the schema of your final database and determine how you will map each file to your schema. Then I recommand using ETL tool (Extract Transform and Load) such as Talend Open Studio (TOS) or Penthao (both are open source solution). Using such tools will allow you to: automate the process (and not process each file individually) ...


3

you can search data.gov, this search returns over 300: http://catalog.data.gov/dataset?q=MySQL&sort=score+desc%2C+name+asc and this search within datasets hosted by data.gov reveals 12: http://www.data.gov/search-results?group=site&q=MySQL


3

Should these help you ! Bibles in JSON & XML Bibles versions in SQL format


3

Disclaimer: I am the author of below github projects. Two very good (and complete) sources are: https://github.com/scrollmapper/bible_databases : This has many database formats including all three formats you are inquiring of. https://github.com/scrollmapper/bible_databases_deuterocanonical : This is a newer continuance of the bible databases, but ...


2

If you know where the end of each query is, then you can add the semi-colon with a command line parsing tool like 'sed'. See here for details about 'sed' on Mac OSX. You can read about how to use 'sed' to add a semicolon here. To know the exact command, I'd have to know the file details. If each query is on one line, then it's quite straightforward. If ...


2

https://github.com/godlytalias/Bible-Database also have a good database collection


2

There is already an answer to this question, by @RSFalcon7. You will find the whole explanation on this Wikipedia page about dumps available in XML or SQL format. The data about revisions in SQL seems private though (no link provided for direct download), but I couldn't figure what this implies. It does not seem available in Persian unfortunately either. ...


2

While your own solution to this dilemma is correct, it might help someone else to explain why your posted solution works, especially if they used another tutorial using another approach to scrape MLB game data, one that doesn't give you the URL of the webpage identifying the location from where game-specific data was scraped. Initially, I struggled with the ...


2

The following SQL statement works fine to merge the tables. SELECT * FROM atbat INNER JOIN pitch ON (atbat.num = pitch.num AND atbat.url = pitch.url)


2

The Million Song Dataset has this information as well as other features about the song itself. You can download the entire 300GB file as a flat file, or download a 1% sample. The full field list can be found at their FAQ, and they have code snippets for working with the data in MatLab, SQL, or other programs.


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/...


2

You can find homework assignments that are submitted as forks for a MOOC Github repo. In this case, you'll find multiple SQL statements for the same question. The SQL style will be a little biased because all the students are following the same course. An example: TelerikAcademy - Database Systems Course Homework assignment for Intro SQL Then find forks ...


1

DMOZ is a directory and naturally is great for tasks like this. You're going to have to do all of the leg work though: Search DMOZ for Australia + Hotel


1

Based on this stackexchange question, I found the page: Creating the Sample Database in Oracle 11g Release 2 (Other instructions) Also, if you are using XE, there is a demo DB ready to play with.


1

I wrote Wik2dict a decade ago to turn MW database dumps into the dict format. It's python code. Could help you figuring out some things. The best way to convert this xml into mysql is by using mediawiki's xml import functionality. If you don't have a good reason to import the dump into mysql it's better to avoid it as it's extremely slow with such a large ...


1

I found some hints for the schema here https://meta.wikimedia.org/wiki/Help:Export#Export_format To read manually the XML, try using a viewer like: http://www.readfileonline.com/ http://www.swiftgear.com/ltfviewer/features.html (windows) head -n [numberoflines] dump.xml (gnu/linux terminal)


Only top voted, non community-wiki answers of a minimum length are eligible