Luis Fernando De Pombo

Given all the information you provided here, I agree with your conclusion to make aurora tables within rds

Currently paused since the default rate limiter for API of `api_gateway` is below 1 per second for certain endpoints. Delete is 1 request every 30 seconds per account. https://docs.aws.amazon.com/apigateway/latest/developerguide/limits.html

API gateway is supported by the cloud control API. https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/AWS_ApiGateway.html We did an evaluation on cloud control some time ago - https://github.com/iasql/iasql-engine/pull/343/files#diff-66957467e5df44140fe1d9bf8c53b06bbe765b4bc26a9202f56a937a76b75f3f. We should test if cloud control has the...

Probably something like - [ ] Triggers on all our tables that inserts into a `iasql_staged_changes` table https://dba.stackexchange.com/questions/241173/postgresql-trigger-to-keep-track-of-table-changes - [ ] Have the `iasql` service in the engine go off...

> * [ ] Triggers on all our tables that inserts into a `iasql_staged_changes` table https://dba.stackexchange.com/questions/241173/postgresql-trigger-to-keep-track-of-table-changes Maybe we can do something like this to automate this https://github.com/graphile/worker#example-one-trigger-function-to-rule-them-all. Not using graphile...

We should keep this reddit discussion in mind https://www.reddit.com/r/devops/comments/u3b3wf/comment/i4o89s9/. Apparently Pulumi by default does not check the state of the cloud as this issue is suggesting we do too, while...

Ah! I think I get it 👍

I think updatable views do not work across multiple tables. Perhaps the way forward would be with two-way triggers or somehow with rules hmm

so a two-way trigger would need a [trigger depth check](https://stackoverflow.com/a/32759695) or it would recurse forever, but come think of it a one-way trigger from the high level table is probably...

Proof of concept of two-way trigger working using a very simple example! ```sql drop table if exists example; drop table if exists example_simplified; create table example_simplified(id integer UNIQUE NOT NULL,...