Re: [libreoffice-users] Re: Where is Base?

On Sun, 2015-03-01 at 22:23 +0100, Andreas Säger wrote:
> Am 01.03.2015 um 22:01 schrieb Jay Lozier:
> > >
> > What is the current backend for Base?
> >
> > I remember at one time is HSQL 1.8 but one could install a later
> > version.
> >
> > Jay
>
>
> When you create a new database document without Java support, then you
> get a directory of flat dBase files handled by LibreOffice's
> insufficient SDBC driver for dBase.
>
> With Java support it will be an embedded HSQL 1.8 database which is more
> a caricature of a database because it is slow, unsafe and insecure. The
> problem is _not_ HSQL. The problem is the way how the backend is wrapped
> into the zip archive which constitutes the "Base document".
> It is easy enough to convert an embedded HSQLDB to a normal (external)
> database and use it with a recent and more capable version of HSQL.
> Current version is 2.3. On the OpenOffice user forum you can find
> several tutorials, scripts and macros. But you can also use HSQL 1.8
> with an external database if that version fits your needs. Just do not
> use a self-contained database in a single file for anything but
> educational stuff, demos or small projects for a single user on a local
> machine with a sound backup strategy.
>
> Otherwise you can connect a Base document to any database you have a
> driver for (ADO, ODBC, JDBC).
I have not kept up with Base, I tend to use MariaDB/PostgreSQL directly;
not through the Base front end. I vaguely remember some chatter about
replacing HSQL with something else. 


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