He3 SQL Integration
In case you hadn't heard, I am helping code He3 as part of the RichPalette.com team. My specific focus is to deliver the SQL editor and database integration features.
This is of particular interest to me as a corporate IT Application Development programmer since 60 to 80 percent of my day is spent writing ad-hoc queries to support our user base. The remainder of my work on new development is focused on delivering ColdFusion interfaces and SQL Server stored procedures to deliver more efficient versions of components of our ERP system.
I've essentially started from the point of "what do SQL Query Analyzer and Enterprise Manager offer me that I find useful and what do I wish it would do?". I've solicited the input of many local developers at the last Atlanta ColdFusion User Group meeting about SQL IDE's and asked for the best and worst features of Toad, SQL *Plus and also some Eclipse SQL IDE's.
I will be publishing a list of the initial SQL features soon to test interest levels. I thought I would throw the floor open to anyone who reads this blog for further suggestions until I can get the public bug tracker and feature request page configured. So have at it. There have already been some excellent suggestions across other blogs about non-SQL features.
Which databases are you guys and gals using with ColdFusion? My assumptions are SQL Server, Oracle, Access and MySql. What else would you need to see support for?