Entries for Tag: 'qbrowser'
A call to those 300 some odd of you that have downloaded qbrowser:
I am wanting to put out an updated version soon with a few small improvments but nothing spectacular. And I have received absolutely no suggestions for it, even though it has been downloaded so many times. Either I did an excellent job, or just nobody has taken the time to let me know what they think. (Im hoping for the former!) So if you have been using it and thinking, man, I wish it would do this
, nows your chance. Use the comments below or shoot me an email if you have any suggestions. Or bug reports.
Edit: Oh yeah, if you want to try out qBrowser so you know what im talking about, you can find it here: www.ryanguill.com/docs/
Posted on Wed. December 28, 2005 by Ryan Guill #
I just put out a new version of qBrowser. New in this release:
You can now save your results as csv, tab delimited or xml format.
You have the option to open your results in a popup window, which allows you to have multiple resultsets open at the same time for comparisons.
A new sql reference page has links to sql reference websites for several dbms. If you have any you want me to add, let me know.
Along with many other settings, you can now set a setting in the application.cfm file that will automatically select a certain datasource on load.
Also, the application.cfm page as well as the index.cfm page (that does all of the work) are pretty well commented now. Check the application.cfm file to see all of the different settings you have.
There are now links above the sql textarea box that will allow you to expand and contract the box based on your needs. It should save your setting when you reload the page.
There is a new feature that tells you the current version you are running, and if the server you are running the application on has access to the internet, it will periodically check to see if there is an update for the application available.
Added a variable to report execution times for cf 6.1 users. It is slightly inflated because it also includes processing time for the cfinclude, but it is better than nothing...
And a few other bug fixes. I recomend anyone already running qbrowser update to this newest version.
You can download the app from http://www.ryanguill.com/docs/
As always, let me know if you have any suggestions, bug reports or feature requests.
Posted on Wed. December 07, 2005 by Ryan Guill #
Alright guys, the time has come.
qBrowser now has cfmx 6.1 support, the ability to not pull in all of your datasources, but you specify exactly which ones it has access to, a few new sql restriction possibilities, htmleditformat() has been added to the results view, a couple of bug fixes, and the big one: you can now save the results of your query as a csv file and download it!
The bug fixes alone are worthy of an upgrade, so download it here:
If you haven't heard about qBrowser yet, check this post
and Ben Forta's Post
Thanks, and as always, let me know if you have any problems, suggestions or comments.
Posted on Thu. December 01, 2005 by Ryan Guill #
I have a beta of a new version of qBrowser that should allow cfmx 6.1 developers to play too. Problem is, I dont have a local development copy of 6.1 to test on.
So if you wouldn't mind testing the beta out for me, email me at email@example.com
and ill get you a copy of the beta to try out.
I am fairly sure that everything works, but I want someone else to verify that before I release it to the wild.
Thanks in advance!
Posted on Thu. December 01, 2005 by Ryan Guill #
Well, already at qBrowser version 0.0.2.
A couple bug fixes, a little layout change thats a little nicer, the ability to clear your library (an actually clear library to start with this time!), support for cfqueryparam in the sql (with support in the history and library, as well as outputting the params after it is run) and a couple other small things.
As always, let me know
if you find any bugs, or if you have any feature requests or suggestions.
One of the things I will be working on is the ability to tie library sql statements to a certain datasource, but thats a little down the road.
Also, some have mentioned using ajax for this app. Just so I am clear, what would you like to see ajax-ified exactly? You wouldn't want it to start running the sql statement until you are completely ready for sure...
You can download the new version from ryanguill.com/docs/
The file should be qBrowser_0_0_2.zip.
Posted on Wed. November 30, 2005 by Ryan Guill #
I have created an app internally for a company I worked for a while back, and got the okay to release it to the public.
It is a query browser (qbrowser) that allows you to test out your sql queries against your coldfusion datasources. It has features such as sql code coloring, history and a library, as well as the ability to restrict the sql statements that are allowed. Its great for teaching sql, as well as being able to quickly test and see live data in your datasources. You can download it from www.ryanguill.com/docs/
As always, if you have any questions, please feel free to contact me
Posted on Tue. November 29, 2005 by Ryan Guill #