Amigaworld.net - The Amiga Computer Community Portal Website

home

features

news

forums

classifieds

faqs

links

search

6071 members

Amiga Q&A / Free for All / Emulation / Gaming / (Latest Posts)

Login

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.

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

20 crawler(s) on-line.

67 guest(s) on-line.

1 member(s) on-line.

pixie

You are an anonymous user.
Register Now!

pixie: 4 mins ago

OlafS25: 21 mins ago

zipper: 1 hr 57 mins ago

amigakit: 2 hrs 15 mins ago

RobertB: 2 hrs 16 mins ago

bhabbott: 2 hrs 45 mins ago

jPV: 3 hrs 25 mins ago

matthey: 3 hrs 25 mins ago

AmiKit: 3 hrs 26 mins ago

Musashi5150: 3 hrs 47 mins ago

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

Most read story about Software News
UBoot 2010.06.04 for Sam460ex available

Last news about Software News
Hollywood APK Compiler 4.0 released

Poster

Thread

djrikki

Re: SQLMan database manager updated
Posted on 7-May-2016 19:41:43

[ #1 ]

Elite Member

Joined: 22-Jun-2010
Posts: 2077
From: Grimsby, UK

Looks useful =)

_________________

Status: Offline

vulture

Re: SQLMan database manager updated
Posted on 7-May-2016 20: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

Lazi

Re: SQLMan database manager updated
Posted on 7-May-2016 21: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

_Steve_

Re: SQLMan database manager updated
Posted on 8-May-2016 3:13:04

[ #4 ]

Team Member

Joined: 18-Oct-2002
Posts: 6808
From: UK

Added link into main article now.

_________________
Test sig (new)

Status: Offline

Raffaele

Re: SQLMan database manager updated
Posted on 8-May-2016 8: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

Nibunnoichi

Re: SQLMan database manager updated
Posted on 9-May-2016 8:16:28

[ #6 ]