pg_cron VS Express

[Postgres Extensions] pg_cron 1.5.2 (new projects only) now supports sub-minute schedules. PR

(Your PostgreSQL installation might already have pg_cron available, but if not, you would need to install it)

I’d set up citusdata/pg_cron in 14, so I’ll need to set that up in 15 as well.

Functions can be executed via a database query or on a regular schedule. Trigger functions are a special type of function that are covered in a previous article. They provide a way to execute an action based on a database event.

* 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.

A low-level alternative is using a PostgreSQL-side facility like https://github.com/citusdata/pg_cron - this, however, requires installing a PostgreSQL extension.

If you just want scheduling queries, you can use this https://github.com/citusdata/pg_cron

Express: A lightweight framework for building web applications.

Now, we will create API using expressjs. When we created application using --ssr flag, the Angular CLI already took care of installing expressjs for us.

First, we import express. The Express framework allows us to create routes that will respond to webhook POST requests and serve an HTML file when a GET request is made to the root of the site.

Basic Knowledge of Express

Express.js Documentation

In the JavaScript ecosystem, there are guides for enabling SAML-based enterprise single sign-on in AdonisJS, Express.js, Next.js, Remix, and React with an Express.js backend.

Starting off strong with Express.js, the cool kid on the block for building web apps. It's lightweight, flexible, and doesn't throw a tantrum when you ask it to scale. With Express, you can handle HTTP requests like a pro, play around with middleware, set up routes without breaking a sweat, and render views that make your app look stunning. Big names like Netflix and Uber are already on board, and if it's good enough for them, it's definitely worth a peek.

express - one of the most popular middleware tools, lightweight and easy to learn. docs

Now we can install both Express and Socket.io libraries: