# Plugin to track create, update, delete on certain tables?

**URL:** <https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642>\
**Category:** Rails\
**Created:** [October 21, 2009, 1:24pm UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642 "2009-10-21T13:24:15Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmaxvv](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/85f322/32.png) [@cmaxvv](https://www.ruby-forum.com/u/cmaxvv)\
**Post date:** [October 21, 2009, 1:24pm UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642/1 "2009-10-21T13:24:15Z")

</div>

Hi all

I’d like to start keeping track of who has created, updated or deleted  
certain of our models - eg users, resources, lessons. The ‘who’ would  
generally be simply the id that is in session[:id], ie the current user.  
The table to keep track would most likely have fields for user\_id,  
record\_type, record\_id, transaction\_type and created\_at, or names to  
that effect anyway.

This seems like the sort of thing for which a plugin would already  
exist, but i’ve not managed to put the right terms into google to find  
one. Can anyone point me at one?

thanks  
max

---

<div class="post-metadata">

**Author:** ![cmaxvv](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/85f322/32.png) [@cmaxvv](https://www.ruby-forum.com/u/cmaxvv)\
**Post date:** [October 21, 2009, 1:54pm UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642/2 "2009-10-21T13:54:22Z")

</div>

Brijesh S. wrote:

> Check it out below link  
> [GitHub - collectiveidea/acts\_as\_audited: acts\_as\_audited is now… Audited.](http://github.com/collectiveidea/acts_as_audited/)
> 
> This plugin will keep track of model actions…
> 
> Thanks  
> Brijesh S.

Looks perfect - thanks a lot!  
max

---

<div class="post-metadata">

**Author:** ![cmaxvv](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/85f322/32.png) [@cmaxvv](https://www.ruby-forum.com/u/cmaxvv)\
**Post date:** [October 21, 2009, 1:45pm UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642/3 "2009-10-21T13:45:58Z")

</div>

Check it out below link

> **[GitHub - collectiveidea/acts\_as\_audited: acts\_as\_audited is now… Audited.](https://github.com/collectiveidea/acts_as_audited/)**
>
> acts\_as\_audited is now… Audited. Contribute to collectiveidea/acts\_as\_audited development by creating an account on GitHub.

This plugin will keep track of model actions…

Thanks  
Brijesh S.

---

<div class="post-metadata">

**Author:** ![cmaxvv](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/85f322/32.png) [@cmaxvv](https://www.ruby-forum.com/u/cmaxvv)\
**Post date:** [October 22, 2009, 10:45pm UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642/4 "2009-10-22T22:45:31Z")

</div>

Max W. wrote:

> Just installed acts\_as\_audited, absolutely LOVE it. Fantastic. Thanks  
> again for the pointer, and many thanks to the AAA team. 🙂

If you like that you might also want to take a look at vestal versions.  
This not only allows you to audit changes on models, but also be able to  
actually see what the model looked like in the past. I know in your case  
you’re mostly interested in an audit trail, but vestal versions is  
certainly worth a look if you’re not aware of it.

> **[GitHub - laserlemon/vestal\_versions: Keep a DRY history of your ActiveRecord...](https://github.com/laserlemon/vestal_versions)**
>
> Keep a DRY history of your ActiveRecord models' changes - GitHub - laserlemon/vestal\_versions: Keep a DRY history of your ActiveRecord models' changes

Get a quick tutorial of it here:

> **[\#177 Model Versioning - RailsCasts](http://railscasts.com/episodes/177-model-versioning)**
>
> Short Ruby on Rails screencasts containing tips, tricks and tutorials. Great for both novice and experienced web developers.

---

<div class="post-metadata">

**Author:** ![cmaxvv](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/85f322/32.png) [@cmaxvv](https://www.ruby-forum.com/u/cmaxvv)\
**Post date:** [October 23, 2009, 1:04am UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642/5 "2009-10-23T01:04:29Z")

</div>

Thanks Robert, i’ll check it out.

---

<div class="post-metadata">

**Author:** ![cmaxvv](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/85f322/32.png) [@cmaxvv](https://www.ruby-forum.com/u/cmaxvv)\
**Post date:** [October 22, 2009, 5:46pm UTC](https://www.ruby-forum.com/t/plugin-to-track-create-update-delete-on-certain-tables/177642/6 "2009-10-22T17:46:01Z")

</div>

Just installed acts\_as\_audited, absolutely LOVE it. Fantastic. Thanks  
again for the pointer, and many thanks to the AAA team. 🙂