1 * Some way to deeply check to schema objects, e.g., for testing I
2 parse a MySQL schema, translate to Oracle, then parse the created
3 Oracle schema and want to check the two schema objects.
5 * Explore some way to pass an open database handle instead of a
6 schema and then query through DBI methods to get the schema
7 definition, somewhat a la SQL::Schema (which only works with
10 * Add "CREATE VIEW" support to existing parsers
12 * At least allow more pass-through of INSERT, DELETE, and UPDATE
15 * Add INSERT statements for xSV, Excel parsers to automatically
16 create INSERTs for each row of data in the source file
18 * Fix Sybase parser (which means really figuring out the dump format
19 we want to parse -- Sam, can you recommend something?)
21 * Add more parsers (though I need some ideas -- probably at least
22 one for SQLite since we have that producer)
24 * Somehow merge ClassDBI producer with CGI::FormBuilder or Template
25 Toolkit and some sort of automated CGI builder to create
26 view/create/edit/delete forms for objects based on schema defs
28 * Embetter the Diagram producer to use some real graphing algorithms
29 to distribute the tables so that the lines don't overlap so badly
31 * Integrate more with some standard XML schema representations,
32 maybe like Torque DB (http://db.apache.org/torque/), add parsers
35 * Possibly write a basic ANSI-92 SQL parser which could be extended
36 when writing other new parsers -- can anyone help me nail down a
37 URL that describes in detail that spec?
39 * Expand sql_translator.cgi to be a frontend for all producer
40 formats, not just the graphical ones; also improve the interface