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


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

--
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.