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