php-general Digest 4 Jul 2013 10:42:45 -0000 Issue 8283

2013-07-04 Thread php-general-digest-help
php-general Digest 4 Jul 2013 10:42:45 - Issue 8283 Topics (messages 321521 through 321521): Web dev, DB and proper db design. 321521 by: Richard Quadling Administrivia: To subscribe to the digest, e-mail: php-general-digest-subscr...@lists.php.net To unsubscribe from the

php-general Digest 5 Jul 2013 04:38:25 -0000 Issue 8284

2013-07-04 Thread php-general-digest-help
php-general Digest 5 Jul 2013 04:38:25 - Issue 8284 Topics (messages 321522 through 321527): Re: Web dev, DB and proper db design. 321522 by: Tony Marston 321523 by: Jim Giner 321524 by: Lester Caine 321525 by: Andy McKenzie 321526 by: Tamara Temple

[PHP] Web dev, DB and proper db design.

2013-07-04 Thread Richard Quadling
Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the database. As someone who has spent 25 years working on accounting/epos systems on MS SQL Server (yep, windows) and now in a web

[PHP] Re: Web dev, DB and proper db design.

2013-07-04 Thread Tony Marston
Richard Quadling wrote in message news:CAKUjMCWJ4wiUO904OvYkS53Fsg4PPXa=qbokcvhwfemcpkp...@mail.gmail.com... Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the database. As

[PHP] Re: Web dev, DB and proper db design.

2013-07-04 Thread Jim Giner
On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the database. As someone who has spent 25 years working on accounting/epos systems on

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread Lester Caine
Richard Quadling wrote: Is there a difference in those in 'startups' and web only situations, or those doing more traditional development (split that as you like - I'm just trying to get an understanding and not go off on one!). Depends if you consider MySQL is any use as a real database :)

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread Andy McKenzie
I think it depends on the application. A lot of small web apps simply don't need any kind of normalization, and it really does make sense to put everything in one table, or a couple of unlinked tables. Therefore, on those apps, there's no need for foreign keys. For instance: I used one

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread Tamara Temple
On Jul 4, 2013, at 8:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was told I've never worked on a web application where foreign keys were used in the

Re: [PHP] Web dev, DB and proper db design.

2013-07-04 Thread musicdev
On Thu, Jul 4, 2013 at 4:20 PM, Tamara Temple tamouse.li...@gmail.comwrote: On Jul 4, 2013, at 8:02 AM, Jim Giner jim.gi...@albanyhandball.com wrote: On 7/4/2013 6:42 AM, Richard Quadling wrote: Hi. I've just had a conversation regarding DB, foreign keys and their benefits. I was

[PHP] PHP 5.4.17 released!

2013-07-04 Thread Stas Malyshev
Hello! The PHP development team announces the immediate availability of PHP 5.4.17. About 20 bugs were fixed. All users of PHP are encouraged to upgrade to this release. For source downloads of PHP 5.4.17 please visit our downloads page: http://www.php.net/downloads.php Windows binaries can be