kimbo_king — 2014-03-09T07:44:03-04:00 — #1
First off I have no idea which are to post this in so I apologise if its the wrong area of the forum
My question relates to data from external websites etc
How do I go about pulling data from an external website so I can show it myself. Preferably via SQL?
I say preferably via SQL so I can use search terms etc (IN ('123', '1234') etc....
I don't know where to start in terms of tutorials etc.... I dont know what to google or anything
Discalimer: This is all above board, the dat I want to pull is public data and is encouraged to be shared.
scottradcliff — 2014-03-10T16:24:52-04:00 — #2
It sounds like what you are looking for is Web Scraping.
SQL is not really an option for this. Someone would have to give you access to their database in order to use SQL.
However you do this, you will have to parse markup based on a response. [Nokogiri is the standard for Ruby, but something like [URL="http://curl.haxx.se/docs/manpage.html"]cURL](http://nokogiri.org/) would allow you to fetch the source of a URL and then you can parse it however you like.
spacephoenix — 2014-03-10T17:45:21-04:00 — #3
Does the website have an public api available that you could use? If not try contacting the owner of the website concerned.