Re: [libreoffice-users] Tell me it's not true

On 03/01/2012 05:02 PM, Mark Stanton wrote:
> Hi Andrew,
>
> Was that instability with an "internal" HSQL database?
>
> Mark Stanton
> One small step for mankind...
I will be more specific:

I used the internal HSQL database for each proejct. Each database was 
sufficiently complex that I required a complex series of macros to 
fulfill my needs. For example:

Simple inventory that also stores images (could be a receipt, picture, 
whatever). So, I needed functionality that allowed for adding, 
extracting, deleting, and moving through the images. The entire system 
appeared to not be sufficiently robust to handle all of the image files 
as the size of the database grew. It is also possible that API changes 
were the issue. The only evidence that I had was that adding one more 
image caused corruption and the entire DB was no longer usable. I 
suspect that if I had used a better backend that could handle the size 
then I would not have experienced this particular problem. To put things 
into perspective, I was running a 64-bit system with 12 GB of RAM and 
the last working DB was 45MB in size.

I created a contact DB that required numerous macros to add entries that 
tracked things such as "yeah, I managed to get in touch with them on 
this date to this effect". I did not use the DB often, but it was very 
common for a new release to break the system and I had to change my 
macros so that things continued to function. Last time this happened 
(while tracking a different kind of inventory DB dealing with 
collectibles) I decided that enough was enough and I did not want to fix 
my macros anymore.

When I had a working system, I never had an issue loading Base and going 
directly to the tables. I was able, therefore, to manually copy all 
tables to a Calc document and then export to a CSV file (ignoring things 
such as binary data).

It should be noted that I spent a bunch of time just creating the macros 
to make the system work. For a complex system, Base still took a lot of 
time for me to accomplish complex things; for example, help and fill 
capability when I want the user to select from a human readable value 
but store the underlying ID.

--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


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