Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails"

Ensuring Data Integrity with Ruby on Rails | REVERB

reverbhq.com 05 Dec '12, 10am

Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails"

Those practices are not only worthwhile but essential ones. It is a shame that so many applications don’t employ them as a common practice just like worrying about SQL-injection attacks. It is even a bigger shame that Rails migrations don’t have built-in support for foreign keys and several other constraints. For instance, in some databases you’ll want your unique constraints to be declared as deferrable, like when using with plugins like acts_as_list and awesome-nested-set. I only think you missed out an important information for those MySQL users out there (although I guess they don’t actually mind about data integrity or they would be using something else). They should never use the MyISAM engine (it used to be the default one until very recently).

Full article: http://reverbhq.com/blog/2012/12/ensuring-data-integrity/

Tweets

@6qat » 20 Dec '12, 7pm
RT @nuodb: Ensuring #Data Integrity with Ruby on Rails [link]
@amzurtech » 12 Dec '12, 4pm
Here is an interesting blog post explaining how to ensure Data Integrity with #Ruby on Rails [link]
@rorguru » 08 Dec '12, 9pm
Ensuring Data Integrity with Ruby on Rails | REVERB [link]
@tayebM » 06 Dec '12, 1pm
ضمان سلامة البيانات مع Ruby On rails [link]
@MurielSalvan » 05 Dec '12, 5pm
Ensuring Data Integrity with Ruby on Rails... very important advices. [link]
@thibaut_barrere » 05 Dec '12, 3pm
RT @pat_shaughnessy: Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails" [link]
@pat_shaughnessy » 05 Dec '12, 3pm
Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails" [link]
@capetown_rb » 05 Dec '12, 10am
Ensuring Data Integrity with Ruby on Rails [link]
@pwnall » 05 Dec '12, 3pm
RT @pat_shaughnessy: Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails" [link]
@zombidev » 05 Dec '12, 3pm
RT @pat_shaughnessy: Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails" [link]
@shr » 05 Dec '12, 3pm
RT @pat_shaughnessy: Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails" [link]
@freiden » 05 Dec '12, 3pm
RT @pat_shaughnessy: Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails" [link]

Ensuring Data Integrity with Ruby on Rails | REVERB

Some essential best practices for using a SQL database with Rails: "Ensuring Data Integrity with Ruby on Rails"

Tweets

Ensuring data integrity

Want to help more women learn Ruby on Rails? Co...

#JavaScipt Ruby on Rails Car Sharing Web App by...

[37s] Bloomberg L.P.: Ruby on Rails Developer

[37s] WorldOne - Sermo: Ruby on Rails Engineer

Freelance Jobs - Telecommute Ruby on Rails Deve...

Hashrocket: Ruby on Rails Developer: Location: ...

RoR developer by jnguyen24: Job Description The...

Ruby is more than Rails

#Java Looking for part time Ruby on Rails devel...

From Python to Ruby: Mind Blown by Rails, the F...

I liked a @YouTube video from @codejobs Aprendi...

12 Spokes is hiring a Ruby on Rails Programmer at

#PHP Ruby on Rails Expert! by MrRamiro29: I am ...

#webdevelopment Ruby on Rails Experts - oDesk: ...