since 1999

Best Data Type to store Money in MySQL?

When handling currency in MySQL, use DECIMAL(13,2) for general use and DECIMAL(13,4) if GAAP Compliance is needed.

Storing currency in PostgreSQL

There are different ways we can store currency in PostgreSQL, this blog post will cover the money and numeric type.

Adding a Rake Task for SQL Views to a Rails Project

I add and update SQL views to my databases with 'rake db:views'; it's wonderful!

How to use SQL views to Build Reports with Ruby on Rails

Reports can be complex to develop. Sometimes SQL views help us rationalize these complex reports. Rails doesn't ship with SQL view support by default, but the Ruby Gem Scenic is very effective at utilizing SQL Views in Rails.