On 02/07/2014 08:40 AM, Andrew Douglas Pitonyak wrote:
I think the other reason for using HSQL is it is easier to use as an
embedded database while MySQL/MariaDB, PostgreSQL, etc. require the
separate install of the database. The others are designed as stand-alone
databases that one can connect to using a variety of tools.
On 02/07/2014 02:38 AM, Ian Whitfield wrote:
I've been using the Base/MySQL combination since mid-last year now
and it is fantastic!! It is much faster, never crashes or freezes and
just works the way it is supposed to. I can definitely recommend it
to anyone!! (In my opinion this should be the standard and HSQL
should be dropped)
The advantage of HSQL is that it creates a single file and you do not
need to run a database daemon in the background (I am assuming that
the MySQL connector uses that rather than knowing how to read the
MySQL files directly). In other words, it does serve a need.
The disadvantage of HSQL, (speculation, so assume half of what I am
about to say is wrong) is that it sounds less stable, if you crash
Base, it is more likely to lose data, and everything stays in memory.
Storing the link to the photo should make the database query run faster
because the text string is orders of magnitude smaller than the photo.
One problem is one must be very carefully about naming the photos.
Now I have a couple of questions...
1) Where does MySQL store the Database? (I think it's in the root
Are you using Windows or Linux? Try looking under something like:
C:\Program Files\MySQL\MySQL Server #.#\my.ini
Look in that file for the basedir and datadir variables.
And now I see I need to run.
2) Is it easy to move it into the /home directory?
3) Where do I find the LO front-end form?
4) If I copy these two files to another machine will I be able to get
the Database running on this second machine?
I have a couple of graphics/photos in each record - Is it possible to
'Link' these instead of embedding them so that if you up-date a photo
it will automatically update in the Database? If this is possible
will it effect Base at all? (faster, slower etc)
Thanks for any help
To unsubscribe e-mail to: email@example.com
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
Impressum (Legal Info)
: 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