A couple of nice-to-haves would be:
Ctrl-Enter to run the code rather than having to use the mouse?
and also, after running the code, can we be dropped at the end of the page? Normally, one tries stuff, progresses, then adds more - so the focus of interest is normally at the bottom of the page. It's irritating to have to scroll down each time and it would be deadly if we could be dropped to the bottom of the page.
As I said, these are nice to haves and kudos for your amazing achievement so far - I particularly appreciate the fact that you cater for Firebird - a totally underrated and overignored system that (like PostgreSQL) is (vastly) superior to MySQL (
<rant> how is it the most successful of the F/LOSS servers despite being the worst of them?
</rant>...) - is the code up on GitHub or similar yet - you did mention that at one point.
Finally, could you please make one-off payments possible? I don't like the idea of recurring payments and would just like to make a (small) one-off donation for the excellent service you provide to the community.
Hi again Jack, a few things too big to put into a comment.
The Ctrl-Enter thing works but, as I said earlier, erratically. It seems to drop you somewhere in the middle of the page regardless of where you were last editing - which can in fact be confusing! I've noticed this behaviour on Windows, Linux and Mac Airbook.
EXPLAIN EXTENDED doesn't work on MySQL 8 but does on MySQL 5.7?
EXPLAIN does work for both.
I discovered the above issue when looking for timings for MySQL. They don't come with the
EXPLAIN EXTENDED whereas they do with PostgreSQL (gotta love it!). Would there be a way of including timings by default?
With the Microsoft Edge browser (for the 5 people who use it! :-) ), if you try and copy and paste the results from a db<>fiddle query into the StackExchange text boxes, it looks like this (compare with the answer and the fiddle it was copied in from using Chrome):
Every single column name/field becomes a new line:
As for Informix, I wrote to them:
Dear Sir or Madam, I wish to use your Informix Innovator-C Edition for
a not-for-profit project and am wondering if the licence will permit
this? The site/project is one which permits users to test SQL against
servers to which they may not have (immediate/current) access (small
data volumes). I believe that such usage would be covered by the "free
for development, testing, and small production use." section of the
licence (from here: https://www.ibm.com/products/informix/editions),
but would just like to confirm. Should you require any further
information, please don't hesitate to contact me. Best regards,
and they replied:
Thank you for contacting the IBM Service Center. I refer to your
e-mail received 05.11.2019
You have reached the IBM UK General Enquiries.
With your inquiry please contact our Support team for Informix
products on +44 800 013 0333. Please note this department is only
reachable via phone as it hasn’t got a general email address.
Or visit our website on http://www-306.ibm.com/software/data/
Or you can also contact our Software Team on +44 239 228 2340
If we can be of any further assistance please do not hesitate to
contact us at firstname.lastname@example.org Any requests sent through to the
representative directly will not be actioned immediately.
I tried ringing but got put on hold and as it's an international call for me, I didn't fancy racking up large bills. If you are UK based (?) maybe you might fancy ringing the 0800 number (free from UK AFAIK)? This isn't a big deal for me personally - I haven't used Informix in years, but it was my first RDBMS (and a good one), so there's a residue of affection but it appears to be slowly withering on the vine in any case. A quick check shows 68 questions all told with the Informix tag, slightly behind Firebird with 77.
Should you require any further information/testing, please don't hesitate to ping me. Again, I would like to thank you for your sterling efforts on behalf of the community to date.