Re: [Tsheetx-developers] Relational Database

[David T. <tom...@us...>]

Scott, basically you're right, we would need to specify mySQL and InnoDB engine for all TSNG installations, and what is the gain in our case? We are like 90% of all LAMP projects, in that we use a DB just for persistency and not for transactional safety or integrity.
 
The main relation we have is like a dependancy tree - client<-project<-task<-entry - and restrictions will just make it harder to delete something higher in that tree (clients with projects cannot be deleted). An alternative to restrictions is sensible defaults, when a client is deleted then his projects get assigned to No_client(0). But since deletion is not a common use case, we haven't 
 
The other main set of relations are to do with the users, and admittedly this is not clean yet (user_id is defined but not really used). Here there is the problem of deleting users, for which, when we discussed it before, it seems that the best answer is to not delete users, but set them as inactive.
 
So my vote would be -1, never touch a running system.
Sorry 


Date: Wed, 9 Mar 2011 15:34:34 +0000
From: sco...@gm...
To: ma...@rw...
CC: tsh...@li...
Subject: Re: [Tsheetx-developers] Relational Database

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


------------------------------------------------------------------------------ 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