Re: [libreoffice-users] Re: Problems importing an OO database into LO

Hi :)

Almost no-one is developing Base or at least developments are not
reaching the releases.  So LO Base is almost no different from OOo's
Base except that it might have some regressions from the developments
of other components of LO.  



I get the impression that there is no official guide for OOo's Base and
so i am hoping that the documentation being written for LO/OOo Base
will help the devs work out what needs to be worked on or at least how
Base should be working.  



The BoD are against the idea of pulling in expertise from the various
back-ends that could work well with Base.  Someone did approach
Postgresql and they seemed positive but they need to break through the
reluctance of the BoD.  



I figured that we might get some feedback if people here started using
MariaDb.  Obviously people from MySql are unlikely to help as MySql is
owned by Oracle.  However the database experts here would rather
promote MySql which is only ever going to be a one-way street.  



I had hoped that other people would approach other projects such as (crucially) HSqlDb.  



Collaborating about Base is difficult because the experts and required
skills are scattered across several different mailing list and none are
willing to join another high-traffic list that hardly ever deals with
Base.  The BoD say they have more important issues to deal with and
can't spare the resources of setting up a mailing list dedicated to
Base.  - After all the other apps/modules of LO don't have their own
mailing lists and don't need them so why treat Base any different?



The BoD's big plan for getting Base up to scratch is to sit&wait to
see if someone gets annoyed enough with it to start working at it but
the problems are more extensive than 1 or 2 people could handle so
every-time someone starts they get demoralised and leave.  Ian is just
one more example of this.    

Dan is a star for making such a good start on the documentation.  
Regards from
Tom :)

--- On Tue, 17/4/12, Pertti Rönnberg <ptjr@elisanet.fi> wrote:

From: Pertti Rönnberg <ptjr@elisanet.fi>
Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 15:03

On 17.4.2012 12:34, ptoye wrote:
> Andreas Säger wrote
> > Why can't you run SQL update queries? This is trivial to do in SQL. The
> > SQL is trivial to execute by macro.
> > If you desparately want a graphical query designer for
> > update/insert/delete queries, then you should write one and store your
> > queries somewhere in the .odb container.
> Of course I can. If I can find out how to do it.
>
> But this isn't the point, is it? The real point is that database front-ends
> and macro languages are meant to make life easy, not difficult. You seem to
> dislike "sugar" - worried about your diameter? The computer was made for
> man, not man for the computer. Why not program in assembler - gives you much
> more control and isn't really that hard (I speak from years of assembler
> experience and with my tongue firmly in my cheek)?
>
> -----
> Peter
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html
> Sent from the Users mailing list archive at Nabble.com.

Well said Peter!

I totally and completely agree with you and Ian Whitfield.


And thanks to Ian for the tips about Kexi – I am almost ready for anything but LibO-Base.

Since the beginning of this year I have been trying to create a similar member register about a boy 
scout organization’s senior leaders also collecting memorable info from gone days – before these 
leaders are gone. The most I got from the efforts is waste of time and frustration.

A week ago Dan Lewis kindly sent to me drafts on documentation about creating a Base-db. It is very 
well written, clear, logic, easy to follow – but it is a draft, written in 2010 for OpenO. As far 
as I could see, there are nothing similar for LibO-Base yet.

Regarding LibO-Base’s situation today, very much should be helped if that Dan’s documentation 
should be completed and finished and included in the LibO’s (Base) introduction.

(When following Dan’s documentation I also noticed that in LibO-Base you can create a form /_based 
on a query_/ only using the Form Wizard – Design View allows you to create a form /_only based on a 
table = one table!_/)

To the LibO-folks and developers I repeat:

Stop developing LibO-Base;go back to the latest stable version and start to complete it and repair 
all discrepancies in the program and between the program and it’s documentation!

There is so much good done in LibO-Base so why not get the rest OK? So it at least should meet the 
promises in advertising.! Without problems!

And:
What (in @!?*@!??) can be the clever idea with having in LibO-base a embedded HSQL v.1.8 that is 
not supported any more when the latest version is 2.2.x? What about e.g. SQLite?

As Peter said:thus making the life easier  -- and if not easier but not more difficult!

Regards

Pertti Rönnberg


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

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