146 reputation
113
bio website sqlfiddle.com
location Vancouver, WA
age 32
visits member for 2 years, 4 months
seen Mar 1 at 19:43

Web Developer (strengths in ColdFusion, SQL, jQuery)

twitter - @sqlfiddle

Developer of http://sqlfiddle.com

Don't tell me I can't be a bear!


Dec
4
awarded  Popular Question
Nov
21
awarded  Nice Question
Sep
11
awarded  Notable Question
Dec
15
comment Reordering data in a table
Yes, I use the github issue list to keep track - github.com/jakefeasel/sqlfiddle/issues. Strange that you had trouble with your iPad - works fine on my iPhone (using both chrome and safari). Who knows.
Dec
15
comment Reordering data in a table
I've just now posted a fix so that your query works with Web SQL too.
Dec
15
comment Reordering data in a table
I didn't realize there were errors with SQL Fiddle when switching between SQLite engines - gotta let me know these things :) I'll take a look into this, but please let me know if you come across other issues like this.
Nov
5
awarded  Popular Question
Oct
3
comment Pivoting data for stacked charts (grouping and creating new columns for each distinct value)?
Phil - I don't understand your SQL Fiddle comment. If you edited his Fiddle, then you should have gotten a new link associated with your edit. It doesn't look like you posted that link anywhere, so there is no way for anyone to see your edits.
Sep
9
awarded  Quorum
Aug
21
comment Learning DB2 without a local install
BTW - I'm planning on rolling out DB2 as an option for SQL Fiddle in the near future (using Express C edition).
Aug
16
awarded  Talkative
Jun
28
accepted Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Jun
28
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Great, thanks again Phil. I have been able to make good use of this technique for Oracle. It makes me wish other databases supported deferred constraints.
Jun
21
comment How to efficiently check EXISTS on multiple columns?
@ypercube it's hard to tell how much trouble they caused (if any), however I'd certainly prefer to keep the size down to a smaller level. I guess I could be more proactive about such things (smaller db size cap, for instance) but I'd rather not for now. Thanks!
Jun
21
comment How to efficiently check EXISTS on multiple columns?
BTW - you can add stored procedures.
Jun
21
comment How to efficiently check EXISTS on multiple columns?
Agh! 30k rows in sql fiddle! You're being cruel to my little website. Isn't looking at the execution plan adequate to compare performance?
Jun
20
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@RickJames DDL creates implicit commits in MySQL and Oracle, but not in PostgreSQL or SQL Server. The mechanisms I've implemented following this post handle that concern. As far as entering arbitrary SQL - that's the whole point!
Jun
19
comment Running total with count?
@AaronBertrand looks like I have a bit more work to do on the whole UX side of things.... There are actually two buttons for designating batch separators, one under the schema panel and one under the query panel. You've changed the schema panel separator but not the query one (which is where you're attempting to use it). sqlfiddle.com/#!6/bf076/1
Jun
19
comment Running total with count?
@AaronBertrand sorry about that - was a bug with the system.
Jun
19
comment Running total with count?
Similarly for cursors: sqlfiddle.com/#!6/2464b/5