Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-13 Thread Robert Treat
On Wednesday 13 April 2005 01:21, Jinane Haddad wrote: > Thanx guys for the advices. > > i think i will have to find some "POLITICAL" approach in order to > restructure the existing database, which i am not so good at but worse > trying. Note that even the code is Bad (they are using PHP for a big

Re: [GENERAL] What are the consequences of a bad database design (never seen

2005-04-12 Thread Jinane Haddad
Thanx guys for the advices. i think i will have to find some "POLITICAL" approach in order to restructure the existing database, which i am not so good at but worse trying. Note that even the code is Bad (they are using PHP for a big application - no object oriented design - a lot of code redund

Re: [GENERAL] What are the consequences of a bad database design

2005-04-12 Thread Paul Tillotson
But the people i am working with are not considering the restructuring of the database. They are even thinking of expanding it by adding new modules. Please can someone advise me, or tell me what to do, what may be the consequences My advice is to not go to them with the "we need to totally r

Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-12 Thread Robert Treat
On Monday 11 April 2005 05:39, Jinane Haddad wrote: > Hi everyone, > > i just got a new job in a small entreprise and they are using postgres as a > database for their application. I was stupefied cause the database design > is so bad : we can even say it has been done by amateurs. I observed the >

Re: [GENERAL] What are the consequences of a bad database design

2005-04-11 Thread Scott Marlowe
On Mon, 2005-04-11 at 04:39, Jinane Haddad wrote: > Hi everyone, > > i just got a new job in a small entreprise and they are using postgres as a > database for their application. I was stupefied cause the database design is > so bad : we can even say it has been done by amateurs. I observed the

Re: [GENERAL] What are the consequences of a bad database design

2005-04-11 Thread David Fetter
On Mon, Apr 11, 2005 at 01:00:43PM +0300, Costin Manda wrote: > > But the people i am working with are not considering the > > restructuring of the database. They are even thinking of expanding > > it by adding new modules. > > > Please can someone advise me, or tell me what to do, what may be > >

Re: [GENERAL] What are the consequences of a bad database design

2005-04-11 Thread tony
Le lundi 11 avril 2005 à 09:39 +, Jinane Haddad a écrit : > i just got a new job in a small entreprise and they are using postgres as a > database for their application. I was stupefied cause the database design is > so bad : we can even say it has been done by amateurs. > But the people i

Re: [GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-11 Thread Martijn van Oosterhout
On Mon, Apr 11, 2005 at 09:39:13AM +, Jinane Haddad wrote: > My question is with such database, what are the lomg term consequences or > can we determinate them. I know that the querys will become slower, and the > database will grow more quickly ... And a lot of information will not be > tr

Re: [GENERAL] What are the consequences of a bad database design

2005-04-11 Thread Costin Manda
> But the people i am working with are not considering the restructuring of > the database. They are even thinking of expanding it by adding new > modules. > Please can someone advise me, or tell me what to do, what may be the > consequences I have been working with databases for web scripts (P

Re: [GENERAL] What are the consequences of a bad database design (never

2005-04-11 Thread Rafael . Hernamperez
PROTECTED] 11/04/2005 11:39                 Para:        pgsql-general@postgresql.org         cc:                 Asunto:        [GENERAL] What are the consequences of a bad database design (never seen that before !) Hi everyone, i just got a new job in a small entreprise and they are usi

[GENERAL] What are the consequences of a bad database design (never seen that before !)

2005-04-11 Thread Jinane Haddad
Hi everyone, i just got a new job in a small entreprise and they are using postgres as a database for their application. I was stupefied cause the database design is so bad : we can even say it has been done by amateurs. I observed the following problems till now: 1- redondancy ( TOO MUCH) 2- M