|
Is not yet time for database to have the email and website/ url data types?
|
|
|
|
|
Why would you ever want this? Those are just strings and SQL already handles those quite easily. There's nothing you can do to them that can't already be done with a string.
Also, having a type assumes the underlying data format will never change. That simply is not that case for URLs and email addresses. Your type eventually becomes obsolete.
|
|
|
|
|
They could be useful if it's not just the data type.
Validation could arguably be done in a trigger.
Filter / Group e.g. by protocol and/or domain seems like an applicable, useful operation. Could be done by respective functions, but I'm certain
indexing could be optimized easier if the types were native.
Comparison / equality works slightly different from plain strings. Can be solved by normalization before storing, but this would be considered lossy for some applications.
|
|
|
|
|
Regex. Regex is what you are looking for.
|
|
|
|
|
email:
@"^([0-9a-zA-Z]([\+\-_\.][0-9a-zA-Z]+)*)+"@(([0-9a-zA-Z][-\w]*[0-9a-zA-Z]*\.)+[a-zA-Z0-9]{2,17})$";
URL:
(((([a-z]|\d|-|.||~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'()*+,;=]|:)*@)?(((\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5]).(\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5]).(\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5]).(\d|[1-9]\d|1\d\d|2[0-4]\d|25[0-5]))|((([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|.||~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))).)+(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|\d|-|.|_|~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])([a-z]|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF]))).?)(:\d*)?)(/((([a-z]|\d|-|.||~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'()*+,;=]|:|@)+(/(([a-z]|\d|-|.||~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'()*+,;=]|:|@)))?)?(\?((([a-z]|\d|-|.||~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'()*+,;=]|:|@)|[\uE000-\uF8FF]|/|\?)*)?(#((([a-z]|\d|-|.||~|[\u00A0-\uD7FF\uF900-\uFDCF\uFDF0-\uFFEF])|(%[\da-f]{2})|[!\$&'()*+,;=]|:|@)|/|\?)*)?$
No, I don't.
|
|
|
|
|
Why?
What extra use would they have over NVARCHAR?
Do you think we should add twitter hashtags as well?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
You. Just. Never. Know.
What if there were an IP address type that works just fine for IPv4, but doesn't work for IPv6?
I've also seen a technique that can store a ten-digit U.S. phone number in a 32-bit integer -- that worked fine in the 80s but not today.
Or a Zipcode type that can't handle Zip+4 ?
What if you had a huge enterprise system that relied on that and now had to refactor everything?
Or are you going to wait for a patch/update from some third-party vendor? I waited most of 1999 for Y2K fixes from a couple of vendors, and eventually (September?) they said they couldn't do it and we'd need to stop using those products.
|
|
|
|
|
# 
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning
|
|
|
|
|
I know Access has a URL type, but AFAICT it is stored internally as an NVARCHAR with some specific metadata. It is basically a convenience type to allow for clicking on the URL to open the respective resource.
URLs and Email Addresses are just strings. It is up to the application displaying the data to determine how to best display the value.
Url/Email types would be useful in determining HOW to display the data, reducing (or possibly eliminating) the need to parse the string to find out what it is, but they should be stored internally as strings with some metadata on their type so that the database can be opened by other programs and systems that do not support a URL/Email type.
What do you get when you cross a joke with a rhetorical question?
The metaphorical solid rear-end expulsions have impacted the metaphorical motorized bladed rotating air movement mechanism.
Do questions with multiple question marks annoy you???
|
|
|
|
|
I am also reminded of Pascal's string type, which is limited to 255 characters. 
Even Sql Server's varchar, limited to 8000; and nvarchar, 4000 characters.
Some times defining types and giving them artificial limits can have dire unforeseen consequences many years in the future.
|
|
|
|
|
I saw this video of GlowForge: [^]; company site: [^].
I think that's a very cool device ... which I will never own, but ...
I recall when the first Apple LaserWriter that the public could rent time on appeared at Krishna Copy in Berkeley, California, in late 1985. The LaserWriter sold for US $2500 then, which I estimate would be equivalent to around 4K US $ today, the future full-price of the GlowForge printer
Within a month, I started my first company, 'Technical Document Design,' got lucky, bagged a major client who was willing pay premium for fast turn-around graphics production. Created designs in MacDraw, printed them on the LaserWriter, had a local plate-maker/photographer turn them into 8 inch by 10 inch film transparencies for overhead-projector display.
Four months later I could actually buy my own LaserWriter, but I'll never forget the days at Krishna Copy's "laser parlour" [1] where stoned-out hippies mixed with yuppies (imagine patchouli, sandalwood, with top notes of Old Spice and Bay Rum), and children, and dogs, were often found under the tables holding the LaserWriters 
So, perhaps it is the prerogative of being older (but not wiser) to yawn, and say: "Here comes a future I can't imagine I need" ?
cheers, Bill
[1] I take credit for coining the term "laser parlour," which actually got some usage in Cult-of-the-Mac circles and media.
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
|
|
|
|
|
"There is no reason for any individual to have a computer 3d printer in his home." -- Ken Olsen
"I think there is a world market for maybe five computer 3d printers." -- Thomas Watson
modified 24-Sep-15 20:43pm.
|
|
|
|
|
BillWoodruff wrote: Here comes a future I can't imagine I need
Death??? 
Marc
|
|
|
|
|
Marc Clifton wrote: Death???
Too early to say. 
«I want to stay as close to the edge as I can without going over. Out on the edge you see all kinds of things you can't see from the center» Kurt Vonnegut.
|
|
|
|
|
I can't - at the moment - see any reason why I'd want or need a current-generation 3D printer.
Maybe when the printed material is a little more robust, or the print speed is in minutes rather than hours. And when colours, textures, and "flexibility" can be manufactured in instead of just "almost hard" and "nothing".
But then of course, they will sell like hot cakes to the people who currently like their ladies inflatable...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
There are 3D printers for metal, but they're expensive, and don't do this:
OriginalGriff wrote: colours, textures, and "flexibility" can be manufactured in instead of just "almost hard" and "nothing".
But they can make some useful things, not just abstract art and unusual lego parts.
|
|
|
|
|
To be useful as a home printer, they need to be able to make a spanner that can undo "that nut right there" (like the one between the cylinders of a Norton Commando), or something that has conductors and insulators, switches, clear patches for LEDs, small matrix keyboards...
At the moment, they are a gimmick like the first home printers were (noisy, slow, poor quality output - you remember what early dot matrix jobbies were like).
Their time will come - but they just aren't there yet.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
For the average person, they are kind of a gimmick. I have worked with them personally (although it was a terrible printer from a terrible company) and I loved the thing. I was able to make quick fabrications (rather than sending them off to be physically made, which could take weeks to get it sent over). The price range is just still too much for the quality, but I can't wait till I can have one to use at home for random things.
|
|
|
|
|
OriginalGriff wrote: I can't - at the moment - see any reason why I'd want or need a current-generation 3D printer.
Unless of course you need a new car[^]
veni bibi saltavi
|
|
|
|
|
A couple of things here:
1) I can't afford its fuel consumption.
2) It'd be a bugger to park at Tescos.
3) No room for the shopping.
4) No room for Herself (which may be counted as an advantage from time to time, I'll admit).
5) There may be a few small components there that they didn't 3D print.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
If you have a dual-head extruder, you can do hard and flexible printing in the same object. For an example, check out some of the stuff James at xrobots.co.uk[^] does with a combination of ABS and ninjaflex. With multi-head extruders, you can do different colors in the same print too.
|
|
|
|
|
Cool device, but I'm like you I'll never own one...I'm so broke I can't even pay attention!
New version: WinHeist Version When you have eliminated the JavaScript, whatever remains must be an empty page. Unknown
|
|
|
|
|
When you get your first 3D printer, and if it can print body parts, I will be your first customer. Some of these 71 year old bones are creaking so much, they should be replaced!
How do we preserve the wisdom men will need,
when their violent passions are spent?
- The Lost Horizon
|
|
|
|
|
Looks cool, but I'm saving up for a Replicator (ala Star Trek)...
Will Rogers never met me.
|
|
|
|
|
When they will cost substantially less and the printing materials too, I'll buy one. I'll just wait for a easy 3D designing tool (I'm no designer nor artist) because I'd like to make my own miniatrues for D&D games - the original ones suck a lot, not even one gets close to my idea of what the PG should be.
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
"When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
