Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How revisions control works on quora? Database design

Tags:

version-control

ruby-on-rails

relational-database

database-design

Well, I've seen some plugins to create a versions table to keep track of modifications on specific models, but cant do easily like quora shows

Changing a topic photo on quora

What I have so far is a table like that:

  • id
  • item_type: especifies what model revision refers: "Topic"
  • item_id
  • event: if it was: "edited, added, reverted, removed"
  • who: who triggered the event
  • column: What column in "Topic" the value has changed. "topic.photo_url"
  • new: new value: "http://s3.amazonaws.../pic.png"
  • old old value: ""http://s3.amazonaws.../oldpic.png"
  • revision_rel: points to the past revision
  • timestamp

enter image description here

Someone could give me some help and guidelines with this design? Im worried about performance, wrong columns, missing columns, etc

id  | item_type | item_id |  event  |    who    | column |   new      |    old     | revision_rel |  date
________________________________________________________________________________________________________
1   |   Topic   |    2    |  edit   |   Luccas  |  photo | pic.png    | oldpic.png |    null      |  m:d:y
2   |   Topic   |    2    |  revert |   Chris   |  photo | oldpic.png | pic.png    |      1       |  m:d:y
like image 377
Luccas Avatar asked Jun 25 '12 05:06

Luccas

People also ask

How does version control system work?

Version control enables multiple people to simultaneously work on a single project. Each person edits his or her own copy of the files and chooses when to share those changes with the rest of the team. Thus, temporary or partial edits by one person do not interfere with another person's work.

What is version control system Quora?

A Version Control System is a system that records all the changes made to a set of files or single file. A VCS allows you to call a specific version of a file whenever it is required. This helps in making sure that all the team members of a team are working on the most recent version of the file.

What is database version control?

Database version control is the practice of tracking every change made to the database by every team member. Like application version control, database version control acts as a single source of truth. It empowers you with complete visibility, traceability, and continuous monitoring of the changes in your database.

What are the three types of version control?

The types of VCS are: Local Version Control System. Centralized Version Control System. Distributed Version Control System.

1 Answers

There are some gems available that already do what you are looking for. Have you looked into:

Take a looks at existing gems: https://www.ruby-toolbox.com/categories/Active_Record_Versioning

I am using audited (previously acts_as_audited) for something very similar: https://github.com/collectiveidea/audited

like image 189
Ylan S Avatar answered Sep 22 '22 02:09

Ylan S
Sign in to Comment

Related questions

association id not getting set using accepts_nested_attributes_for and decent_exposure
Embedding your site's functionality into anothers with Rails 3 (XSS vs iframes)
Issue with Rails Content_for / yield - duplicated content
Rails 3.1.1 HTTP streaming with Apache + Passenger
Resourceful routes, but with the #create action using GET instead of POST
More objects in memory with same id?
Custom keys for Mongoid association
Rails - How to change log level for ActionController::RoutingError
Rails Bundler gems install
Sprockets::Helpers::RailsHelper::AssetPaths::AssetNotPrecompiledError in app using engine, nginx, passenger
how to build a openid provider with ruby on rails
API Access with Devise Authentication - Best Practices?
script/server custom_require.rb:36:in `require': cannot load such file -- test/unit/error (LoadError)
I18n in Rails 3 with a admin namespace
Use rails_xss on only certain pages
Why is url_for returning /assets for undefined routes?
oink logs command not working on heroku
Rails: Is the devise gem secure?
Why isn't Devise + Omniauth callback hitting the correct controller?
How do you test a submit button being disabled after clicking in capybara?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!