Sqlite3 @file leo4sqlite.py @nocolor @ **leo4sqlite.py plugin** *This node belongs at the top level of 'leoPlugins.leo'* | **Notes** This script needs to be streamlined and polished, which I intend to do (in the end I'm a perfectionist). Any suggestions toward that end are welcome! **Issues** 1. The 'switchboard code' is convoluted - it jumps around much more than necessary, I\'m sure of that... and now I'll eat my words. After looking at it again I don't think it's too bad, other than mixing the creation of the @db3 and @tbl nodes with the code for routing table imports/exports. .. **Ideas** | 1. Recent files for blob commands? | 2. Should settings be kept in myLeoSettings.leo instead of the current outline? It seems like a better idea to me - see the third child of this node for an example of leo4sqlite settings. | 3. I would like to see sqlite-clear-data moved from the top of the plugin menu to a less readily accessible spot. | 4. Add a setting - overwrite existing tables? It could save a *little* time, but it would be easier to make a mistake and lose valuable data. | 5. Dialog icons (top left corner)? | **The commands currently added by the plugin are:** | sqlite-import-table | sqlite-export-table | sqlite-open-blob | sqlite-view-blob | sqlite-insert-blob | sqlite-extract-blob | sqlite-reset-temp | sqlite-clear-data | sqlite-purge-files | I want to make this the best plugin I can rather than rushing to finish it. Leo deserves no less! Please provide any feedback you can and don't hesitate to suggest improvements! :-)