Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 14
Newest
 Curious
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 66 votes cast
Jul
15
comment PostgreSQL partial index unused when created on a table with existing data
Sorry for the delay Erwin - there are some more details that I discovered after the fact, and with your reminder I'll chime in with those. Your answer was quite helpful, thanks!
Jul
15
accepted PostgreSQL partial index unused when created on a table with existing data
May
2
awarded  Curious
May
1
asked PostgreSQL partial index unused when created on a table with existing data
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?