Podcast: Play in new window | Download

Tired of the same old database grind? Why not try an Object Relational Mapper.

News/Follow-ups

• 00:38 – Jade likes his tablet again, thanks to Windows 7

Geek Tool

• 04:25 – The perfect Valentines geek tool, Heart Warmer

Webapps

• 07:11 – Ketchup – Super simple meeting agenda creator
• 08:15 - MinuteBase – Collaborate on meeting notes

Topic

• 16:19 – Object-relational mapping
  • What is it?
  • Typical non-ORM work flow
• Pros
  • Less code, just manipulating the objects
  • OOP you are working with objects already
  • Data language is in your language, don’t need to learn new syntax
  • Inheritance
  • Distributed database security
  • Benefit of the knowledge of everyone writing the ORM
  • Database integration abstraction
  • Switch database back-ends with little hassle (depending on ORM)
• Cons
  • Object-Relational Mapping is the Vietnam of Computer Science
  • Poorly designed databases
  • Because you are working strictly with the database, databases usually aren’t optimized
  • Overhead
  • ORMs have a lot overhead that can affect performance
• Examples
  • Ruby
    • ActiveRecord
    • Datamapper
  • Python
    • Django
    • SQLAlchemy
  • PHP
    • CakePHP
    • Doctrine