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

biz/dbase/SQLMan.lha

Mirror:Random
Showing:m68k-amigaosppc-amigaosppc-morphosi386-arosi386-amithlonppc-warpupppc-powerupgeneric
No screenshot available
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
Date:2016-05-06
Download:http://aminet.net/biz/dbase/SQLMan.lha - View contents
Readme:http://aminet.net/biz/dbase/SQLMan.readme
Downloads:1466
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.


Contents of biz/dbase/SQLMan.lha
PERMISSION  UID  GID    PACKED    SIZE  RATIO METHOD CRC     STAMP     NAME
---------- ----------- ------- ------- ------ ---------- ------------ ----------
[unknown]                 9574   11420  83.8% -lh6- ac8d Jul 11  2015 SQLMan/Amiga_OS3.info
[unknown]              1471299 2619612  56.2% -lh6- 6217 May  6 22:38 SQLMan/Amiga_OS3/SQLMan_68881
[unknown]              1557706 2683792  58.0% -lh6- ab87 May  6 22:38 SQLMan/Amiga_OS3/SQLMan_OS3
[unknown]                 9574   11420  83.8% -lh6- e8d9 Jul 11  2015 SQLMan/Amiga_OS4.info
[unknown]              2109537 3809531  55.4% -lh6- 1e5d May  6 22:38 SQLMan/Amiga_OS4/SQLMan_OS4
[unknown]                 9573   11420  83.8% -lh6- e7ef Jul 11  2015 SQLMan/AROSi386.info
[unknown]              1793716 3402753  52.7% -lh6- f570 May  6 22:38 SQLMan/AROSi386/SQLMan_Aros
[unknown]                 9575   11420  83.8% -lh6- 9703 Jul 11  2015 SQLMan/Examples.info
[unknown]                 1787    7995  22.4% -lh6- 0541 Dec  9  2001 SQLMan/Examples/dbasetest.dbf
[unknown]                  153     288  53.1% -lh6- 8101 Mar 22 07:01 SQLMan/Examples/dbasetest.dbf.info
[unknown]                35982  239891  15.0% -lh6- 7cc8 Feb 20  2013 SQLMan/Examples/Northwind.Sqlite3.sql
[unknown]                 7982    8067  98.9% -lh6- 5fcd Oct 21  2014 SQLMan/Examples/Northwind.Sqlite3.sql.info
[unknown]                46342  200704  23.1% -lh6- 83bc Nov  2  2014 SQLMan/Examples/sqltest.data
[unknown]                 2485    4452  55.8% -lh6- 441d Oct 21  2014 SQLMan/Examples/sqltest.data.info
[unknown]                 6355    8932  71.1% -lh6- 1ffc Sep  3  2014 SQLMan/Examples/test.xlsx
[unknown]                13185   14723  89.6% -lh6- 6c25 Oct 21  2014 SQLMan/Examples/test.xlsx.info
[unknown]                 9547   11420  83.6% -lh6- 9cb2 Jul 11  2015 SQLMan/importers.info
[unknown]                 2301    5489  41.9% -lh6- d1b0 Mar 21 15:43 SQLMan/importers/importdbf
[unknown]                 1043    2125  49.1% -lh6- f7f7 Apr 13  2015 SQLMan/importers/os4depotall
[unknown]                 1143    9589  11.9% -lh6- 12d2 May  6 22:52 SQLMan/Install_SQLMan
[unknown]                  307     591  51.9% -lh6- 310b May  6 22:52 SQLMan/Install_SQLMan.info
[unknown]                 9576   11420  83.9% -lh6- dc71 Jul 11  2015 SQLMan/MorphOS.info
[unknown]              1710146 2967593  57.6% -lh6- f62b May  6 22:38 SQLMan/MorphOS/SQLMan_MorphOS
[unknown]                10401   28631  36.3% -lh6- 9072 May  6 22:58 SQLMan/SQLMan.guide
[unknown]                 7889   10072  78.3% -lh6- c8b6 Jul 11  2015 SQLMan/SQLMan.guide.info
[unknown]                11953   14832  80.6% -lh6- 1088 Jul 11  2015 SQLMan/SQLMan.info
[unknown]                10388   12080  86.0% -lh6- 5928 Jul 11  2015 SQLMan.info
---------- ----------- ------- ------- ------ ---------- ------------ ----------
 Total        27 files 8859519 16120262  55.0%            May  6 21:24

Aminet © 1992-2017 Urban Müller and the Aminet team. Aminet contact address: <aminetaminet net>