Ruby - updating large amounts of data into Postgres DB on Heroku

Question

I have a Ruby application Postrgress DB on heroku. Some of the data is was migrated incorrectly. I want to update the data on about 5 thousand rows. I do not want to blow the DB away and remigrate. What would be the best way to do this. I have update small amounts of data using the active record type sql but not sure for a large amount.

thanks in advance

Maggs

Five thousand rows shouldn't be a problem.

zero323
– zero323

2013-10-22 05:18:02 +00:00
Commented Oct 22, 2013 at 5:18 — zero323
– zero323, Commented Oct 22, 2013 at 5:18

whyu · Accepted Answer · 2013-10-22 05:20:16Z

2

It really depends on how many fields or what type of data you specifically you are trying to change.

Are your fields changing specifically for each one or are you able to run a loop to iterate through each row to update the value? Please be more specific in terms of the data and what kind of editing you are trying to do.

answered Oct 22, 2013 at 5:20

whyu

351 silver badge6 bronze badges

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

1 Comment

maggs Over a year ago

all individual values. I am not sure what you mean by what type of editing so I am not sure if this will answer your question: updating an integer value which I have in a csv file and to replace the existing value which I pulled down from online

Collectives™ on Stack Overflow

Ruby - updating large amounts of data into Postgres DB on Heroku

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