1,391 reputation
820
bio website karwin.com
location California
age 46
visits member for 3 years, 10 months
seen Jun 25 at 23:41

I'm Senior Knowledge Manager at Percona, a services company specializing in the MySQL database.

I've been a software engineer since 1987, and my specialty is as an SQL maven. I also have experience programming in Java, PHP, Perl, C, JavaScript, and I have many other coding skills.

I've written a book, SQL Antipatterns: Avoiding the Pitfalls of Database Programming from Pragmatic Bookshelf, based on the most common SQL problems I've answered on Stack Overflow and other forums, mailing lists, and newsgroups over the past 15 years.


Jan
9
awarded  Nice Answer
Nov
29
comment Why don't relational databases support returning information in a nested format?
@EamonNerbonne, yes, Date also says that it's more tolerable to support RVA's in result sets, and less tolerable in the relvars (i.e. persistent tables defined in your schema). FoundationDB is another vendor that provides an extension to SQL that expresses RVA's. They use it to combine multiple rows from a joined table into one RVA in a row of the result set. See foundationdb.com/layers/sql/SQL/dml/…
Nov
29
awarded  Good Answer
Nov
28
comment Why don't relational databases support returning information in a nested format?
@EamonNerbonne, symmetry of relational operations. For example, projection. If I SELECT some sub-attributes out of an RVA, how can I apply a reverse operation against the result set to reproduce the original hierarchy? I found page page 293 of Date's book is on Google Books, so you can see what he wrote: books.google.com/…
Sep
9
awarded  Yearling
May
19
comment Why don't relational databases support returning information in a nested format?
@EamonNerbonne, this is the only way relational operations can be symmetric.
Feb
26
awarded  Caucus
Feb
18
comment What are non-programming mistakes that a programmer should avoid?
@StephaneRolland, yes, I'm wearing the Smartglove right now.
Feb
18
awarded  Nice Answer
Sep
9
awarded  Yearling
Sep
10
awarded  Yearling
Aug
30
revised What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
added 9 characters in body
Aug
30
comment What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
And development of the module will complete 2012-12-31.
Aug
29
answered Multiple Joins or Simple Readable Database Calls
Aug
19
revised Should we hire someone who writes C in Perl?
added 857 characters in body
Aug
19
awarded  Nice Answer
Aug
4
comment What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
@NimChimpsky: Some of the client's "issues" were cases where they wanted the software to do something it was not designed to do, or when they made fat-finger mistakes (like misspelling SQL keywords). They reported these cases as "bugs".
Jul
17
awarded  Nice Answer
Jul
10
comment Completing a project successfully despite hostile management?
I didn't get that from the OP's description. "Heading toward a death march" could mean the project is just beginning, or that the project has been going on for a while but the pace is changing. But I agree with you that adding people to a new project is just fine. :-)
Jul
10
comment Completing a project successfully despite hostile management?
Adding more people to a late project makes it more late.