Base and some of its limitations (including enbedded HSQLDB) are well described here: https://wiki.openoffice.org/wiki/FAQ_(Base)
The last two times I needed a multi user database accessible over the web I went with a LAMP approach. The *upfront* set up and learning curve was higher but *less* time is required over the life of the project (development & maintenance) as these tools have exceptional stability and performance, have very few bugs, excellent documentation and require no client side maintenance. AND, it's far more rewarding developing the application versus fighting the bugs and limitations of your tools ... as often happens when using Access, Base and their like (been there, done doing that). On Wed, Aug 3, 2016 at 6:15 AM, Alexander Thurgood <alex.thurg...@gmail.com> wrote: > Le 02/08/2016 à 00:23, Ian Whitfield a écrit : > > Hi Ian, > > > > > > *Re: The LO Base discussion* - just my "Penny's Worth"!!! > > > > > The only way I got any (sort of results) was by using MySQL as the > > backend but it took a couple of months to get it working and after a few > > months even that crashed on me. I recently had to re-build my computer > > after a hardware failure and my OpSys upgraded to 64bit and since then I > > can not even get the MySQL linking in LO Base to even start!! > > > > It it is fairly rare for people to suffer from catastrophic failures and > data loss using mysql - most of the time, it is usually possible to > salvage most, if not all of one's data providing one takes an interest > in the manuals on how to administer such a database server (and there > are a plethora of them, not least Oracle's own documentation). > > > > So if you are happy to keep lots and lots of backups, and spend lots and > > lots of time re-building everything at almost monthly intervals - and by > > re-building I mean the Database Tables, redesign all your Forms and > > set-up all your Queries and Reports from scratch - then go with it, > > otherwise give it a miss. > > > > It is also not strictly necessary to keep backups of the mysql database, > although it is indeed a recommended practice. Again, the documentation > is replete on how to do this safely. > > From the interaction I've had with you on and off the list, I would say > that you have been unfortunate with regard to some of your expectations, > in that you did not wish to, or failed to, understand what it meant to > have a database server, and didn't wish to spend time understanding how > it worked in case things did go pear-shaped. I can understand this from > a user perspective, and in that case, choosing mysql as your backend > database engine was probably not a good idea, but as you found out for > yourself, neither was the embedded hsqldb. > > My own experience with mysql databases has been rock solid in terms of > data integrity now for more than 10 years, including various different > types, from stock management, IP rights management, accounting, etc, > although I will admit that interaction with StarOffice, OpenOffice.org > and LibreOffice has caused some issues, but this mostly lies with > limitations or bugs within those programs and not mysql itself (barring > a few connector driver problems). > > Fact of the matter is that databases when used with LO, embedded or not, > probably require more work than most "Access-users" are willing to put > in. There is no "simple", "out-of-the-box" solution for such users when > attempting to switch to LO, everything will be a compromise of sorts, be > it form design, reporting, stability, multi-user access, etc. > > LOBase was always designed with the eye of a database administrator in > mind, and the attempted switch to a user-centric orientation just didn't > quite happen (for various reasons within Sun, and then Oracle). However, > what we have got is not bad as things go, providing that one can accept > its limitations (or alter one's work flow to work around them). > > > Alex > > > > > -- > 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 > -- 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
