I’m currently scraping real estate listings, and my workflow is a mess. I scrape the data, send it to a webhook on Make.com, and then Make inserts it into my local PostgreSQL database.
I’m burning through my Make task limits, and it feels silly sending data to the cloud just to route it back to my local network. Can RTILA X write directly to my database?
Hey @datascout! You can absolutely ditch Make.com for this. This is exactly why we built the Python Relay sidecar into RTILA X.
Because RTILA is a local-first architecture, our Python Relay runs directly on your machine right after the scraping engine finishes. You just add a PostgreSQL trigger to your project.
To pass your scraped data into the SQL query, you use our variable substitution syntax. If your dataset has a column called price, you just write your query like this:
INSERT INTO listings (title, price) VALUES ('{title}', '{price}');
The relay will automatically substitute the extracted data for each row. And don’t worry about overwhelming your database - our relay caches the database connection and pings it to ensure it’s alive, so it handles thousands of rows incredibly efficiently.