Hi all:
I'm writing to get your opinions on some proposed changes to
SQL::Translator's GraphViz module, which I will complete & commit to
SVN once things have been discussed.
In broad strokes:
1. I want to add a "show_indexes" option, which will provide a block
below each table record showing details about the indexes set up. This
might be helpful for DBA's to see at-a-glance which columns are
indexed (particularly for multi-column indexes), which will tell them
whether they should perhaps remove an index that isn't needed, or
explain why queries on a certain combination of columns goes so slow.
2. I want to clean up the code for the part that determines how each
field is styled. Currently there's some crazy Perl wizardry happening
in a map{} block, which, while not totally obscure, is probably less
maintainable than a larger series of blocks. I think speed-wise the
two implementations will end up the same, and we can always benchmark
to see; but regardless, speed isn't all *THAT* important for SQLT,
given the nature of it.
3. I want to show size parameters for the 'decimal' and 'numeric'
types (which, at least on PostgreSQL, map to the same thing anyway).
4. For 'integer' columns, I want it to automatically pick between
'bigint', 'tinyint', 'smallint' based on the specified 'size'. This,
however, might vary from one SQL implementation to another, so I'll
leave this an additional option. That way the previous behaviour will
still happen unless the new option is set.
Basically, I want to maintain backward compatibility as much as
possible. For people using the GraphViz producer and that don't expect
the output to change, it shouldn't. But at the same time, it will
provide some more options for people like me.
I look forward to hearing all your thoughts on these.
Also, if there's anywhere else on SQLT that needs some work, please
let me know and I'll see if I'm competent enough to do it :-)
Cheers,
Jonathan Yu
PAUSE: FREQUENCY
SourceForge: jawnsy
------------------------------------------------------------------------------
--
sqlfairy-developers mailing list
sqlfairy-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlfairy-developers
