Writing to the DB via API functions

[jagnani73]

Problem / use case

The documentation specifies that the API functions can't write to the DB. Why is that, and is there a workaround?
I really need to be able to write to the table via an API function

Proposed solution

No response

[kyscott18]

Hi, the reason for that is that the database in ponder is not stateful in the sense that it is completely derived from on-chain state (necessary for reorg handling). Every time a new deployment happens it starts from scratch. So, the only place where the database can be written to is an event handler.

Keep your eye out for 0.9, we are planning on providing an example that shows how to achieve a similar result.

[jagnani73]

That makes sense
Any timeline for the 0.9?

[kyscott18]

No timeline, high priority