Pulling Cloud API data to PostgreSQL server (Supabase)

This page summarizes the projects mentioned and recommended in the original post on /r/PostgreSQL
Postgresql Cron periodic-jobs Scheduler

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured

  • pgsql-http

    HTTP client for PostgreSQL, retrieve a web page from inside the database.

    • * extraction and loading: the psql-http PostgreSQL extension which is available in Supabase (but not all services like AWS RDS). Not sure how it works with OAuth but something to look into. * automation: use pg_cron to automate the ingest. * transformation: leverage Postgresql JSON functions.

  • pg_cron

    Run periodic jobs in PostgreSQL

    • * extraction and loading: the psql-http PostgreSQL extension which is available in Supabase (but not all services like AWS RDS). Not sure how it works with OAuth but something to look into. * automation: use pg_cron to automate the ingest. * transformation: leverage Postgresql JSON functions.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • 🏺Database Architecture - History Over State

    1 project | dev.to | 2 Apr 2023

  • Edge Functions or Database Functions?

    3 projects | /r/Supabase | 31 Jan 2023

  • Upgrading to PostgreSQL 15 on Mac OS

    1 project | dev.to | 11 Jan 2023

  • How to : trigger a MV refresh after another MV refreshed ?

    1 project | /r/PostgreSQL | 2 Sep 2022

  • Como agendar execução de consultas e comandos pelo PostgreSQL no RDS

    2 projects | dev.to | 7 Feb 2022