Postgres Auditing in 150 lines of SQL



Data auditing is a system that tracks changes to tables' contents over time. PostgreSQL has a robust set of features which we can leverage to create a generic auditing solution in 150 lines of SQL. Auditing is particularly useful for historical analysis.

from Pocket https://supabase.com/blog/2022/03/08/audit
via IFTTT

このブログの人気の投稿

温暖化で海面上昇するとどこが水没するか一発で分かる地図「Flood Maps」レビュー、未来の日本の海岸線はどうなっているのか?