Tuesday, July 9, 2013

Sqlite Gui

https://addons.mozilla.org/en-US/firefox/addon/5817


Cross Platform, Firefox. This is the Sqlite Tool I've used the most. It's actually really good, especially considering it runs in a browser. It gets updated pretty frequently which is nice. There aren't (at least I can't find) keyboard shortcuts for executing queries. The UI isn't awesome, but it get's the job done. It's got decent import features,( delimited files, sql and xml). No Excel import but you can always save as a CSV file right? If you are importing a big file or querying a lot of data sometimes the script will timeout which may or may not cause issues. Usually you can opt to continue running the script and it sort's itself out eventually. When importing files they seem to be opened fully into memory, and so it often runs out of memory and stops the import even on files in the region of tens of megabytes.

No comments:

Post a Comment