Database design

------=_NextPart_000_0035_01CAB630.7597AB80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi all. I know this is not strictly a PHP question but the code will be =
written in PHP, and I figure the folks here will be well versed in the =
questions I raise. Please feel free to contact me off the list if =
appropriate.

I need some assistance with database design for a project I'm coding in =
PHP. I'm willing to pay for the advice, since I think it will be a bit =
complex. I plan to use MySQLi

If anybody feels they can assist, or can point elsewhere please feel =
free to contact me off list, or reply to the list if you think =
appropriate.

Thanks,
Angus
------=_NextPart_000_0035_01CAB630.7597AB80--

Re: Database design

On Thu, Feb 25, 2010 at 03:37:38PM +1000, Angus Mann wrote:

> Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate.
>
> I need some assistance with database design for a project I'm coding in PHP. I'm willing to pay for the advice, since I think it will be a bit complex. I plan to use MySQLi

Not sure why you want to use MySQLi, but I would suggest using PDO
functions instead. Either way, I'd design a wrapper class around
whatever library you use, to simplify error trapping, make the interface
simpler and more orthogonal, and improve portability. I've never
understood why they didn't provide such an overall wrapper class for the
PDO library. Having three separate PDO classes only complicates the
interface to the library.

Paul

--
Paul M. Foster

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Database design

Hello,

on 02/25/2010 02:37 AM Angus Mann said the following:
> Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate.
>
> I need some assistance with database design for a project I'm coding in PHP. I'm willing to pay for the advice, since I think it will be a bit complex. I plan to use MySQLi
>
> If anybody feels they can assist, or can point elsewhere please feel free to contact me off list, or reply to the list if you think appropriate.

Have you tried the PHP specialists forums?

It is a place for asking non-trivial questions about PHP development.

http://www.phpclasses.org/discuss/topic/specialists/forum/ge neral/

--

Regards,
Manuel Lemos

Find and post PHP jobs
http://www.phpclasses.org/jobs/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: Database design

On Thu, 2010-02-25 at 22:03 -0300, Manuel Lemos wrote:
> Hello,
>
> on 02/25/2010 02:37 AM Angus Mann said the following:
> > Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate.
> >
> > I need some assistance with database design for a project I'm coding in PHP. I'm willing to pay for the advice, since I think it will be a bit complex. I plan to use MySQLi
> >
> > If anybody feels they can assist, or can point elsewhere please feel free to contact me off list, or reply to the list if you think appropriate.
>

Hi Angus Mann..
I have been updating database design with various e-books. I think
this might be a good time for me to try out some applications. I want to
join your project. No money terms needed. All i want is to get involved.
Thanks for any reply..


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Database design

Angus Mann wrote:
> Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate.
>
> I need some assistance with database design for a project I'm coding in PHP. I'm willing to pay for the advice, since I think it will be a bit complex. I plan to use MySQLi
>
> If anybody feels they can assist, or can point elsewhere please feel free to contact me off list, or reply to the list if you think appropriate.
>

Best tip I can give is to model out all your data first (using UML or
suchlike) then figure out the tables to hold it from that; your database
should not dictate the model of the data; also if you design to a model
then your codebase need never change when it becomes time to change to a
different RDMBS or even a completely different way of persisting your
data :)

regards!

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Re: Database design

Nathan Rixham wrote:
> Angus Mann wrote:
>> Hi all. I know this is not strictly a PHP question but the code will be written in PHP, and I figure the folks here will be well versed in the questions I raise. Please feel free to contact me off the list if appropriate.
>>
>> I need some assistance with database design for a project I'm coding in PHP. I'm willing to pay for the advice, since I think it will be a bit complex. I plan to use MySQLi
>>
>> If anybody feels they can assist, or can point elsewhere please feel free to contact me off list, or reply to the list if you think appropriate.
>>
>
> Best tip I can give is to model out all your data first (using UML or
> suchlike) then figure out the tables to hold it from that; your database
> should not dictate the model of the data; also if you design to a model
> then your codebase need never change when it becomes time to change to a
> different RDMBS or even a completely different way of persisting your
> data :)

Although, and I'm just raising awareness here since there's nothing
inherently wrong with what Nathan has said... when you design to a model
specifically, rather than to the target medium, your solution will be
almost certainly be less efficient. Also, there are different skills to
be had from the tree of learning. If you build to the model first then
you learn to abstract. If you build to a specific medium and then later
need to change mediums, then you learn to refactor. Given the wide
amount of crappy code in existence... the latter IMHO, is the more
useful skill in most scenarios... but then again, you'll probably get
lots and lots of practice at that anyways :B

Cheers,
Rob.
--
http://www.interjinn.com
Application and Templating Framework for PHP

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Database design

a good tool for mapping mysql databases is mysql-workbench.
the real question is how much normalization is normal?
http://wb.mysql.com

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php