qBrowser 0.0.1 Released!
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
1
Nice little utility! I see a perfect match for cf and ajax here!
2
Glad you like it! The whole ajax thing has passed me by so far, because it so hard to get it to work in all browsers, but its a good idea. I'll look into it. As always, let me know if you guys find any bugs. Especially with the sql code coloring.
3
very handy ryan, thanks a million couple of things i noticed, the help link 404's and there are a couple of entries in the library "select * from PB" which are probably tests? One thing that would be handy would be to have the library datasource specific. If you need some help let me know thanks again
4
Mark, Yes, those were tests! Sorry about that. I will try to put out a new version today without the filler! And in case you are wondering, at the moment the only way to clear the library is to actually edit the history.xml file. Yes, the datasource specific thing would be nice I guess. I would just have to split up the library to use a different xml file instead because you would want your history to not be tied to a datasource. Thanks for the suggestions, I'll see what I can do.
5
By the way guys, you can use cfqueryparam tags in this as well. So if you are trying to debug one of your queries, you should be able to copy and paste and just fill in your values straight instead of variables. Only thing is, if you use cfqueryparam, dont save the query to your history or to the library. because of the <> tags, it will screw things up when trying to view it later. I am working on a fix for that though.
6
hi ryan, we're all having a whale of a time using it here. Is there anyway to comment out parts of a query?# thanks mark
7
That depends on your database. In some databases, you can use /* */ to make a comment. Im not sure about others. Make sure you guys get the newest version too, shouldn't take you long to upgrade. just delete the old and drop in the new! If you want to keep your history and library, just backup the data/history.xml file and drop it in over the new one.
8
Sorry for the double comment, but my previous one was screwing up my layout ;S Hey guys, Ive got a new version out there now. 0.0.2. You can see whats new here: http://www.ryanguill.com/blog/index.cfm?mode=entry&entry=E19ECF57-40CA-6D1C-8A8A6E1690536E89