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

biz/dbase/SQLMan.lha

Mirror:Random
Showing: m68k-amigaos icongeneric icon
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.6
Architecture:m68k-amigaos,ppc-amigaos,ppc-morphos,i386-aros
Date:2025-02-16
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:2922

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.6 (11-Feb-2025)

	- chg: OS4Depot import module needs HURL.hwp plugin for SSL HTTP communication
	- fix: some OS3.x fix made it to work with MUI3.8, but still has problems
	- add: modules list is shown in the about window
	- chg: updated SQLite plugin to 1.2 in the archive
	- add: added some balance class between gui elements
	- add: set screen title to program name and version
	- chg: SQL errors do not close database
	- fix: mui ids cannot handle some non-latin chars, so field names are converted
           to unique latin strings in gui xml
    - fix: xlsx importer - removed own hungarian UTF8 converter function needed prior
           Hollywood UTF8 support
	- fix: query panel ArrowRight button made it properly with imagebutton class
	- fix: OS4Depot import module raw string functions fixed against UTF8
	- fix: OS4Depot import module failed if subcategory was missing
	- add: dropfile support for open database from the first icon
	- add: about window displays sqlite3 engine version
	- fix: dbf importer convert strings to UTF8 if needed                         

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]                  10392   12080  86.0% -lh6- c946 Feb 16 17:05 SQLMan.info
[Amiga]                   9574   11420  83.8% -lh6- f717 Feb 29  2024 SQLMan/Amiga_OS3.info
[Amiga]                 363952  754780  48.2% -lh6- 3176 Feb 16 16:53 SQLMan/Amiga_OS3/hurl.hwp
[Amiga]                1709631 3401812  50.3% -lh6- 6eaa Feb 16 16:53 SQLMan/Amiga_OS3/SQLMan_68881
[Amiga]                   1757    4952  35.5% -lh6- 6ae6 Feb 16 17:04 SQLMan/Amiga_OS3/SQLMan_68881.info
[Amiga]                1751311 3493088  50.1% -lh6- 1fd0 Feb 16 16:53 SQLMan/Amiga_OS3/SQLMan_OS3
[Amiga]                   1758    4952  35.5% -lh6- 13c5 Feb 16 17:04 SQLMan/Amiga_OS3/SQLMan_OS3.info
[Amiga]                   9574   11420  83.8% -lh6- 2d99 Feb 29  2024 SQLMan/Amiga_OS4.info
[Amiga]                 511406 1215924  42.1% -lh6- 5323 Feb 16 16:53 SQLMan/Amiga_OS4/hurl.hwp
[Amiga]                 219779  551744  39.8% -lh6- 42fe Feb 16 16:53 SQLMan/Amiga_OS4/muiroyale.hwp
[Amiga]                 254414  588296  43.2% -lh6- 7842 Feb 16 16:53 SQLMan/Amiga_OS4/sqlite3.hwp
[Amiga]                1906461 4043788  47.1% -lh6- f980 Feb 16 16:53 SQLMan/Amiga_OS4/SQLMan_OS4
[Amiga]                   7280    7832  93.0% -lh6- 88a1 Feb  6 21:44 SQLMan/Amiga_OS4/SQLMan_OS4.info
[Amiga]                 108716  304848  35.7% -lh6- 68f5 Feb 16 16:53 SQLMan/Amiga_OS4/xmlparser.hwp
[Amiga]                   9574   11420  83.8% -lh6- 6229 Feb 29  2024 SQLMan/AROSi386.info
[Amiga]                 423517 1032068  41.0% -lh6- be5d Feb 16 16:53 SQLMan/AROSi386/hurl.hwp
[Amiga]                2108063 4836097  43.6% -lh6- d8a0 Feb 16 16:53 SQLMan/AROSi386/SQLMan_Aros
[Amiga]                    481    1132  42.5% -lh6- 6087 Feb  6 21:44 SQLMan/AROSi386/SQLMan_Aros.info
[Amiga]                   9574   11420  83.8% -lh6- 82e1 Feb 29  2024 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]                   9546   11420  83.6% -lh6- 9a02 Feb 29  2024 SQLMan/importers.info
[Amiga]                   2382    5721  41.6% -lh6- a55d Feb  6 18:51 SQLMan/importers/importdbf
[Amiga]                    431     758  56.9% -lh6- c3c2 Feb  6 18:54 SQLMan/importers/odysseypass
[Amiga]                   1325    2653  49.9% -lh6- 8546 Feb  6 18:51 SQLMan/importers/os4depotall
[Amiga]                   1253   10295  12.2% -lh6- 9a33 Feb 29  2024 SQLMan/Install_SQLMan
[Amiga]                    306     591  51.8% -lh6- 49ef Feb 29  2024 SQLMan/Install_SQLMan.info
[Amiga]                   9576   11420  83.9% -lh6- ca72 Feb 29  2024 SQLMan/MorphOS.info
[Amiga]                 570228 1394628  40.9% -lh6- a42b Feb 16 16:53 SQLMan/MorphOS/hurl.hwp
[Amiga]                 167299  373080  44.8% -lh6- 0669 Feb 16 16:53 SQLMan/MorphOS/muiroyale.hwp
[Amiga]                 252935  532788  47.5% -lh6- 4433 Feb 16 16:53 SQLMan/MorphOS/sqlite3.hwp
[Amiga]                1567480 3222196  48.6% -lh6- 42a6 Feb 16 16:53 SQLMan/MorphOS/SQLMan_MorphOS
[Amiga]                   5907    5907 100.0% -lh0- 71b4 Feb  6 21:44 SQLMan/MorphOS/SQLMan_MorphOS.info
[Amiga]                  64649  181612  35.6% -lh6- 874d Feb 16 16:53 SQLMan/MorphOS/xmlparser.hwp
[Amiga]                  12228   33428  36.6% -lh6- 6801 Feb 16 16:53 SQLMan/SQLMan.guide
[Amiga]                   7889   10072  78.3% -lh6- e7b8 Feb  6 21:43 SQLMan/SQLMan.guide.info
---------- ----------- ------- ------- ------ ---------- ------------ -------------
 Total        42 files 12204919 26580694  45.9%            Feb 16 23:32
Page generated in 0.02 seconds
Aminet © 1992-2024 Urban Müller and the Aminet team. Aminet contact address: <aminetaminet net>