db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Guide line for writing a new tool?
Date Fri, 28 May 2010 14:20:34 GMT
> 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


Mime
View raw message