Apr 30, 2008

Things to do next

Ok, release 3.20 is out and now is the time to think what to do next. There's a lot of interest in feature which puts results of every query into a new result tab. I personally think it's not such a great idea. It's easy to end up with a lot of tabs and then it's too confusing. What I am thinking about doing is to add query results to a new tab when Shift key is pressed at the time of query execution. Will implement it this way and see how it works. The other thing I want to improve Intellisense. SQL is not easy language to build Intellisense for. It's not very structured but there's always ways to improve. Another feature which I probably will put into one of the next releases is option to put connection into a read only mode. Basically it will detect any INSERT/UPDATE/DELETE statements and will not execute them.
Couple days ago decided to do some performance testing between SqlDbx and some other similiar products. Was pleasantly surprised that SqlDbx is faster then any of them and sometimes by large margin and I still thing there's room for improvement.


miken175 said...

What about adding collapsing regions?

--REGION Declarations

Could be useful in very long script/procedures.

SqlDbx said...

That's a possibility for one of the next releases.

Matt said...

I just found your product and am finding it quite useful... VERY FAST, which is nice. Keep up the great work!

I have two suggestions for future releases:
1. Color syntax for variables (@varname)
2. Option to filter object listings by name. For example, I'm working with a third party software that has over 3800 tables in one database. It would be nice to apply a filter so that I can limit the tables viewed to those that I'm currently working on.

Another comment, if I may... I like the general simplicity of the layout and features along with the speed (very fast! did I say that already :). As with just software, it can quickly become bloatware and bog down. So, I encourage you carefully select feature requests so that you don't lose simplicity and speed. If that means my suggestions are not implemented, then so be it.


SqlDbx said...

Color for variable probably will happen at some point. About the filter. One of the feature which is usefull in this situation is Favorite objects. It allows you to easily add objects you work on Favorites folder.
The whole point of SqlDbx is to be fast and straight forward. We are definetely will not do anything to make it slow and bloat.