News for hackers. Stuff that matters.
Re:Ask HN: What made SQL databases so popular? by ucee054 on Sunday March 10, 2013 @08:39AM (#5351635)
You've been smoking too much FabianPascal
Re:Ask HN: What made SQL databases so popular? by TheZenPsycho on Sunday March 10, 2013 @08:41AM (#5351646)
well, just because he's an antisocial unbearable asshole doesn't mean he's not right.
Re:Ask HN: What made SQL databases so popular? by ucee054 on Sunday March 10, 2013 @08:59AM (#5351677)
No, the fact that he's not living in reality does.

I never heard about Codd complaining about IBM's first relational implementation. In fact, have you read Codd's papers defining relational databases and normal forms?

To even get to 1NF, you have to eliminate any non-atomic datatypes. How the hell are you going to do that?

Get rid of strings? Any idiot can put "key1=value1;key2=value2" into a string and violate 1NF. Any idiot can create two identically typed columns for storing the same attribute, instead of one, in the same table, and violate 1NF. Even frickin' dates are non-atomic.

There is no practical way for a database server to ENFORCE what Pascal calls "relational" on the users.

So actually the whole "SQL's not relational" bullshit boils down to three things: "WAAAH! DISTINCT should be the default!" "WAAAAH! we shouldn't have NULLs!" and "WAAAH! we shouldn't have recursive table definitions or hierarchy types!"

Back in the real world we want those features, because we NEED to represent hierarchies and "Not Applicable" values in our databases.

Re:Ask HN: What made SQL databases so popular? by TheZenPsycho on Sunday March 10, 2013 @09:05AM (#5351695)
err.... I think you are deeply confused. http://en.wikipedia.org/wiki/First_normal_form#Atomicity

The rules of relational databases aren't the rules because some guy named CODD said they are. There are deeper principles of mathematics and logic at work. It's rather hysterical to claim that, because some guy named CODD explained the properties of this system in an ambiguous or confusing way, that the whole system should be disregarded as impractical nonsense.

Re:Ask HN: What made SQL databases so popular? by ucee054 on Sunday March 10, 2013 @09:34AM (#5351812)
Oh I forgot to add, the rules of relational database are exactly what CODD said they are because CODD invented them and said "I define the relational model to be this"

What they are NOT is what you, Chris Date and Fabian Pascal want them to be. And no-one is going to use Tutorial-D ever, so it's about time you made your peace with SQL.

Re:Ask HN: What made SQL databases so popular? by ucee054 on Sunday March 10, 2013 @09:14AM (#5351733)
What precisely am I confused about?

You are linking to the 1NF wikipedia page section on atomicity.

Are you alleging that I am confused about atomicity?

Because I said strings and dates are not atomic. Here is your link:

"A character string would seem not to be atomic, as the RDBMS typically provides operators to decompose it into substrings."

By the way, dates can also be decomposed, into years, months, days, hours, minutes etc

Oopsie, it appears that you're the one who's confused.

Re:Ask HN: What made SQL databases so popular? by TheZenPsycho on Sunday March 10, 2013 @09:25AM (#5351774)
Anyone can click on that link and read it. You only make a fool of yourself by willfully failing to understand what is written there.
Re:Ask HN: What made SQL databases so popular? by ucee054 on Sunday March 10, 2013 @09:40AM (#5351848)
Well no, you make a fool out of yourself by reading something that isn't there.

Instead of resorting to ad-hominems, you could have actually explained what I am supposed to be confused about, and what I am supposed to have "understood" from the page which was saying exactly the same as what I was saying.

Or you could have tried to tackle the fact that we need NULLs and other "sins against Pascal", which was the point of my argument.

You failed to do both. I conclude that you got nuthin'

Re:Ask HN: What made SQL databases so popular? by TheZenPsycho on Sunday March 10, 2013 @10:05AM (#5351950)
So you are saying that you insist that the correct definition of "atomic" is the one that is completely useless (by defining strings and dates as non atomic), and by extension makes the whole of the relational model useless? Uhhh. okay. You can have that victory I guess. pats your head.
Re:Ask HN: What made SQL databases so popular? by skore on Sunday March 10, 2013 @01:53PM (#5352728)
Your recurring "rebuttal" to somebody posting a reply to your argument is to say that your point is right, that he is 'deeply confused', that he is arguing from authority, ignoring mathematical principles, that he is hysterical, that he doesn't read his own links, that he is making a fool of himself by not understanding what he has linked to himself. Up to this point, you don't use a single word to actually provide any substance at all to your argument. Then, finally, you actually do address one of his points in the most dismissive and condescending way I have seen all day.

Kudos, I guess. No substance and all hot air. Somewhere halfway through your silly dance, irony ate its own hat.

Re:Ask HN: What made SQL databases so popular? by TheZenPsycho on Sunday March 10, 2013 @07:32PM (#5354067)
huh? Who are you? have you made me a project? ooh! that's so cute! Well I could just wave off your weird outburst here but I guess out of fairness I'll address you point for point.

> Your recurring "rebuttal" to somebody posting a reply to your argument is to say that your point is right, that he is 'deeply confused'

Recurring? Well I did say he was deeply confused. once, up thread. I suppose the part where I supposedly say "my point is right" is implied by the fact that this is an argument, and I am the person arguing my point- But I can't find where I say that explicitly, out loud. That would kind of be weird. Have I said this somewhere else?

> that he is arguing from authority, ignoring mathematical principles, that he is hysterical.

OH! Are you referring to where I was talking about mathematical principles? I suppose one way of looking at that was me saying something about his argument. From my point of view I was just talking about a subject though.

> that he doesn't read his own links,

it was my link, and it was him trying to make a point about me reading my own link. Of course I did read my own link. the problem we were having is that he skimmed it, found the one out of context quote that would support his own point, and pulled that out on display. This seems kind of ridiculous to me, because anyone can click in, and look to see that they're quotes pulled out of context in such a way as to reverse their intended meaning, and he's fooling nobody by doing that. Well, maybe he's fooled you.

> that he is making a fool of himself by not understanding what he has linked to himself.

it was my link and and trying to lie about a source that is RIGHT THERE, and anyone can look at is really kind of crazy.

> Up to this point, you don't use a single word to actually provide any substance at all to your argument.

Up until that point there was not a single word that seriously challenged my claims, either.

> Then, finally, you actually do address one of his points in the most dismissive and condescending way I have seen all day.

Well, because it came at the end of a back of forth involving me trying to get him to read something that addressed his point, and so at the end, well, it's condescending because you realise that the point he is making is at this point, not that SQL IS relational after all, but that the Relational model is so absurd and stupid to begin with so as to be useless. So, at this point I have to just accept that he is irredeemably ridiculous and let him just have that victory if he wants it.

> Kudos, I guess. No substance and all hot air. Somewhere halfway through your silly dance, irony ate its own hat

Why do you care so much?

Re:Ask HN: What made SQL databases so popular? by skore on Sunday March 10, 2013 @09:00PM (#5354323)
> huh? Who are you? have you made me a project? ooh! that's so cute!

Two (now three) replies are quite a low bar to call something "a project". But I get it, you're totally casual about it.

> Well I could just wave off your weird outburst here but I guess out of fairness I'll address you point for point.

That wasn't necessary and I don't care for reading it. You might want to have this discussion with the original user replying to your statement, I was merely reiterating his complaint.

> Why do you care so much?

Because I read a quite interesting discussion on an interesting subject and you wasted my time with a weird and somewhat self-indulgent tangent. I felt that you deserved to have a little of your time wasted in return. I think we're done here.

Re:Ask HN: What made SQL databases so popular? by ucee054 on Monday March 11, 2013 @03:10PM (#5358955)
"because you realise that the point he is making is at this point, not that SQL IS relational after all, but that the Relational model is so absurd and stupid to begin with so as to be useless."

No, I was saying that your (and Fabian Pascal's) definition of a relational database is absurd and stupid and useless.

Your definition seems to be a server that enforces the relational model whereas EF Codd's definition seems to be something that enables the relational model.

EF Codd's definition seems quite good. It also seems to include IBM's original SQL system and Ingres and everything similar.

And your (and Pascal's and Date's) response seems to be a rather dishonest attempt to rewrite history and to change what relational means in order to make your stupid, stupid ideas work, so you can continue to whinge about SQL and NULLs.

It would be a lot easier just to learn to live with the fact that people need NULLs.