How to update the same attributes in several tables with Postgresql and Rails

Question

In order to minimize the number of joins that I have to execute in my application I decided to copy in my database the same field in several tables for example : I have a User, Product and a Wishlist Table.

My Product pages shows the user who created the product, as the wishlists pages which also shows the user who created them.

So I added in my products and wishlists table all the users field needed to show the required informations.

How can I update the users related fields in my Products and Wishlists Table as soon as the user change his information ?

Here is a part of my model :

User Table

Full Name
UserName
Avatar URL

Product Table

Product Name
Product Price
User ID
User Full Name
Username
User Avatar URL

Wishlist Table

Wishlist Name
User ID
User Full Name
Username
User Avatar URL

Thanks in advance for your answers !

would you post your schema.rb file as well as the 3 models?

Xaca Xulu
– Xaca Xulu

2013-04-22 15:27:54 +00:00
Commented Apr 22, 2013 at 15:27 — Xaca Xulu
– Xaca Xulu, Commented Apr 22, 2013 at 15:27

Rebitzele · Accepted Answer · 2013-04-22 15:31:42Z

2

Firstly, by denormalizing the data in the way that you are, you are working against what relational databases are meant to do. They thrive on joins, and having each piece of data appear as few times as possible. So you really want to make sure that this is the schema that you want.

That being said, you can use the basic update_attibute syntax to update any field in any table. So, if a user edited his or her username, you would do:

User.update_attribute(:username, username)
Product.update_attribute(:username, username)
Wishlist.update_attribute(:username, username)

answered Apr 22, 2013 at 15:31

Rebitzele

3,2921 gold badge22 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeremy B Over a year ago

Ok but would this method will be faster than using joins ? or is it the same regarding the performance ? Thanks,

Collectives™ on Stack Overflow

How to update the same attributes in several tables with Postgresql and Rails

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related