[libreoffice-users] Re: Base stand alone

Le 24/03/11 12:44, Renato Pontefice a écrit :

Hi Renato

> I'm very very new to Libreoffice (about 5 minutes :-) )
>
> I have to create a DB. Of course I will use Base, but:
> - I'm wondering if it could be published as a stand alone. I mean:
> I need to create the DB, but my client won't have Libre office (and it works 
> with MS Windows). So I'm intrested on a way to publish DB with run time. Is 
> there)

If you mean standalone as in executable, then no, LibreOffice will not
do that for you.

If you mean a single file that you can give to someone else that they
can then use as their database, then yes, it is possible, but it will
require that person to install LibreOffice or OpenOffice.org on their
computer, and preferably exactly the same version of LibreOffice that
you used to create the database file in the first place.

When you create a LibreOffice database file, everything that relates to
the database is stored in a file with an ".odb" extension. This includes
the actual database engine, or a reference to the server if connecting
to a server based db engine, the tables and their definitions, the
queries, the forms and the reports, and any macros associated with the
forms. As you can see from this description, the ODB file is in fact a
container (zipped) for all of the other elements
that constitute the database. The db engine supplied with LibreOffice is
hsqldb, a java based db, which on its own is actually very capable. It
is just unfortunate that its integration into LibreOffice has not led to
spectacular performance when the amount of data starts to build up, or
say, when the Java version installed on the operating system changes
because of a security upgrade...this is not really the fault of hsqldb
though...and data loss can result if the LibreOffice application crashes
when working on your db leading to its corruption.

You should also bear in mind, that the ODB database solution is not
really as "portable" as it has been made out to be in the past. For
example, there have been problems creating "portable" dbs containing
images, or other media and then transferring them to other computers.

If you can afford to setup hsqldb directly (i.e. as a server instance,
and let that access your tables), then you would be better off
performance wise, or alternatively, set up a database server such as
mysql, postgresql, firebird, etc and use that to store your data, only
using the ODB file as front end for presenting forms, queries, reports, etc.


Alex


-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***