Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

    Simon Cropper
    Principal Consultant
    Botanicus Australia Pty Ltd
    PO Box 160, Sunshine, VIC
    W: www.botanicusaustralia.com.au


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.

-- 
Jay Lozier
jslozier@gmail.com

-- 
For unsubscribe instructions e-mail to: users+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.