search

phenopolis / phenopolis_genomics_browser

Python API and React frontend for the Phenopolis Genomics Browser
https://dev-live.phenopolis.org
MIT License
31 stars 2 forks source link

implement hipaa compliant audit trail #21

Open pontikos opened 4 years ago

pontikos commented 4 years ago

Implement audit trail. Backup and archive table every few days.

http://blog.appliedinformaticsinc.com/implementing-hipaa-compliant-audit-trails-using-sqlalchemy-orm-queries/

IsmailM commented 4 years ago

https://github.com/onecodex/chrononaut

IsmailM commented 4 years ago

https://github.com/kvesteri/sqlalchemy-continuum

pontikos commented 4 years ago

Whether or not we stick to sqlalchemy it's important to have a log of updates on the individual table (and related tables) of the db. Tables that need to be audited in the new schema we are designing are: