Re: [Tsheetx-developers] Relational Database

[Scott M. <sco...@gm...>]

I know just enough DB theory to be dangerous here, so please correct me
where needed.

My understanding is that for the Foreign key constraints to work, we would
need to write "triggers" so the database knows what do do when certain
events happen (deletion, addition, change of records).  I believe these
"triggers" aren't exactly perfectly portable between different databases, so
we would have the need to have different triggers written for whatever
databases we decide to support.

Really our system is pretty darned simple from a database perspective, so,
my question would be, is it worth the development time to tackle making the
system truly relational?  I'm currently on the fence, but I'm leaning toward
no :-)  But, if you think it's worth it, and want to do the heavy lifting,
I'll certainly support that decision.

-Scott

On Tue, Mar 8, 2011 at 11:57 PM, Mark Wrightson <ma...@rw...>wrote:

> Hi All
>
> I have recently started looking into InnoDB Foreign key constraints to
> create truely relational databases.  Has anyone considered doing this
> for tsheetx?  Is there a reason why we cannot or should not?
>
> I have recently found a tool in PHPMyAdmin called 'Designer' that looks
> pretty cool, and shows the links between tables much like an OO class
> diagram does.
>
> Thanks
> Mark Wrightson
>
> --
> _____________________________________________
>
> Mob:  07725 695178
> Email: ma...@rw...
>
>
>
> ------------------------------------------------------------------------------
> Colocation vs. Managed Hosting
> A question and answer guide to determining the best fit
> for your organization - today and in the future.
> http://p.sf.net/sfu/internap-sfd2d
> _______________________________________________
> Tsheetx-developers mailing list
> Tsh...@li...
> https://lists.sourceforge.net/lists/listinfo/tsheetx-developers
>