Click Here
home features news forums classifieds faqs links search
5775 members 
Amiga Q&A /  Free for All /  Emulation /  Gaming / (Latest Posts)
Login

Nickname

Password

Lost Password?

Don't have an account yet?
Register now!

Support Amigaworld.net
Your support is needed and is appreciated as Amigaworld.net is primarily dependent upon the support of its users.
Donate

Menu
Main sections
» Home
» Features
» News
» Forums
» Classifieds
» Links
» Downloads
Extras
» OS4 Zone
» IRC Network
» AmigaWorld Radio
» Newsfeed
» Top Members
» Amiga Dealers
Information
» About Us
» FAQs
» Advertise
» Polls
» Terms of Service
» Search

IRC Channel
Server: irc.amigaworld.net
Ports: 1024,5555, 6665-6669
SSL port: 6697
Channel: #Amigaworld
Channel Policy and Guidelines

Who's Online
56 crawler(s) on-line.
 21 guest(s) on-line.
 0 member(s) on-line.



You are an anonymous user.
Register Now!
 nikosidis:  6 mins ago
 -Sam-:  9 mins ago
 Loveback123:  11 mins ago
 OneTimer1:  22 mins ago
 Desler:  23 mins ago
 MEGA_RJ_MICAL:  23 mins ago
 amipal:  24 mins ago
 AmigaPapst:  39 mins ago
 Serpi:  56 mins ago
 DiscreetFX:  1 hr ago

Software News   Software News : SQLMan database manager updated
   posted by Lazi on 7-May-2016 6:39:47 (1462 reads)
SQLite Manager updated to V0.4

Download OS4, MOS, OS3.1, Aros version from Aminet.

It is still alpha, so feature requests, bug reports are welcome!

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.




V0.4 add DBF file import module, improve greatly XLSX import and contains several minor changes and bugfixes.

Changes:

  • 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 " -> ""


    

Related Links
· More about Software News
· News by Lazi


Most read story about Software News
UBoot 2010.06.04 for Sam460ex available

Last news about Software News
IBrowse 2.5 Released
Printer Friendly Page  Send this Story to a Friend

PosterThread
djrikki 
Re: SQLMan database manager updated
Posted on 7-May-2016 18:41:43
#1 ]
Elite Member
Joined: 22-Jun-2010
Posts: 2077
From: Grimsby, UK

Looks useful =)


_________________

 Status: Offline
Profile     Report this post  
vulture 
Re: SQLMan database manager updated
Posted on 7-May-2016 19:45:39
#2 ]
Regular Member
Joined: 21-Sep-2006
Posts: 220
From: Greece

imo, having some form of sql still updated for our platform is very important, so, thx a lot for this!

 Status: Offline
Profile     Report this post  
Lazi 
Re: SQLMan database manager updated
Posted on 7-May-2016 20:27:20
#3 ]
Cult Member
Joined: 5-Apr-2005
Posts: 640
From: Pomaz, Hungary

The link is missing from the news item:

SQLMan V0.4

 Status: Offline
Profile     Report this post  
_Steve_ 
Re: SQLMan database manager updated
Posted on 8-May-2016 2:13:04
#4 ]
Team Member
Joined: 17-Oct-2002
Posts: 6746
From: UK

Added link into main article now.


_________________
Test sig

 Status: Offline
Profile     Report this post  
Raffaele 
Re: SQLMan database manager updated
Posted on 8-May-2016 7:05:51
#5 ]
Super Member
Joined: 7-Dec-2005
Posts: 1881
From: Naples, Italy

Thanks for the hard work!

Have an updated SQL system available is a little but important advancement for Amiga platforms.


_________________
"When the Amiga came out, everyone [at Apple] was scared as hell." (J.L. Gassée, former CEO of Apple France and chief of devs of Mac II-fx, interviewed by Amazing Computing, Nov 1996).

 Status: Offline
Profile     Report this post  
Nibunnoichi 
Re: SQLMan database manager updated
Posted on 9-May-2016 7:16:28
#6 ]
Cult Member
Joined: 18-Nov-2004
Posts: 951
From: Roma + Lecco, Italia

Need to try this, thank you


_________________
Proud Amigan since 1987
Owner of various Commodore and a SAM440ep\OS4.1FE
See them on http://retro.furinkan.org/

 Status: Offline
Profile     Report this post  
Amigo1 
Re: SQLMan database manager updated
Posted on 9-May-2016 21:51:38
#7 ]
Super Member
Joined: 24-Jun-2004
Posts: 1536
From: the Clouds

Thanks a lot for this!

 Status: Offline
Profile     Report this post  
Robert 
Re: SQLMan database manager updated
Posted on 12-May-2016 14:57:05
#8 ]
Cult Member
Joined: 10-Mar-2003
Posts: 873
From: Glasgow

Nice!

Another bit of software to add to the "must investigate when I have time" list.


_________________
Robert
--
A1XE G4, OS4.1. Peg1 G3, MOS 1.4.
Abel Soul - Check out our tunes on Spotify

 Status: Offline
Profile     Report this post  
[ home ][ about us ][ privacy ] [ forums ][ classifieds ] [ links ][ news archive ] [ link to us ][ user account ]
Copyright (C) 2000 - 2019 Amigaworld.net.
Amigaworld.net was originally founded by David Doyle