[prev in list] [next in list] [prev in thread] [next in thread]
List: php-general
Subject: RE: [PHP3] Database Design
From: "Dean, John" <DEANJX () mail ! aramco ! com ! sa>
Date: 1999-11-13 9:43:28
[Download RAW message or body]
Scott,
I have would gladly write you a piece for your educational section. But
first let me ask can I join your group because I like your principles they
somehow fit in with my own. Computing and IT has provided me with the means
to make so good money so now I would like to give something back in
appreciation for all the help given to me when I started out in the
business. Thank you and Best Regards
John Dean
-----Original Message-----
From: Scott Perkins [mailto:2scott@bellsouth.net]
Sent: Monday, November 08, 1999 6:23 PM
To: Dean, John; php3@lists.php.net
Subject: Re: [PHP3] Database Design
fm Scott Perkins- coordinator PHP Database Driven User Group Atlanta, GA
770/973-3860 2scott@bellsouth.net
John- I am not qualified in PHP but I am trying to steer our educational
program towards more "efficient" techniques. I would appreciate any
suggestions
along the lines of things you are mentioning and would especially appreciate
any
actual examples that illustrate further as outlined in your email. Quite
recently, the
"VH class.layout" code set was made available. Do you think if that was
used as
"program or course focus " material the skills addressing your
techniques would/could be acquired?
> Dean, John wrote:
>
> Hi Guys,
> Recently I have taken a look at the DDL code used in many of the Data
Table
> used as part of PHP applications. And the one thing that strikes me is
that
> the writer has unnecessarily worked very hard on the scripts. What I mean
is
> let the under lying RDBMS do the work. I lot of time and effort could be
save
> if Data Tables were properly designed. In the DDL I have looked at nobody
has
> 'normalized' the tables, there is no use of referential integrity, no
check
> contraints, etc. Good design would save hours of PHP coding. What about it
> guys?
>
> This message is meant to open up a debate. It not meant the negatively
> critises (flame) anybody, so please don't be offended.
>
> Best Regards
> John Dean
>
> In this world without borders or fences
> Who needs Windows or Gates?
--
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net
To search the mailing list archive, go to:
http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin@lists.php.net
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2448.0">
<TITLE>RE: [PHP3] Database Design</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Scott,</FONT>
<BR><FONT SIZE=2>I have would gladly write you a piece for your educational section. \
But first let me ask can I join your group because I like your principles they \
somehow fit in with my own. Computing and IT has provided me with the means to make \
so good money so now I would like to give something back in appreciation for all the \
help given to me when I started out in the business. Thank you and Best \
Regards</FONT></P>
<P><FONT SIZE=2>John Dean</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Scott Perkins [<A \
HREF="mailto:2scott@bellsouth.net">mailto:2scott@bellsouth.net</A>]</FONT> <BR><FONT \
SIZE=2>Sent: Monday, November 08, 1999 6:23 PM</FONT> <BR><FONT SIZE=2>To: Dean, \
John; php3@lists.php.net</FONT> <BR><FONT SIZE=2>Subject: Re: [PHP3] Database \
Design</FONT> </P>
<BR>
<P><FONT SIZE=2>fm Scott Perkins- coordinator PHP Database Driven User Group Atlanta, \
GA</FONT> <BR><FONT SIZE=2>770/973-3860 2scott@bellsouth.net</FONT>
</P>
<P><FONT SIZE=2>John- I am not qualified in PHP but I am trying to steer our \
educational</FONT> <BR><FONT SIZE=2>program towards more "efficient" \
techniques. I would appreciate any suggestions</FONT> <BR><FONT SIZE=2>along \
the lines of things you are mentioning and would especially appreciate any</FONT> \
<BR><FONT SIZE=2>actual examples that illustrate further as outlined in your \
email. Quite</FONT> <BR><FONT SIZE=2>recently, the </FONT>
<BR><FONT SIZE=2>"VH class.layout" code set was made available. Do \
you think if that was used as</FONT> <BR><FONT SIZE=2>"program or course focus \
" material the skills addressing your</FONT> <BR><FONT SIZE=2>techniques \
would/could be acquired? </FONT> </P>
<BR>
<BR>
<P><FONT SIZE=2>> Dean, John wrote:</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Hi Guys,</FONT>
<BR><FONT SIZE=2>> Recently I have taken a look at the DDL code used in many of \
the Data Table</FONT> <BR><FONT SIZE=2>> used as part of PHP applications. And the \
one thing that strikes me is that</FONT> <BR><FONT SIZE=2>> the writer has \
unnecessarily worked very hard on the scripts. What I mean is</FONT> <BR><FONT \
SIZE=2>> let the under lying RDBMS do the work. I lot of time and effort could be \
save</FONT> <BR><FONT SIZE=2>> if Data Tables were properly designed. In the DDL I \
have looked at nobody has</FONT> <BR><FONT SIZE=2>> 'normalized' the tables, there \
is no use of referential integrity, no check</FONT> <BR><FONT SIZE=2>> contraints, \
etc. Good design would save hours of PHP coding. What about it</FONT> <BR><FONT \
SIZE=2>> guys?</FONT> <BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> This message is meant to open up a debate. It not meant the \
negatively</FONT> <BR><FONT SIZE=2>> critises (flame) anybody, so please don't be \
offended.</FONT> <BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Best Regards</FONT>
<BR><FONT SIZE=2>> John Dean</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> In this world without borders or fences</FONT>
<BR><FONT SIZE=2>> Who needs Windows or Gates?</FONT>
</P>
<P><FONT SIZE=2>-- </FONT>
<BR><FONT SIZE=2>PHP 3 Mailing List <<A HREF="http://www.php.net/" \
TARGET="_blank">http://www.php.net/</A>></FONT> <BR><FONT SIZE=2>To unsubscribe, \
send an empty message to php3-unsubscribe@lists.php.net</FONT> <BR><FONT SIZE=2>To \
subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net</FONT> <BR><FONT \
SIZE=2>To search the mailing list archive, go to: <A \
HREF="http://www.php.net/mailsearch.php3" \
TARGET="_blank">http://www.php.net/mailsearch.php3</A></FONT> <BR><FONT SIZE=2>To \
contact the list administrators, e-mail: php-list-admin@lists.php.net</FONT> </P>
</BODY>
</HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic