SQL

The SQL is Never as Good as the Original

Writing in SQL can be daunting at first, but the more you practice the more it seems like it’s its own programming language...

Jun 24, 2014 on SQL  0

Three Tables Are Better Than Two

In SQL, you can't have two tables that have each other's foreign key, you must use a third table to hold the foreign keys of the relationship...

Jul 10, 2014 on Rails Ruby ActiveRecord SQL  0

Raw SQL on Rails

ActiveRecord is fantastic, but sometimes if you are doing complex joins and such, you may need to move away from ActiveRecord and write raw SQL...

Oct 15, 2014 on Rails Ruby ActiveRecord SQL  1

Reduce Your SQL Queries With a Counter Cache

Counter caching is a technique to reduce the number or SQL queries when attempting to call count on a resources' association...

Nov 17, 2014 on Rails Ruby ActiveRecord SQL  0

Advanced Searching With SQL

Over on the left, you see that there is a nice little search box to search through my posts...

Jan 09, 2015 on ActiveRecord SQL  0

Using Transactions with Active Record

<span>A transaction is a database feature where you can create, update, or delete multiple records from a database and if just one of them fails, everything ...

Mar 06, 2015 on ActiveRecord SQL SoftwarePatterns CleanCode MVC  0