IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Re: Database's worst enemy: real life
Why would any one model a "a building number" as a real number.

When does anyone ever need to apply addition, substraction or multiplcation
to a building number

Same goes for telephone numbers! The telephone keybad have characters, mobile keypads have characters of sometimes both a local langugae + english/latin, why would the type that store the result be just numbers.
Telephone numbers can be thought be casted to real number from the receiving variable, plus why would a dialer for example only handler numbers and not map the more elaborate keypad!!!

Strings and Numbers and primitive data types, you should rely more on
abstract data types, think more about ur types
------------------------------------------
I, being, poor, have only my dreams;
I have spread my dreams under your feet;
Tread softly because you tread on my dreams.
W. B. Yeats, He Wishes for the Cloths of Heaven
New Building numbers are ordered elements
Think about scheduling a delivery route.

If you treat them as strictly alpha, then you'll have #10 sorted with the #100's. Strictly numeric doesn't work either.

They don't exactly fit either scenario.



I4 NOW!


Impeach, Indict, Incarcerate, Inject
Bush, Cheney, Gonzalez, Rumsfeld, Rove, Rice
New And if you want to code a war-dialer, you need phone math
New And if you're in Japan
if you're using Western-style street centric code, it ain't going to work.

--Tony
New Street addresses are a real PITA
You need to be able to input as text, munge the non-conforming addresses and convert to a number for sorting. Not to mention keeping track of street name modifiers such directions: North Main, South Main, 5th Street, 5th Ave. Or even streets with different names for different parts of the street. Or one street name for what is essentially two different roads.

Efficient delivery routes don't always follow street number order, so that's a different attribute. If you need any kind of history, street numbers and even street names do occasionally change.

Alot of details for something so simple as an American style address. And because they are so simple everyone expects them to be handled flawlessly.
Seamus
     Database's worst enemy: real life - (Arkadiy) - (14)
         Nothing wrong with it - (crazy) - (1)
             Funny. -NT - (folkert)
         Absolutely. - (static)
         Lemme guess - the field is defined as a numeric type? - (tuberculosis)
         Tell me about it. - (JayMehaffey) - (4)
             Makes you want to find the joker who named the road ... - (drewk) - (2)
                 You insulting Jeremiah Street, the founder of Town City? -NT - (CRConrad) - (1)
                     Is that in Statesota? -NT - (folkert)
             Agree w/ Drook - (jb4)
         Re: Database's worst enemy: real life - (systems) - (4)
             Building numbers are ordered elements - (tuberculosis) - (3)
                 And if you want to code a war-dialer, you need phone math -NT - (crazy)
                 And if you're in Japan - (tonytib)
                 Street addresses are a real PITA - (Seamus)

I seem to remember a rather Stupid rendition sometime back.
95 ms