Simon On Thu, 2011-08-11 at 10:30 +1000, Simon Cropper wrote:
> On 11/08/11 09:47, planas wrote: > > Simon > > > > On Thu, 2011-08-11 at 09:38 +1000, Simon Cropper wrote: > > > >> On 11/08/11 02:53, Tom Davies wrote: > >> > Hmm, well maybe not the absolute worst. A sieve or broken > >> > floppy disc or an ancient format that no program can read > >> > might be worse but yes, databases with an audit-trail are > >> > much more secure and plain text such as Csv ensure that there > >> > will always be some program somewhere that can at least > >> > access the data. > >> > >> I agree but there are no good front ends to the myriad of relational > >> database backends that you can utilise on Linux. > >> > >> I could list tons of SQL engines but as the copious posts on this list > >> about Base attest, there are few decent alternatives for Rapid > >> Application Development, Data Mining or even simple application > >> development available; let alone something that can be integrated into LO. > >> > >> When working on Windows I use Microsoft Visual Foxpro. Fantastic package > >> but now discontinued (and I have moved my primary platform to Ubuntu > >> now!). There is absolutely nothing comparable to it on Linux. You either > >> have to write a complete application every time you want to do something > >> (e.g. Python+wxPython; Dabo) or need to poke at a SQL file from the > >> command line. > >> > >> If I could recreate my spreadsheet in a database format that allowed me > >> to quickly develop and easily maintain an application -- I would be > >> developing it now. > >> > >> -- > >> Cheers Simon > >> > > Both MySQL/MariaFB and Postgresql have GUI interfaces available for > > Linux , MySQL Worbench from the MySQL site and pgadmin for Postgresql in > > the Ubuntu repository. Both allow a users to most of the db work in a > > desktop environment not CLI. > > > > All these packages are administration utilities not RAD or Data Mining > environments. > > "MySQL Workbench is a visual database design tool that is developed by > MySQL. It is the successor application of the DBDesigner4 project." > http://wb.mysql.com/?page_id=28 > > "pgAdmin is designed to answer the needs of all users, from writing > simple SQL queries to developing complex databases. The graphical > interface supports all PostgreSQL features and makes administration > easy. The application also includes a syntax highlighting SQL editor, a > server-side code editor,...." http://www.pgadmin.org/ > > Data mining allows the 'researcher' to import, export, convert, merge > and manipulate data for a particular project, and maintain the original > data and any derivatives. > > RAD allows, at minimum, input forms, menues and reports. Ideally a > programming language should be available to manipulate the data and user > experience. > > Granted I should have been more careful with my choice of words. All > these packages do provide simple GUI interfaces that allow you to design > and query a database created with the respective tool. Some projects do > provide some import and export facilities for use in a once-off > situation. BUT they are not really designed as RAD tools or provide you > with the *easy* ability to collate disparate data sources, manipulate > this information and export it again. > > -- > Cheers Simon > > Simon Cropper > Principal Consultant > Botanicus Australia Pty Ltd > PO Box 160, Sunshine, VIC > W: www.botanicusaustralia.com.au > I should read more closely sometimes. I would think the problem with data mining is determine what bits might be yield nuggets out of the mass. -- Jay Lozier jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
