The :include and :joins options for the find method can be a little confusing because they are so similar. In this episode I show specifically when to use which option. http://railscasts.com/episodes/181-include-vs-joins
Igal Koshevoy of Pragmaticraft speaks about Comparing Non-Relational Databases: MongoDB, Tokyo Tyrant, CouchDB at the November 2009 OpenSQLCamp in Portland, Oregon. [youtube pVbxdH-ldpg]
Sheeri K. Cabral of the Pythian Group goes through the meanings of INNER, LEFT/RIGHT OUTER, CROSS, NATURAL joins, how to do a FULL OUTER JOIN in MySQL, and what STRAIGHT_JOIN means. She also goes through how to recognize when you want those types of joins, and best practices for the …
Some might think of DataMapper as a better, faster, competitor to ActiveRecord. However, they would be missing on of its greatest strengths. At its core, DataMapper provides a uniform interface on top of ANY persistance layer. All thats needed is a simple adapter class that can translate the native persistance …
This video shows a quick example of creating a working CRUD application on top of PostgreSQL using JBoss SEAM (Java Server Faces, EJBs, and Hibernate). In 5 minutes, you use the SEAM framework to build a basic application including reverse engineering the database schema to create boiler plate code for …
MySQL data types do not support the SQL standard WITH TIME ZONE attribute. How do you store times in MySQL to efficiently show your customers times in their own time zone? The TIMESTAMP data type will show different times if you change the server’s time zone. This presentation covers all …
