146 reputation
113
bio website sqlfiddle.com
location Vancouver, WA
age 33
visits member for 2 years, 9 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
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.
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.
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).
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
Jun
19
comment Running total with count?
Aaron - I really need to make this new "Query Terminator" feature I added more obvious as to its function (clearly my "documentation", such as it is, is pathetically lacking). When you change the query terminator to something other than semi-colon for your quirky update, it works fine: sqlfiddle.com/#!6/2464b/4 This is because it runs the whole set of code as a single batch, rather than breaking them up into isolated statements.
Jun
10
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@Phil - if you want to post your comment as an answer, I'll happily mark it as the solution. Thanks again!
Jun
10
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@NickChammas I had thought about that approach, but due to memory concerns I'd prefer not to go that route.
Jun
8
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@NickChammas I need to disable commits so that I can keep the schema (as defined by the left side panel) in a fixed state. There could be any number of people writing queries against the same schema trying to solve the same problem. To prevent them from interfering with each other, I need to be sure to keep the structure and data from changing. This is accomplished via rolled-back transactions, but that doesn't happen if the right-side code is committed.
Jun
7
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@Phil ah! Sorry, I was being a bit slow there. Yeah, that is a cool idea. Might be able to use that.
Jun
7
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
@Phil the only problem there is that I don't have (and don't really want) control over the definition of each of the tables (those are defined on the left panel). So that DEFERRABLE INITIALLY DEFERRED clause wouldn't be there (unless there is some way to do that automatically for all tables - say via a system trigger that responds to create table statements? Ugh)
Jun
7
comment Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state
Worth mentioning - I also did a lot of research looking into "pre-commit" triggers. It appears those do not exist, so unfortunately that's not an option either.