Today I helped a client wrestle with a database task which concluded: . . . We'll have to watch out inventing new "fake" customers because one day there may be a real customer with our made up ID 😦 This is a problem in lots of apps, but not in Rails. Rails enforces the "best … Continue reading A Benefit of Rails: Surrogate Keys
Tag: database
Yes, Rails does support case-insensitive queries
They're unfortunately just a little buried and a little undocumented. And so conventional wisdom is that Rails doesn't do case-insensitive finds. But in fact it does: Example 1: Find all the statutes whose name begins with texas, case-insensitively: Example 2: Same query, using the excellent Squeel gem which makes this a little nicer: Results: Both examples generate … Continue reading Yes, Rails does support case-insensitive queries
It is supremely important that we ensure our data is safe. . .
. . . it is supremely important that we ensure our data is safe, consistent and reliable. We can dramatically increase these factors by taking full advantage of the tools at hand. Yes. This is the most critical, important task in software development. A great set of posts, Coding Rails with Data Integrity by Jay … Continue reading It is supremely important that we ensure our data is safe. . .