meta user
network profile
| bio | website | sqlfiddle.com |
|---|---|---|
| location | Vancouver, WA | |
| age | 31 | |
| visits | member for | 1 year, 5 months |
| seen | yesterday | |
| stats | profile views | 50 |
Web Developer (strengths in ColdFusion, SQL, jQuery)
twitter - @sqlfiddle
Developer of http://sqlfiddle.com
|
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 |
|
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 |
revised |
Disable explicit commits in JDBC, detect them in SQL, or put the database in a readonly state Resolution |
