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 [email protected] List archive: http://listarchives.libreoffice.org/www/users/ *** All posts to this list are publicly archived for eternity ***
