December 19th, 2003, 08:48 AM
|
 |
cosmos curator
|
|
Join Date: Mar 2002
Location: Leeds, UK
Posts: 678
Time spent in forums: 1 Day 14 h 17 m 49 sec
Reputation Power: 8
|
|
Exceptions on unique columns.
Hi
Just wondering...
I'm building an app in PHP/MySQL which may potentially be ported to Oracle/Sybase/PostgreSQL/SQLite.
In my app, I need to ensure that all usernames are unique.
Would it be better to tag the column as unique, try an insert and act upon errors, or query the DB first to see if the username already exists?
I'm not sure how the other DBs handle duplicated on unique columns.
Thanks.
__________________
R.T.F.M - Its the only way to fly...
"No matter what you do, or how good it is, someone will always ask for more features. Or to change the colour of something, then change their minds."
Personal:
experience// 8 Years Web Development
technologies// Standards-compliant, valid, & accessible (x)HTML/CSS, XML/XSL/XPath/XQuery/XUpdate, (OOP) PHP/(My)SQL, eXist/Xindice/XMLDBs
packages// Photoshop, Illustrator, Flash/Fireworks/Director
environment// FC2, MySQL, Lighttpd, PHP5, Mojavi/Agavi
site// //refactored.net/ (Coming soon...)
quote// Programming is the eternal competition between programmers who try to make apps more and more idiot proof and the universe that makes dumber idiots. So far, the universe is winning...
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
