I am thinking of publishing an article with Linux Journal on the subject of exporting Oracle tables to SQLite.
I have written a number of scripts to do this, and I am able to use sqlplus to reliably create compatible tables and send data to SQLite in CSV mode over a fifo.
I've also implemented the dg4odbc gateway into the unixODBC implementation of SQLite, but I have found this to be much more brittle than the CSV mode.
Are there any technical reviewers that would like to examine what I have written in advance?