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.


Jul
8
revised Why don't relational databases support returning information in a nested format?
added 912 characters in body
Jul
8
answered Learning Java in a couple of days and preparing interview presentation
Jul
7
comment Why don't relational databases support returning information in a nested format?
Result sets and tables are of a kind. Date calls them relations and relvars respectively (by analogy, 42 is an integer, whereas a variable x can have the value of integer 42). The same operations apply to relations and relvars, so their structure needs to be compatible.
Jul
7
awarded  Nice Answer
Jul
6
answered Why don't relational databases support returning information in a nested format?
Jul
5
answered OOP design question
Jul
5
awarded  Nice Answer
Jan
27
comment What's your favourite quote about programming?
@David Kendal: Nice! Similarly, Henry David Thoreau said, "Simplify, Simplify." Which always makes me think, "Simplify."
Jan
27
comment What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
@Thorbjørn: Good idea, that would allow us to log most of the client's mistakes, but it wouldn't meet their goal of "we won't have any more issues." Anyway, this anecdote is from the 1990's. I earnestly hope that the developer who refused to check return status from our API is now working in a different career.
Jan
19
awarded  Good Answer
Jan
14
awarded  Good Answer
Jan
11
awarded  Nice Answer
Jan
9
awarded  Good Answer
Dec
28
awarded  Good Question
Dec
28
awarded  Nice Question
Dec
28
awarded  Student
Dec
24
awarded  Nice Answer
Dec
10
comment What's your favourite quote about programming?
@Keyo: Yeah, I thought of that take on it. I still think the quote is really clever.
Nov
28
comment What is the (craziest, stupidest, silliest) thing a client/boss asked you to do?
@Thorbjørn: It was a C API, so there were no exceptions. Just return values. Since the client programmer refused to check return values, there was not much we could do.
Oct
24
awarded  Nice Answer