I am creating a project where i need to use my smart contract to add data to the storage but in a programatically delayed way:
I am using web3 in my nodejs server, and i want to create the transaction as usually, using web3 but delay or halt the transaction broadcast until I want to send it.
My idea is to get the raw transaction and save it in an off-chain database as the string it is. then when I want to broadcast the transaction I can get it from the database and use web3 to send it as a raw transaction.
So first i want to know if my idea is achievable, and is there anyway i can save transactions inside my node instead and then send them programatically because the idea of saving transactions in relational databases is not really appealing and seems unsecure.