On 11/18/2014 07:32 AM, Alan B wrote:
On Tue, Nov 18, 2014 at 6:35 AM, Alan Pedder <alanped...@hotmail.co.uk>
wrote:
I
have been using Base to provide a database for my paintings via a
simple form. I recorded 200 records and then added the facility to
include a photograph .jpg file and this is when the gremlins started to
appear.
It constantly issues error messages when adding data
and causes me to endlessly loose work as it has failed to write to the
table from a form for no obvious reason I can see, sometimes I can add a
new data or several set/records on the form OK and then it will fail
with the error message as follows where the Table1 is my Table
Hello Alan. I haven't used Base to store binaries however I have monitored
this list for a while and used Base for a few small projects.
I expect the two primary recommendations you will get are...
1. Don't store data in Base, use a separate database back end because the
embedded HSQL is not very stable. To that end I've recently found the
native MySQL connector works well for me (never had reliable connections
with the Java or ODBC connectors).
2. Don't store binaries in Base, store a path/pointer to the binary. Keeps
the table size down, minimizes loss if the db becomes corrupted.
To re-enforce what was just said, some of which is obviously just an
opinion....
LO contains a database component which stores all of the data in a
single file which is then pulled into memory when in use. This included
database is HSQLDB
http://en.wikipedia.org/wiki/HSQLDB
If you create a "standard" Base document using what came with LO, then
you are using HSQLDB as the "back end" to manage your data. You can use
other database systems on the back-end. i am not an expert and cannot
enumerate them, but, I expect that mariadb and postgre are both examples
of other back-end database implementations that people use. The problem
with that is that (I think) that you must have these programs running as
a server to access them. The advantage is that they are more robust and
less prone to errors; especially when you store a large amount of data.
I ran into significant problems when I stored a large number of images
in a Base document backed by HSQLDB. I expect that the same problem
would not have occurred if I had used a different DB to actually store
the images (such as MySQL, MariaDB, or PostGRE). One method that may
work is to not store the large binaries in the database, but, instead,
store a path to the individual image in the DB and then store image
itself on disk. I have used this method in production systems when
storing very large binaries (by large I mean that each binary may be a
couple of GB).
I stopped using Base years ago because of those Gremlins. I believe that
many of the gremlins that plagued me have been fixed, but I would be
hesitant to use it to store much binary data using HSQLDB as the back-end.
Just my opinion and perhaps others on the list can offer a more recent
experience.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
To unsubscribe e-mail to: users+unsubscr...@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