TSW WebCoder 2010 sneak-peak part 6: SQL IntelliSense
April 22, 2010
SQL IntelliSense was actually on my TODO list for WebCoder 2009, but I couldn't quite figure out the right way to do it. The easy way would have been to provide IntelliSense for SQL keywords in the Database result window, but that wasn't enough. Here's a couple of screenshots of the most basic functionality, helping you write SQL for the Database part of WebCoder much faster and more efficient:
As you can see, you get IntelliSense for both keywords and MySQL functions. Parameter hinting is implemented as well:
That's all very nice for writing and testing your SQL, but with help from the help of Inline SQL highlighting, we can actually provide the same IntelliSense directly in your code:
It tries to detect when you write a string that is likely SQL and then highlights it as such. I think this is pretty cool, but the next screenshot is really what it's all about:
When you attach a database to your project, or simply have one open in the "Databases" panel, WebCoder will read all the tables and their columns and keep them in memory, allowing you to access them through IntelliSense. It will use your aliases and propose table names, aliases and even columns for tables. I have using this feature for a couple of months now, and I absolutely love it - I hope you will too! Let me know what you think :)
Wow!! Another killer feature. I can’t barely wait for testing all the new features. =)
Pretty cool indeed. :)