[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
Re: [PHP] 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
[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: [PHP] 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
[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/general/ -- 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
[PHP] Re: database design tool
Shawn McKenzie wrote: > Can anyone recommend a preferably visual DB design tool? I normally use > mysql, but one that covered several types wood be cool. I'm on Linux, > so the new mysql workbench is a dud. I used it in an alpha or prior > version and it looked promising but crashed frequently. They say a > Linux version in 2008, but I'm not holding my breath. > > Thanks! > -Shawn Ha, I first tried a subject of "OT: database design tool" to be civil, but the news server rejected it with a message of "apparent off topic post". Haha. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php