Hey guys,
I would like to contribute with relevant information according to my experience in software development. Something I noticed interesting about this feature is that it is related to the PostgreSQL database feature, there is a table scheduling feature. Before checking this code, please see the documentation here: pg_cron. But before that, I wanted to say some interesting observations. I find this feature useful for these reasons:
1. “You can limit the amount of data that will be stored by yourself”. This idea of mine did not come from my head, there is a very interesting technical discussion here: Block row or column information or modification history, Reversion ( record history ), Row change history - idea for a free plan, Editing history. From the user’s point of view, the user could define the time in which the data will be repeated, stored, visualized, edited or changed. There are currently no nocode databases that have this feature and this would make Baserow even more popular. What do you all think of this idea?
2. From an “implementation” point of view, perhaps we can use Zapier as an alternative to repeat, change, delete certain data with some automation. But this is interesting from the point of view of greater privacy, security and anonymity. And because this would be an alternative or solution to the end-to-end encryption problem in Baserow: Does Baserow use end-to-end encryption?. In other words, only people can view the data with certain permission, use and with a specific and defined time. For example, from a “technical standpoint”, there are PostgreSQL extensions that allow for this.
In that case, it would be something + or - like this:
-- example 1: test
SELECT cron.schedule ('Loading Data Warehouse', '20 0-23 * * *', 'select dwh.load_dwh();');
-- example 2: delete old data on Saturday at 3:30am (GMT)
SELECT cron.schedule('30 3 * * 6', $$DELETE FROM events WHERE event_time < now() - interval '1 week'$$);
2.1 What do you all think about using pg_cron for this feature?
2.2 I would like to know if it would be possible to schedule a select in the Baserow for field or table information. would it be possible to schedule a select in the Baserow for field or table information? Would it be possible to filter certain data or lines according to a time in Baserow?