PostgreSQL Insert

Pricing

Pay per usage

Try for free

Go to Apify Store

PostgreSQL Insert

Try for free

This act takes a crawler execution and inserts it's results into a remote PostgreSQL database.

Pricing

Pay per usage

Rating

0.0

(0)

Developer

Petr Cermak

Maintained by Community

Actor stats

Bookmarked

Total users

Monthly active users

5 years ago

Last modified

act-postgresql-insert

Apify act for inserting crawler results into a remote PostgreSQL table.

This act fetches all results from a specified Apifier crawler execution and inserts them into a table in a remote PostgreSQL database.

The act does not store its state, i.e. if it crashes it restarts fetching all the results. Therefore you should only use it for executions with low number of results.

INPUT

Input is a JSON object with the following properties:

{
    // crawler executionID
    "_id": "your_execution_id",

    // PostgreSQL connection credentials
    "data": {
        "connection": {
          "host"      : "host_name",
          "port"      : "port_number",
          "user"      : "user_name",
          "password"  : "user_password",
          "database"  : "database_name"
        },
        "table": "table_name"
    }
}

The act can be run with a crawler finish webhook, in such case fill just the contents of data attribute into a crawler finish webhook data.

Additionally to crawler results, it is also possible to specify a dataset id, to fetch the result from a dataset.

{
    // id of dataset to fetch rows from
    "datasetId": "dataset_id",

    // PostgreSQL connection credentials
    "data": "connection_credentials"
}

Alternatively you can directly specify the rows to be inserted (i.e. not fetching them from crawler execution).

{
    // rows to be inserted
    "rows": [
        {"column_1": "value_1", "column_2": "value_2"},
        {"column_1": "value_3", "column_2": "value_4"},
        ...
    ],

    // PostgreSQL connection credentials
    "data": "connection_credentials"
}

Goodreads Quotes Scraper

runtime/goodreads-quotes-scraper

Scrape quotes from Goodreads is an Apify Actor that retrieves inspiring quotes based on your search term. It navigates through multiple pages of Goodreads search results, extracting the quote text, the author’s name, relevant tags, and like counts.

scraping automation

5.0

Netflix Top 10 Finder

alien_force/netflix-top-10-finder

Discover what's trending on Netflix with ease! This powerful actor fetches the Top 10 movies or series worldwide or by country, complete with detailed stats like views, duration, and hours watched. Perfect for market research, content creation, or staying updated on global entertainment trends!

Alien Force

Netflix Search Scraper

alien_force/netflix-search-scraper

This actor scrapes Netflix titles (movies, series) using advanced filters like search query, actor, genre, release year, and availability. It fetches rich data, including images, cast, IMDb metrics, and episode details for series, all while ensuring fast, reliable results with proxy support.

Alien Force

5.0

Netflix Search Scraper 🎬

easyapi/netflix-search-scraper

Scrape Netflix titles data, get detailed information about movies and TV shows including ratings, availability by country, runtime, and more. Perfect for content analysis and tracking Netflix's global catalog.

EasyApi

MySQL Insert

petr_cermak/MySQL-insert

This act takes a crawler execution and inserts it's results into a remote MySQL database.

Petr Cermak

Microsoft SQL Server Insert

petr_cermak/MSSQL-insert

This actor takes a crawler execution and inserts its results into a remote MSSQL database.

Petr Cermak

Supabase MCP SelfHosted

coupaul/Supabase-MCP-SelfHosted

🔒 Self-Hosted Supabase MCP Server - Enhanced Security Production-ready MCP server for self-hosted Supabase with enterprise security. Features SQL injection prevention, rate limiting, Docker optimization & direct DB access. Tools: database ops, auth, storage, types. Perfect for production!

Paul Roelens

Whois Scraper

salman_bareesh/whois-scraper

This Apify actor retrieves Whois information for a list of domains provided as input. It is built with Python and leverages the `whois` library to perform lookups.

Salman Bareesh

103

TheMoviedb Scraper

shahidirfan/TheMoviedb-Scraper

Introducing TheMoviedb Scraper! This versatile actor extracts rich movie, TV, and celebrity data from TheMovieDB. It offers two modes: use the official API for fast, stable results, or scrape directly without a key. Your complete media data solution.

Shahid Irfan

YouTube Video Scraper

scrapearchitect/youtube-video-scraper

Extract full metadata, engagement stats (views/likes/comments), video chapters, technical specs (resolution/codec), and Kids content filters from any YouTube video/short. Perfect for creators, researchers & parents! 🚀 YouTube Video Scraper