Is there any sort of document which will give some guide lines to write a new tool like ij ?
I can't recall seeing one. I don't think that the program to extract query plan data from the XPLAIN tables and format it as XML needs to be very complicated; it needn't be anywhere near as complicated as 'ij', which is a very mature and complex program. I think that open source software development works best when we pursue small incremental improvements together as a community. It is easiest to discuss the specifics of a piece of software when there is some proposed software out there to discuss. So, don't worry too much about getting everything right the first time. Just try to write a small simple program that - connects to a database specified by the caller on the command line - retrieves query plan data for a particular statement from the XPLAIN tables in a particular schema, where both of those values are specified on the command line - formats the query plan data as XML and emits it to standard out using System.out.println() As the saying goes: try to write the smallest thing that could possibly work, then attach it to the JIRA issue and see what suggestions and observations the community has. Does this make sense? thanks, bryan
