RSSThe TSW Blog

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:

sql_intellisense1 

As you can see, you get IntelliSense for both keywords and MySQL functions. Parameter hinting is implemented as well:

sql_intellisense2

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:

sql_intellisense3

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:

sql_intellisense4

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 :)

Kasper (TSW) @ 1:53 pm in WebCoder

2 Responses to “TSW WebCoder 2010 sneak-peak part 6: SQL IntelliSense”

  1. Terry says:

    Wow!! Another killer feature. I can’t barely wait for testing all the new features. =)

  2. khh says:

    Pretty cool indeed. :)

Leave a Reply