LINUX.IE, website of the Irish Linux Users' Group
Tux rules!

   
Home
New Users
Articles
Download
Projects
Community
Vendors

  Print Version
Email to...
 
Archives:


planetILUG

Recent News

News Archive


Join the
ILUG
on FaceBook


Join the
ILUG
on LinkedIn


Join the
ILUG SETI
Group



















 
 :: Mailing Lists

[ILUG] PostgreSQL vs. MySQL

[ILUG] PostgreSQL vs. MySQL

John P. Looney valen at tuatha.org
Mon Dec 2 10:46:04 GMT 2002


On Mon, Dec 02, 2002 at 09:53:39AM +0000, Nick Murtagh mentioned:
> I have a problem with this design - and it's mainly to do with the burp
> loudly part. If some intermediate layer or the application itself does
> validation, you can have the GUI give an error message explaining
> what went wrong and what to do about it. If the database "throws an 
> exception", you have two choices. One, display the error message 
> returned by the db, probably something along the lines of "Constraint 
> violated ..." which won't mean anything to the average end user. Or try 
> and parse the error messages from the database and report something 
> sensible to the user.
> 
> You're always going to need to do some validation directly in the GUI,
> unless you want a really unusable GUI.

 Of course. I don't think Ronan was suggesting otherwise. But, it's nice
to have validation in the database too, as you can add other frontends
without duplicating code.

 I'm a big fan of validation on the far end of every data boundry, and in
this case, you have two boundries;

 user->ui   ui->database

 If you just have validation in the UI, you aren't protected from bugs in
the UI creating an inconsistent database.

 Of course, I've written triggers for SNMP database backend, so I'm messed
up to start with.

John, creator of numerous UIs with such bugs




More information about the ILUG mailing list
Read this without the formatting.
                                                                                                    

 

Hosted by HEAnet


Maintained by the ILUG website team. The aim of Linux.ie is to support and help commercial and private users of Linux in Ireland. You can display ILUG news in your own webpages, read backend information to find out how. Networking services kindly provided by HEAnet, server kindly donated by Dell. Linux is a trademark of Linus Torvalds, used with permission. No penguins were harmed in the production or maintenance of this highly praised website. Looking for the Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
RSS Version
Powered by Dell