LWN.net Logo

PHP: a fractal of bad design (fuzzy notepad)

PHP: a fractal of bad design (fuzzy notepad)

Posted Apr 17, 2012 9:20 UTC (Tue) by tialaramex (subscriber, #21167)
In reply to: PHP: a fractal of bad design (fuzzy notepad) by khim
Parent article: PHP: a fractal of bad design (fuzzy notepad)

Excel is the same way. Every big number-crunching outfit knows that you mustn't build big important things out of Excel, even if they had to learn that the hard way. Yet, inevitably, somebody in those outfits is doing something in Excel because it was fast and they knew how. One day their pet project will get scaled up and it'll fall to pieces because it's built out of Excel when it really shouldn't be.

Excel has lots of the same frustrating properties. For example reluctance to announce failure (always better to eat reference errors, invalid inputs, etc. and spit out a superficially plausible answer anyway). But backwards compatibility is vital, so most of the problems can never be fixed, or if they are, they'll cause even more unexpected pain and misery for existing users.


(Log in to post comments)

PHP: a fractal of bad design (fuzzy notepad)

Posted Apr 17, 2012 15:47 UTC (Tue) by drag (subscriber, #31333) [Link]

The financial industry runs on Excel.

Most people would think that the large banks, financial execuatives, and top teir accountants would use all sorts of fancy custom software for doing taxes, accounts, figuring out contracts and business loans...

This is far from the reality.

The truth is that while they have custom apps like any other large business, Excel front-end tied to real databases is the principal application. That is app #1.

PHP: a fractal of bad design (fuzzy notepad)

Posted Apr 17, 2012 16:58 UTC (Tue) by sorpigal (subscriber, #36106) [Link]

The situation is the same for MS Access, only so much worse. Excel's is bug-free, predictable and of limited scope (at least by comparison). There's only so much trouble you can get in to with Excel, with Access you generally shoot yourself in the foot in slow-motion such that nothing really works but no one can tell until months or years down the line when it finally is revealed that all that excellent data you'd been basing your operations on is:

(1) Incomplete
(2) Incorrect
(3) Viewable by Timmy the intern
(3) Deletable by Timmy the intern
(3) Gone (and no one can find Timmy)

This is what happens when rank amateurs are left in charge of database design on a DBMS which allows you to get away with anything and relegates access control to an optional afterthought.

To keep this topical, I think the bad reputation of PHP web apps can be partly blamed on MySQL. If ever a language like PHP could meet its perfect partner in doing friendly disservice to its users, mysql is it.

Copyright © 2013, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds