Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

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:

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.