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: [email protected] 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
