> Hmm you seem to be laboring under a concept that to know how to join two tables you need to be an RDBMS "expert" You're misreading. You kept bringing up the point of "expert" knowledge (e.g. in C and for-loops),…
As noted, there are numerous expert programmers who couldn't do an SQL join in a live interview. Besides PG, RTM, and TLB, most or all of the Linux kernel programmers, including Linus; Pete Norvig; embedded systems…
I have enough SQL knowledge to replicate most websites I see. I am also familiar with it enough to look up things I don't know and use them. If that's not "working knowledge", you're using some different definition. You…
> Invalid refutation, I said "if you used an RDBMS and ". That "and" was a boolean and. Valid refutation. You can use an RDBMS without making use of most of its facilities, and indeed, that is the typical usage…
> I was specifically responding to this sentence "PG, RTM, and TLB would probably fail your test". I doubt that somehow! But you'd be wrong.
> There are tons of languages that support recursion Obviously. But I don't remember ever writing a recursive function in PHP for a website.
> It had just never occurred to me that people who spend their entire lives talking to databases wouldn't know how to talk to them directly. You're begging the question. Most people who use databases don't "spend…
It would be nice to see who's upvoting this so I could add them to an IDIOTS file. Any of the above people could obviously EASILY pick up whatever SQL you happened to be using. RTM could wipe the floor with you, the OP,…
> if you used an RDBMS in a non trivial app Depends on what you mean by "trivial". You can use a database for most of the things most websites use them for without ever using a JOIN. It just takes application logic…
> then I don't think that you actually have a working knowledge of SQL in any sense. Of course I have working knowledge of SQL, that's how I used MySQL back when we had to write things by hand. I just don't have a…
> Unless you're saying "I drew some lines on this piece of paper that represent the strings on the violin; I want you to play the piece of paper like you would the instrument." Yes, that's it. > In which case…
Part of it may be your questions, and part may be HOW you're asking (e.g. over the phone, or putting someone on the spot). 2) Not a lot of people write SQL by hand anymore. I used MySQL for years, long ago, and never…
> Hmm you seem to be laboring under a concept that to know how to join two tables you need to be an RDBMS "expert" You're misreading. You kept bringing up the point of "expert" knowledge (e.g. in C and for-loops),…
As noted, there are numerous expert programmers who couldn't do an SQL join in a live interview. Besides PG, RTM, and TLB, most or all of the Linux kernel programmers, including Linus; Pete Norvig; embedded systems…
I have enough SQL knowledge to replicate most websites I see. I am also familiar with it enough to look up things I don't know and use them. If that's not "working knowledge", you're using some different definition. You…
> Invalid refutation, I said "if you used an RDBMS and ". That "and" was a boolean and. Valid refutation. You can use an RDBMS without making use of most of its facilities, and indeed, that is the typical usage…
> I was specifically responding to this sentence "PG, RTM, and TLB would probably fail your test". I doubt that somehow! But you'd be wrong.
> There are tons of languages that support recursion Obviously. But I don't remember ever writing a recursive function in PHP for a website.
> It had just never occurred to me that people who spend their entire lives talking to databases wouldn't know how to talk to them directly. You're begging the question. Most people who use databases don't "spend…
It would be nice to see who's upvoting this so I could add them to an IDIOTS file. Any of the above people could obviously EASILY pick up whatever SQL you happened to be using. RTM could wipe the floor with you, the OP,…
> if you used an RDBMS in a non trivial app Depends on what you mean by "trivial". You can use a database for most of the things most websites use them for without ever using a JOIN. It just takes application logic…
> then I don't think that you actually have a working knowledge of SQL in any sense. Of course I have working knowledge of SQL, that's how I used MySQL back when we had to write things by hand. I just don't have a…
> Unless you're saying "I drew some lines on this piece of paper that represent the strings on the violin; I want you to play the piece of paper like you would the instrument." Yes, that's it. > In which case…
Part of it may be your questions, and part may be HOW you're asking (e.g. over the phone, or putting someone on the spot). 2) Not a lot of people write SQL by hand anymore. I used MySQL for years, long ago, and never…