No credit card required

SQL Query

useful-tools/sql-query

Try for free

No credit card required

Run SQL queries over Apify Platform (currently supports only Datasets).

SQL Query Actor (PoC)

Actor for performing SQL queries over Apify platform.

Example for selecting aggregated information from dataset:

1SELECT
2   country, city, COUNT(*) as amount
3FROM
4   `jepxmCkXTBG5buxxx` -- id of Dataset
5GROUP BY
6   country, city
7SORT BY
8   country ASC, city ASC

Results are stored in to default Dataset of the run.

TODO:

load table optimizations - only used fields + parallel the loading.
Better Data-type determination (date, numbers, integers, etc...).
implement system tables - to be able to select Runs based on actors etc.
migrate to PostgreSQL - to be able to run PL/pgSQL scripts.

Developer

Useful tools

Actor metrics

1 monthly user
3 stars
100.0% runs succeeded
Created in Nov 2023
Modified 9 months ago

Categories

Developer tools

SPOTIFY Explorer

jupri/spotify

Scrape SPOTIFY.COM

cat

Indeed Scraper

misceres/indeed-scraper

Scrape jobs posted on Indeed. Get detailed information from this job portal about saved and sponsored jobs. Specify the search based on location with the output attributes position, location, and description.

Misceres

3.1k

Google Jobs Scraper

epctex/google-jobs-scraper

The most comprehensive Google Jobs Scraper ever! Extremely configurable, highly customizable, and blazing fast. Retrieve salary, social links, apply links, and all detailed sections. Both for data retrieval and API Integration. Easy use without any limits!

epctex

Totaljobs Scraper

lexis-solutions/totaljobs-scraper

The Totaljobs scraper is a web scraping tool that retrieves job postings from Totaljobs, a job search website in the UK.

Lexis Solutions

Free GPTs Scraper

seadapp/free-gpts-scraper

Gets you GPT data from Openai. Download your data as JSON, HTML Table, CSV, Execl, RSS Feed

Seadapp

Glassdoor Scraper

radeance/glassdoor-jobs-scraper

Extract millions of job listings and detailed company information from Glassdoor. Scrape salaries, ratings, skills, keywords, location and many more. Blazingly fast, reliable, and high-quality curated data. Easy to use and extremely efficient.