Show HN: Statetrace – Annotated Audit Trail for Postgres and MySQL

https://www.statetrace.com

by hansonkd13 • 5 years ago

21 5 5 years ago

fatlungs• 5 years ago

how does the timetravel feature work?

hansonkd132• 5 years ago

Time Travel works by generating a SQL statement or a CTE, which transforms the raw audit events into a snapshot of the table at a point in time with extra columns for the annotations. This feature is currently exposed on the enterprise product through the UI (which exposes a SQL explorer for your warehouse), but we are slowly shifting those features into the GQL API of core (give a table name, get a SQL model). Time travel works on the transaction level so you don’t lose any fidelity.

throwaway888abc2• 5 years ago

Does it work with Wordpress / Drupal ?

hansonkd132• 5 years ago

Short answer yes! Long answer: Statetrace works at two different levels. The first is to record the raw changes without annotations. Statetrace works 100% with any framework at this level.

The next level is to record with annotations. Currently we don’t have the annotation support for wordpress/drupal but it is something very easy to add.

throwaway888abc2• 5 years ago

Thank you

Show HN: Statetrace – Annotated Audit Trail for Postgres and MySQL

Related Stories