Database

06/11/2024

A Journey From QBasic Random Access Files to PostgreSQL

by Frank Rietta

Dive into the evolution of data storage from the perspective of a seasoned developer. From the raw byte collections of QBasic’s random access files to the sophisticated transactions of PostgreSQL, this post explores the journey through various database technologies. Witness the transformation of data handling as we move from single-user systems to the multi-user, internet-driven databases that power today’s applications.

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.

04/15/2019

How to calculate age in MySQL

by Matt Bettinson

While PostgreSQL has a built in age command, MySQL does not. How do we figure out somebody's age in MySQL?

03/30/2015

Adding a Rake Task for SQL Views to a Rails Project

by Frank Rietta

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

02/11/2014

Reset MySQL Root Password with One Command

by Frank Rietta

One simple command to reset your MySQL root password on Debian/Ubuntu Linux. Don't overthink this one.

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.

04/17/2012