Re: [libreoffice-users] Re: Calc will not save file after sheet deleted.

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