database Category
10/24/2019
MySQL Decimal Data Type
by Alex Piechowski
The MySQL decimal (A.K.A. numeric) data type can be used to store the exact numerical value with a fixed point decimal. The Syntax of MySQL's decimal is "DECIMAL(precision, scale)".
06/04/2019
Best Data Type to store Money in MySQL?
by Alex Piechowski
When handling currency in MySQL, use DECIMAL(13,2) for general use and DECIMAL(13,4) if GAAP Compliance is needed.
01/28/2019
Storing currency in PostgreSQL
by Christopher Choi
There are different ways we can store currency in PostgreSQL, this blog post will cover the money and numeric type.
11/28/2013
How to use SQL views to Build Reports with Ruby on Rails
by Frank Rietta
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.