short : SQLite database manager author : lazi freemail hu (Lázár Zoltán) uploader : lazi freemail hu (Lázár Zoltán) type : biz/dbase version : 0.4 replaces : SQLMan.lha requires : MUI 3.8+, Texteditor.mcc 15.40+ architecture : m68k-amigaos; ppc-amigaos; ppc-morphos; i386-aros Filetype : application/x-lzh-compressed Size : 8.45M Date : 7-May-16 Download : 💾 https://de3.aminet.net/biz/dbase/SQLMan.lha
SQLite Manager database management tool This application based on the SQLite database engine and lets you create, view and modify databases. The database handling can happen via the GUI or there is an SQL command shell to serve any needs. There is a preliminary support for open xml spreadsheet files which can be converted to databases and even to native Amiga spreadsheets. This is a must for the Hollywood SQLite users. Created with Hollywood. (www.hollywood-mal.com) Features: ~~~~~~ - view database structure and content - edit database content - console for sql commands - create new table structure - memory database for testing purpose - xlsx spreadsheet import - external import modules - for every platform that supports mui or zune History: ~~~~~ Version 0.4 (06-May-16) - add: Load sql file switch to the console page on the register - fix: edit buttons do not crash when no table is created/loaded - fix: sql query string do sanity checks - add: xlsx import, new table import mode where field names created from the header (first row) of the table - fix: non ASCII field names are handled now - add: DBase file import plugin - fix: xlsx import improved (empty string, single/double quotes handling) - fix: added non breaking space for UTF to Latin conversion 0xC2A0 -> 0x20 - fix: Changed multiple menuitem shortcuts (Reported by: Stefan A. Haubenthal) - add: Help key opens the AmigaGuide documentation (Requested by: Stefan A. Haubenthal) - add: Handling attempt to open corrupt databases (Reported by: Stefan A. Haubenthal) - fix: Missed clearing listviews when opening new database - fix: Installer script did not copy all icons - fix: dump all created malformed 'insert into' lines - fix: clear lists after execute to prevent mismatched data displayed in the lists - fix: correct double quotes handling in dumped list " -> "" Version 0.3 (11-Jul-15) - fix: Amiga+C shortcut for close is changed to Amiga+k - add: output for console execute - add: console output to external window or inside the console prefs menuitem - fix: failed to list field names from an empty table - rem: no more need To insert a record after create a new table - fix: non latin characters in the field names made program crash - fix: file locked even after closed - fix: no more crash at clicking the values listviev at right from the last field - add: prefs menuitems to control insert position of console output (cursor/bottom) - Add: plugin infrastructure For import - fix: record list align integers right - add: sortable query lists - add: doubleclick an item in the field list reloads values with the order of the selected field - fix: columns list unnecessary refresh removed - fix: insert update sql command to the console only if the console is the active page - fix: a typo in the source blocked new file database creation (reported by Enrique) - fix: table names uppercase conversion removed because that not works with some accented characters - add: added rowid to values listview, hidden by default and other field attributes to the 'columns' listview - add: edit panel - add: full filename with path in the about window Version 0.2 (02-Nov-14) - add: set required minimum versions for plugins - fix: some listview selection problems, or at least hope so - add: multiselect for fields list - add: query listviews - add: detachable query results Version 0.1 (28-Sept-14) - Initial alpha release to check if it is useful enough for anybody.