SQL ICE - New Tool for Drupal Users who know MySql
Business Integration Technology has just released SQL ICE, the Internet Computing Environment for SQL Experts. Although SQL ICE can do a lot of things, one that may be of interest to Drupal Users is the ability to connect to your Drupal database and write MySQL queries to get reports that can be displayed, downloaded, and shared with other users.
All you need to do is add a Connection to the target database and write a query in SQL. The data is exposed as an XML document accessed by a REST Web service. For example, a simple query like:
Select
CCK/Views to Module Conversion
Proposal is currently available on the GSoC website:
http://socghop.appspot.com/student_proposal/show/google/gsoc2009/jkitchi...
Abstract
It is often the case where at first it may seem most fitting to design a content type through CCK, and then customize the way nodes of that type are displayed throughout the site. But there are instances when needs grow too complex and a custom module is needed. This process can be automated in order to encourage a natural workflow in growing from a simple site to a more complex one.
Read more