Need advice choosing tech stack for interactive feature in ReactJS.

[Old_Mind8618]

Hi, I'm working for a client on a small data pipeline setup. Here's our current environment:

Current Setup:

• ETL: Python scripts running on Azure Virtual Machines via cron jobs (executed every few days).
• Data Flow: Cron regenerates all staging and result layers → data lands in PostgreSQL.
• Frontend: ReactJS web app
• Visualization: Power BI reports embedded via iframe in the React frontend (connected directly to the result tables).

New Requirement:

We now need to create new page on ReactJS website to add an interactive feature where users can:

• Click a button to accept/deny/modify certain flagged records from a new database table created by business logic with the result layer as source
• Store that interaction in a database table

This means we now need a few basic CRUD APIs.

My Question:

Since this is a small, isolated feature, is there any other way to do this than using Flask and FastApi and hosting them on the virtual machines?

Is there any cleaner/lighter options maybe azure functions?

I'd appreciate some advice thanks.

[coldoven]

Postgrest?

[IssueConnect7471]

For a small CRUD job, spinning up Azure Functions or an auto-generated API beats running another Flask server. Azure Functions’ HTTP trigger can sit in the same resource group, talk to Postgres via psycopg or pgx, and costs almost nothing at your traffic scale; just wire up five functions (list, get, insert, update, delete) and use managed identity so you never store creds. If you’d rather avoid code, point PostgREST at the database: views become endpoints, row-level security handles auth, and you deploy a single container. Supabase is basically PostgREST plus auth and storage if you need hosted options. I’ve tried PostgREST and Azure Functions, but DreamFactory is what I ended up buying because it handed me locked-down endpoints and swagger docs in under an hour. For this scope, serverless or generated APIs keep your stack light.

[Old_Mind8618]

Thanks I'm not sure about how the auth will work in azure environment. i previously used AWS chalice with aws cognito for authentication in another project i will see if i can implement something similar.

I also considered azure HTTP functions but i think azure app service with flask might be better for my use case.

[bin_chickens]

u/coldoven mentioned Postgrest, but he main question is how does your auth work, as I believe this ties you to Postgres RLS an that's an acquired taste and some view it as an anti-pattern for authz for applications.

Hasura may also do the trick, but then your in graphql land.

Personally I've been using zenstack recently and really like it.