Re: [chiPHPug-discuss] Data Models

[Arlo L. <ar...@ar...>]

Hello,

> I worked on a very large system that had a wonderful design for some of their tables that is worth investigating.  Perhaps this works best for Oracle but...
> 
> They make a table let's call it element.
> They make the table with 3000 columns let us say.


Just one table for the whole project? That sounds so simple!

In fact, it reminds me of the MacBook Wheel: http://www.youtube.com/watch?v=9BnLbv6QYcA

(You were being sarcastic, right?) 

> I think I'm probably doing to end up with a hybrid model consisting of a 
> class-based data model with hard coded sql for sticky stuff, and a 
> moderately complex CRUD sql generator to handle basic joins across a few 
> tables.

One more thought is that I've used third-party software where the SQL queries were constructed from so many little pieces that it was impossible to understand how the code integrated with the database. When you want to customize something like that, you end up getting frustrated and just wanting to know where a value comes from already! So in my classes most of the queries are "whole," or at least all the pieces are contained in the same method, so if anyone else needs to modify it they don't have to go on a scavenger hunt through the whole project to figure out how the queries are constructed.

Cheers,
-Arlo

_______________________________

Arlo Leach
773.769.6106
http://arlomedia.com

The killer app for the iPad
http://washboardapp.com