Re: [Dorset] Free Database software

2013-11-02 Thread John Palmer
I agree with Ralph. diff(1) is awfully useful too, perhaps more so with text than data, but traditional Unix tools don't really make that distinction. I did recently solve a problem that had baffled a user of Access, by diff'ing two large files that he had assumed should be identical, and

Re: [Dorset] Free Database software

2013-11-01 Thread Victor Churchill
MySQL is probably the dominant free database running on Linux. The core RDBMS runs a command line SQL client, but GUIs can be added: you can install phpMyAdmin which gives control via a GUI web interface, including all the DML you require, and the MySL owners Oracle also make available 'MySQL

Re: [Dorset] Free Database software

2013-11-01 Thread Ken Hutton
Firebird is probably in your Linux distro's package manager. That would probably be the best place to install it from. l haven't used it myself though so I don't know how well it would meet your needs. It might also be worth considering sqlite. It doesn't have the graphical interface you are

Re: [Dorset] Free Database software

2013-11-01 Thread Andrew Montgomery-Hurrell
Re: sqlite, there are a bunch of separate GUI tools available, from Firefox plugins to things like sqliteman, though to be fair you'll still need SQL knowledge for doing anything useful. On 1 November 2013 09:41, Ken Hutton kehut...@googlemail.com wrote: Firebird is probably in your Linux

Re: [Dorset] Free Database software

2013-11-01 Thread Ralph Corderoy
Hi David, Ken wrote: It might also be worth considering sqlite. It doesn't have the graphical interface you are looking for but sql is quite easy to learn. That would be my suggestion too since you talk of select and update queries. The diagrams mentioned are railroad diagrams showing the

Re: [Dorset] Free Database software

2013-11-01 Thread Simon P Smith
On 31/10/2013 22:00, David Smith wrote: I am looking for free software to run under Linux to implement a small database. A free version of MS Access would be ideal! Access is part of MS Office professional and allows you to create and run SQL queries by point and click rather than needing to

Re: [Dorset] Free Database software

2013-11-01 Thread David Smith
On Friday, November 01, 2013 11:01 AM Simon P Smith wrote At the risk of being burnt at the stake :-) Many good suggestions in this thread but let me throw up one more... You said free software. Whilst I use postgres and MySQL extensively some clients are M$ shops and so the database

Re: [Dorset] Free Database software

2013-11-01 Thread Andrew Montgomery-Hurrell
Oh, regarding firebird, I find on my ubuntu box that: sudo aptitude install flamerobin Installs firebird and a GUI client called flamerobin, if you've got a preference for firebird over sqlite. On 1 November 2013 12:48, David Smith david.sm...@aic.co.uk wrote: On Friday, November 01, 2013

Re: [Dorset] Free Database software

2013-11-01 Thread David Smith
On Friday, November 01, 2013 12:54 PM Andrew Montgomery-Hurrell wrote: Oh, regarding firebird, I find on my ubuntu box that: sudo aptitude install flamerobin Installs firebird and a GUI client called flamerobin, if you've got a preference for firebird over sqlite. Thanks but will try

Re: [Dorset] Free Database software

2013-11-01 Thread Paul Tansom
** 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

Re: [Dorset] Free Database software

2013-11-01 Thread Ralph Corderoy
Hi Paul, 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. Before databases were common on Unix, this would be the province of its

[Dorset] Free Database software

2013-10-31 Thread David Smith
This may be outside what DLUG normally discusses. If so please say and I will look elsewhere. I am looking for free software to run under Linux to implement a small database. A free version of MS Access would be ideal! Access is part of MS Office professional and allows you to create and run