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 Workshop' which is a standalone desktop GUI application which appears quite comprehensive.
I am not sure that either of the above let you build 'queries' by point and click though, it's not something I have tried. There used to be a util called 'toad' (tool for Oracle developers) and one called 'tora' which both gave spreadsheet-like create/read/update/delete facilities. I believe Toad is no longer free; I don't know if Tora is still maintained. On 31 October 2013 22:00, David Smith <[email protected]> wrote: > 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 SQL queries by point > and click rather than needing to know SQL syntax. My database would live on > one pc - no separation of server and client. > > Initially I thought Open Office/Libre Office Base would do the trick, but > it only supports select queries, not Update queries, make table queries > etc. Access allows data to be imported from a .csv file into a data table, > and exported to .csv. In Base you have to cut and paste between spreadsheet > and table table or query - unless of course you write VBA modules which is > the hard way of doing things. > > I have tried downloading a version of Firebird but don't know what to do > next. I cannot even find an install program. > > Any ideas? > > thanks > > David > > -- > 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:[email protected].**uk<[email protected]> > How to Report Bugs Effectively: http://goo.gl/4Xue > -- best regards, Victor Churchill, Bournemouth -- 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:[email protected] How to Report Bugs Effectively: http://goo.gl/4Xue
