Click Here
home features news forums classifieds faqs links search
6071 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
8 crawler(s) on-line.
 176 guest(s) on-line.
 0 member(s) on-line.



You are an anonymous user.
Register Now!
 michalsc:  10 mins ago
 pixie:  13 mins ago
 kriz:  30 mins ago
 amigakit:  33 mins ago
 kolla:  40 mins ago
 Karlos:  54 mins ago
 matthey:  58 mins ago
 Rob:  1 hr ago
 minator:  1 hr 7 mins ago
 AMIGASYSTEM:  1 hr 13 mins ago

Software News   Software News : SQLMan database manager updated
   posted by Lazi on 7-May-2016 6:39:47 (2015 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 " -> ""


    

STORYID: 7727
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
Hollywood APK Compiler 4.0 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: 225
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: 651
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: 6814
From: UK

Added link into main article now.


_________________
Test sig (new)

 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: 1906
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: 971
From: Roma + Milano, 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: 1582
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: 879
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