** David Smith <david.sm...@aic.co.uk> [2013-11-01 16:57]: > On Friday, November 01, 2013 4:27 PM Paul Tansom wrote <snip> > >I think I've been put off desktop databases by MS Access where > >I've had several > >battles to get it to do what I want it to. Generally I've wanted > >to interact > >with the SQL it generates, only to find that either it isn't > >really SQL or it > >is actually doing more behind the scenes than the SQL it presents actually > >tells it to - very nasty! It is going back a bit so it may have improved. > > I found MS Access fine for single user, but it could not cope > properly with multi user - locking inadequate I think.
I've not got into that, multi-user wise I've always gone for a proper backend and a web interface, even back when I was force to work with a combination of MS SQL, Javascript and a CGI called HotSQL do develop a call logging system that should look workable in IE, Netscape Navigator and WebExplorer on either Windows 95 or OS/2 in 640x480 or above with 16 colours or more! > >Oddly, when it comes to desktop databases I've found that the MS > >Works one has > >been the one I've got on best with (OK, now everybody gets ready > >to hurl abuse > >at me!). I think the main reason for this is that the database is > >little more > >than a single table for storing data that I can merge into a > >document. Since > >this is a long time ago and that is exactly what I wanted to do it > >was easy. > >There doesn't seem to be much around that works well for > >exceptionally basic > >stuff like that these days. I've been battling LibreOffice Base a bit on > >Windows to do something simple like that just recently and not got > >on well. It > >is no wonder so many simplistic databases are done in spreadsheets! > > I need to do Joins and grouping of records etc. Spreadsheets not > good for that. Yes, for my own stuff I work like that, these databases have been simple table of information that need to be stored, updated and printed. It would almost work as a table in a word processed document bar the fact that you can't sort properly there. In a database the records stay together, I've sorted columns in spreadsheets and word processors where only the column itself has been sorted and all other columns have stayed as they were - great way to screw up the data! > I cannot understand the Firebird documentation. SQlite seems fine. > It seems that sequences of SQL statements can be executed from Linux > shell scripts. This will avoid having to write C or C++ programs. Sounds like fun :) ** end quote [David Smith] -- Paul Tansom | Aptanet Ltd. | http://www.aptanet.com/ | 023 9238 0001 ============================================================================= Registered in England | Company No: 4905028 | Registered Office: Ralls House, Parklands Business Park, Forrest Road, Denmead, Waterlooville, Hants, PO7 6XP -- Next meeting: Bournemouth, Tuesday, 2013-11-05 20:00 Meets, Mailing list, IRC, LinkedIn, ... http://dorset.lug.org.uk/ New thread on mailing list: mailto:dorset@mailman.lug.org.uk How to Report Bugs Effectively: http://goo.gl/4Xue