Feeds

back to article First among SQLs

Legend has it that Edgar 'Ted' Codd got the idea for SQL while attending a 'Sky at Night' spin-off lecture. Patrick Moore, pointing at the blackboard, said: 'Select a star from the table'. 'That's it!', cried Codd, and ran out the door to follow up his inspiration forthwith, missing a good discussion of vulcanoids. Though born …

COMMENTS

This topic is closed for new posts.
Silver badge
Heart

I'm looking forward to the sequel

It may be weird and arcane, illogical an d not really a programming language as we know it, but it's far better than the alternatives.

It is indeed very unpleasant to swap btween DB2, Oracle, MySQL and MS-SQL even on a fresh project, never mind trying to port a large one.

And ODBC and VB6 + IIS on MS-SQL and you'll really want to start over to use PHP, Java and MySQL. :(

1
1
Silver badge
Boffin

If you ever feel like SQL is bad...

You should check something called MUMPS. Now *that* is absolute terror!

1
0

MUMPS

Ah MUMPS isn't so bad, you can at least be very... concise! :)

0
0
Boffin

Thank you for the laugh, good sir.

Although I am well aware that it probably was not intended as a humorous article.

0
0
WTF?

Erm

Are you pulling our legs? It's -supposed- to be humour. Also, Verity is not a "good sir".

0
0
Thumb Up

MY god...

a stob article that was actually good.

0
3
jai
Silver badge
Megaphone

imbecile!!!

Stob articles are always good - you're just not reading them right!

9
0

Levels of indirection

There is one problem that cannot be solved by adding layers of indirection: "The code is too big to fit into the ROM."

0
0
Gold badge
Coat

Re: Levels of indirection

Not true. Read Brooks' Mythical Man Month and learn of the IBM minion who took a bloated terminal handler and reduced its memory footprint by replacing it with an interpreter and a script.

1
0
Bronze badge
Megaphone

SHOUTY, SHOUTY!

I) USING ALL CAPS SHOWS THAT THE CODE IS NOT YOUR implementation_language.

II) THE MORE CAPS IN THE CODE, THE LESS YOU WANT TO HAVE OF IT. A GOOD IDEA WITH SQL.

III) MAYBE SQL SHOULD BE LIKE XML: YOU CAN READ IT AND EDIT IT IN NOTEPAD, BUT IF YOU'RE DOING REAL WORK, YOU SHOULDN'T BE LETTING MERE TEXT EDITORS ANYWHERE NEAR IT. JUST ASK THE SCHOOL little bobby tables GOES TO.

2
0

...but why?

the sub-heading of COBOL? What has that got to do with SQL?

P.S. J. Cook - I believe Verity is a girlie not a sir,. at least I have always assumed so.(I have not seren the proof)

0
0

Moore Contemplations And More

So, us USians finally began viewing - oh wait, this is the 21st century, make that consuming - the Moffat Doctor Who over the weekend. Thus, twice in 48 hours, I have seen reference to a certain Patrick Moore. I have very little idea what he does, but I induce that it's on television and either he or his phenomenon is rather comical to smart people.

But isn't that the wonder of life? Another pop cultural reference to track down! That's better than street-cars in Los Angeles for a variety of reasons.

Long-time fan of Ms Stob and it's always a pleasure to find her work.

0
0

Here, let me Google that for you ...

http://lmgtfy.com/?q=patrick+moore

0
0
Megaphone

Acro-nots

Neither Fortran (FORmula TRANslation) nor Algol (ALGOrithmic Language) are acronyms, so don't write them as such.

1
2

Tsk, tsk

You missed the joke.

1
0

RE: Acro-nots

Ah, yes, but you see, they both originated in the dark days before the invention of lower-case letters.

1
0

@Daedalus: Acro-nots

Actually, both /are/ acronyms, same as "laser" and "radar". Whether an acronym is all caps depends on house style and on the acronym itself (e.g. "NATO", usually -- though not by the Guardian -- "scuba", never).

0
0

Old-ish terminology?

A little outdated surely? "true-ish" has been deprecated in favour of the 2.0 term, "truthiness"

1
0
Happy

Best Verity piece in a long time

Or is that she does not publish so often? Time to check the archives, I may have been missing something.

0
0
Flame

the crux of the issue

But the article avoids the main point of contention in the SQL world (no, not Mysql versus Postgres or Oracle vs. everything else); whether it is pronounced "sequel" or "S Q L".

2
0
Silver badge
Boffin

SQuirreL!

I've seen worse abominations than pronouncing SQL as Sequel: One "IT guru" claimed that he was a "seequa server" expert. Huh?

0
0

Pronunciation

That would be "Squirrel"...

1
0
Headmaster

No contention

The SQL standard says that it's pronounced "S.Q.L". Go look it up.

0
0
FAIL

Darwin & Date

If only they could have saved us from SQL's maddifying inconsistencies. Although how difficult these days to imagine a database world without NULL.

0
0

Null, a love song

I don't care what they say - I won't stay in a world without NULL.

0
0
Boffin

shouty shouty

SQL IS NOT TOO_BAD.

{

for $realHeadache in doc("querying")

let $us_try :=XQuery

return

<ouch/>

}

0
0
Pint

Brilliant!

Ms Stob's ability to write a spoof is unparallelled - they are laugh-out-loud funny even when (as in my case) you know precious little about the subject being spoofed.

Please accept a virtual beer.

0
0
Anonymous Coward

"For example"

Pity you couldn't squeeze MySQL's geothingy stuff in there...

And for the record:

. Verity Stob is neither a sir nor a girlie, but a lady.

. Verity Stob is always good, if you think otherwise, you missed the joke.

. Verity Stob is always funny, if you think otherwise, you missed the joke.

Buy a copy of "The Best of Verity Stob", you might find a sense of humour.

1
0

For a lovable sql book

Look no further than the Manga Guide to Databases.

Seriously.

0
0
FAIL

£2 coin

I think you'll find that's a *two* pound coin. One of these:

http://i667.photobucket.com/albums/vv35/merlincove/2407901915_4d84759310.jpg

As in this fine explanation:

http://momscancer.blogspot.com/2007/08/coin-of-realm.html

Otherwise, though, a very splendid article, rich in win and low in lossage, as I believe the children say.

0
0

The pick n mix

was always just inside the front door of my local branch of Woolies; no wonder the little ruffians used to steal it. I, of course, never entertained such ideas.

0
0
Bronze badge

It's onomatopoeic, surely?

I believe "SQL" is properly pronounced "squeal", for reasons that ought to be obvious to anyone who uses it (or, worse, has to read someone else's). This is handy for the popular SQL cheers, eg:

"LEFT JOIN! RIGHT JOIN! INNER JOIN! TRIG'!

Denormalize your tables and SQL like a pig!"

0
0
Go

Cobol? SQL?

First of all, why the Cobol reference? Yes, SQL is embeddable in Cobol, but the article never touched on that.

'Proper SQL' - what's that then? The opposite of 'improper SQL' perhaps?

Mainframe-derived SQL was/is/should probably be written in CAPS, whereas *nix-derived SQL should probably be lower case. Mixed case? Ugh! Windows-derived SQL? Who cares.

Why mix database design/normalisation and SQL as topics? The two only come together after mucho-arguing when it's time to finally, like, lay down a schema. Even then the modern-fangled way is to use a modelling tool to do the doing, often in complete ignorance of DBMS-specific best practices . Pah!

Is S.Q.L. (never, ever, ever 'sequel', that's a follow-up) even a language? Not in my book.

Triggers - dangerous? Agreed. Also often expensive. They don't get a look-in on big-data MPP systems.

Remember, neat SQL is efficient SQL ;-)

0
0
This topic is closed for new posts.