AminetAminet
Search:
84736 packages online
About
Recent
Browse
Search
Upload
Setup
Services

biz/dbase/SQLMan.lha

Mirror:Random
Showing: m68k-amigaos iconppc-amigaos iconppc-morphos iconi386-aros iconi386-amithlon iconppc-warpup iconppc-powerup icongeneric icon
No screenshot available
Short:SQLite database manager
Author:lazi freemail hu (L?z?r Zolt?n)
Type:biz/dbase
Version:0.5
Architecture:m68k-amigaos,ppc-amigaos,ppc-morphos,i386-aros
Date:2019-06-21
Requires:MUI 3.8+, Texteditor.mcc 15.40+, codesets.library or charsets.library
Replaces:SQLMan.lha
Download:biz/dbase/SQLMan.lha - View contents
Readme:biz/dbase/SQLMan.readme
Downloads:2644

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.
Now with UTF8 support!

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.5 (20-Jun-2019)

 - chg: No linking of required plugins on OS4, MOS because it makes file write operations at program start
 - add: Stop button showing for some lengthy task to break the process
 - add: new importer plugin: Odysseypass for one-click opening browser passwords on OS4
 - fix: updated importer plugins (dbf, os4depot)
 - add: Dump table (SQL menu/dump table) dumps only the selected table
 - add: UTF8 support
 - chg: using MUI Royale 1.7
 - add: drop icon infrastructure added
 - add: eventfunc() men_open uses userdata for import modules can open database
 - add: modules should give back header after a "?" string as the second argument. This keeps compatibility with old modules
 - add: modules header can have a wodb logic tag to note that it can work without opened database which controls menuitem disabled flag

 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.


Contents of biz/dbase/SQLMan.lha
 PERMSSN    UID  GID    PACKED    SIZE  RATIO METHOD CRC     STAMP          NAME
---------- ----------- ------- ------- ------ ---------- ------------ -------------
[Amiga]                   9574   11420  83.8% -lh6- 3bf2 Jun  5 21:30 SQLMan/Amiga_OS3.info
[Amiga]                1707755 3439944  49.6% -lh6- d000 Jun 20 00:44 SQLMan/Amiga_OS3/SQLMan_OS3
[Amiga]                   9575   11420  83.8% -lh6- 8116 Jun  5 21:30 SQLMan/Amiga_OS3FPU.info
[Amiga]                1586577 3292740  48.2% -lh6- 01cb Jun 20 00:44 SQLMan/Amiga_OS3FPU/SQLMan_68881
[Amiga]                   9574   11420  83.8% -lh6- cad7 Jun  5 21:30 SQLMan/Amiga_OS4.info
[Amiga]                 219779  551744  39.8% -lh6- 42fe Jun 20 00:44 SQLMan/Amiga_OS4/muiroyale.hwp
[Amiga]                 254184  588032  43.2% -lh6- a630 Jun 20 00:44 SQLMan/Amiga_OS4/sqlite3.hwp
[Amiga]                1693915 3666452  46.2% -lh6- e031 Jun 20 00:44 SQLMan/Amiga_OS4/SQLMan_OS4
[Amiga]                 108716  304848  35.7% -lh6- 68f5 Jun 20 00:44 SQLMan/Amiga_OS4/xmlparser.hwp
[Amiga]                   9574   11420  83.8% -lh6- 3a35 Jun  5 21:30 SQLMan/AROSi386.info
[Amiga]                1928347 4437607  43.5% -lh6- c861 Jun 20 00:44 SQLMan/AROSi386/SQLMan_Aros
[Amiga]                   9575   11420  83.8% -lh6- 9703 Jun  5 21:30 SQLMan/Examples.info
[Amiga]                   1787    7995  22.4% -lh6- 0541 Dec  9  2001 SQLMan/Examples/dbasetest.dbf
[Amiga]                    153     288  53.1% -lh6- 8101 Mar 22  2016 SQLMan/Examples/dbasetest.dbf.info
[Amiga]                  35982  239891  15.0% -lh6- 7cc8 Feb 20  2013 SQLMan/Examples/Northwind.Sqlite3.sql
[Amiga]                   7982    8067  98.9% -lh6- 5fcd Oct 21  2014 SQLMan/Examples/Northwind.Sqlite3.sql.info
[Amiga]                  46342  200704  23.1% -lh6- 83bc Nov  2  2014 SQLMan/Examples/sqltest.data
[Amiga]                   2485    4452  55.8% -lh6- 441d Oct 21  2014 SQLMan/Examples/sqltest.data.info
[Amiga]                   6355    8932  71.1% -lh6- 1ffc Sep  3  2014 SQLMan/Examples/test.xlsx
[Amiga]                  13185   14723  89.6% -lh6- 6c25 Oct 21  2014 SQLMan/Examples/test.xlsx.info
[Amiga]                   9547   11420  83.6% -lh6- 9cb2 Jun  5 21:30 SQLMan/importers.info
[Amiga]                   2321    5553  41.8% -lh6- 4383 Jun  2 15:27 SQLMan/importers/importdbf
[Amiga]                    412     728  56.6% -lh6- c993 Jun  2 15:27 SQLMan/importers/odysseypass
[Amiga]                   1046    2134  49.0% -lh6- 4d24 Jun  2 15:27 SQLMan/importers/os4depotall
[Amiga]                   1188    9735  12.2% -lh6- f9ac Jun 20 00:17 SQLMan/Install_SQLMan
[Amiga]                    305     591  51.6% -lh6- 451f Jun 20 00:17 SQLMan/Install_SQLMan.info
[Amiga]                   9575   11420  83.8% -lh6- 9727 Jun  5 21:30 SQLMan/MorphOS.info
[Amiga]                 167299  373080  44.8% -lh6- 0669 Jun 20 00:44 SQLMan/MorphOS/muiroyale.hwp
[Amiga]                 252496  531672  47.5% -lh6- feac Jun 20 00:44 SQLMan/MorphOS/sqlite3.hwp
[Amiga]                1364943 2857580  47.8% -lh6- 6b39 Jun 20 00:44 SQLMan/MorphOS/SQLMan_MorphOS
[Amiga]                  64649  181612  35.6% -lh6- 874d Jun 20 00:44 SQLMan/MorphOS/xmlparser.hwp
[Amiga]                  11279   31005  36.4% -lh6- 8d07 Jun 20 00:44 SQLMan/SQLMan.guide
[Amiga]                   7889   10072  78.3% -lh6- c8b6 Jun  5 21:30 SQLMan/SQLMan.guide.info
[Amiga]                  11953   14832  80.6% -lh6- 1088 Jun  5 21:30 SQLMan/SQLMan.info
[Amiga]                  10388   12080  86.0% -lh6- cf84 Jun  5 21:30 SQLMan.info
[Amiga]                   2151    4724  45.5% -lh6- 29f2 Jun 20 00:27 SQLMan.readme
---------- ----------- ------- ------- ------ ---------- ------------ -------------
 Total        36 files 9578857 20881757  45.9%            Jun 20 21:12
Page generated in 0.02 seconds
Aminet © 1992-2024 Urban Müller and the Aminet team. Aminet contact address: <aminetaminet net>