django AuditTrail和Reversion [英] django AuditTrail vs Reversion

问题描述

我正在开发一个新的网络应用程序，我需要将任何更改的数据库存储到审计表。这种审计表的目的是，以后在真实的物理审计中，我们可以确定在一种情况下发生了什么，谁编辑什么，什么是db的状态在例如时间。复杂计算。
所以大多数审计表将被写入并且不被读取。

1. AuditTrail - 简单，这就是为什么我倾向于它，我可以理解它单个文件代码


2. 回复 - 看起来很简单，但可以使用


3. rcsField 似乎非常复杂，对我的需要太多了

我没有尝试过任何这些，所以我想知道一些真实的经验，我应该使用哪一个。例如一个更快使用更少的空间，易于扩展和维护？

解决方案

正如我在我的问题rcField说的，对我的需要，这很简单，我想存储任何更改，我的表，可能会回来以后的那些更改生成一些报告。

所以我测试AuditTrail和Reversion
Reversion似乎是一个更好的全功能应用程序，有许多功能（我不需要），也就是我知道它保存数据在单个表中的XML或YAML格式，我认为

1. 将在单个表中生成过多的数据


2. 读取该数据我可能无法




在这一点上，AuditTrail会为每个表生成一个相应的审计表，因此更改可以是跟踪很容易，每个表数据少，可以很容易地操作和用户报告生成。





所以我要使用AuditTrail。




I am working on an new web app I need to store any changes in database to audit table(s). Purpose of such audit tables is that later on in a real physical audit we can asecertain what happened in a situation, who edited what and what was the state of db at the time of e.g. a complex calculation. So mostly audit table will be written and not read. Report may be generated though sometimes.

I have looked for available solution

1. AuditTrail - simple and that is why I am inclining towards it, I can understand it single file code.
2. Reversion - looks simple enough to use but not sure how easy it would be to modify it if needed.
3. rcsField seems to be very complex and too much for my needs

I haven't tried anyone of these, so I wanted to know some real experiences and which one I should be using. e.g. which one is faster uses less space, easy to extend and maintain?

解决方案

As i stated in my question rcField seems to be to much for my needs, which is simple that i want store any changes to my table, and may be come back later to those changes to generate some reports.

So I tested AuditTrail and Reversion Reversion seems to be a better full blown application with many features(which i do not need), Also as far as i know it saves data in a single table in XML or YAML format, which i think

1. will generate too much data in a single table
2. to read that data I may not be able to use already present db tools.

AuditTrail wins in that regard that for each table it generates a corresponding audit table and hence changes can be tracked easily, per table data is less and can be easily manipulated and user for report generation.

So i am going with AuditTrail.

这篇关于django AuditTrail和Reversion的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！