UseSQL | Extract information from websites using SQL

1 min read Original article ↗

How easy is it to get started?

As easy as pie. Extract data from website in only a couple of steps with the very easy to use interface of SQL. It only takes a couple of minutes.

Hacker News website used in the example

To get started find the website you want to extract information from. It may be helpful to explore the generated html source in your web browser's developer tools.

SELECT 
    '.rank' as rank,
    '.titleline > a' as title,
    '.titleline > a@href' as website
FROM "https://news.ycombinator.com/"

Checkout live demo → here. ←

Add a mapping to the elements you want to extract to your SELECT query. You should be able to use JQuery selectors to identify the data you want to extract. See a cheat sheet here.

STEP 3

Integrate into your application

Next choose your data format, and integrate it into your solution using our API or SDK. Feel free to take a look at our docs.

Sit back & Drink coffee

Enjoy the extra time saved by automating this! Get started now!