vax_11

4 ms·

1.
by vax_11 17y ago
> 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), or knowledge of RDB
2.
by vax_11 17y ago
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 programmers; and on and o
3.
by vax_11 17y ago
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 can have working k
4.
by vax_11 17y ago
> 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 case. You can easily hav
5.
by vax_11 17y ago
> 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.
6.
by vax_11 17y ago
> There are tons of languages that support recursion Obviously. But I don't remember ever writing a recursive function in PHP for a website.
7.
by vax_11 17y ago
> 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 their entire lives" ta
8.
by vax_11 17y ago
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, and everyone else o
9.
by vax_11 17y ago
> 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 instead of SQL. Site
10.
by vax_11 17y ago
> 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 working knowledge of J
11.
by vax_11 17y ago
> 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 it's a worthless interv
12.
by vax_11 17y ago
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 wrote a join. Then OR