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



On 02/07/2014 08:40 AM, Andrew Douglas Pitonyak wrote:
On 02/07/2014 02:38 AM, Ian Whitfield wrote:

Hi All

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.

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.

Now I have a couple of questions...

1) Where does MySQL store the Database? (I think it's in the root somewhere)

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?

Side question

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)
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.

Thanks for any help

IanW
Pretoria RSA.



--
Jay Lozier
jslozier@gmail.com


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

Context


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.