Tip: Database, For 'Event Occurred' Use Bool From Date.
Join the DZone community and get the full member experience.Join For Free
From: http://jamis.jamisbuck.org/articles/2005/12/14/two-tips-for-working-with-databases-in-rails First tip: Iâ€™ve found recently that if I have a boolean field in the database that is being used to mark whether some event occurred (referrals.pending, or feeds.subscribed) it is often more effective to make the field a datetime and record the moment that the event occurred. Then, a NULL can be used to indicate that the event has not yet occurred. Thus, you have referrals.applied_at with a method on Referral like this:
def pending? applied_at.nil? endThis gives you the capability down the road to not only report whether the event occurred, but how frequently over various periods of time.
Opinions expressed by DZone contributors are their own.