Re: [libreoffice-users] Adding fields to existing Base table

On 07/11/2014 04:21 PM, dave boland wrote:
> Thank you Noel.  I will check this out.  My head is spinning right now
> with all of the choices.  I need to get something together for next
> Fri., so I'm going with LO Base for now.  Seems like a decent choice
> because I will be the only user for most of the rest of the year.  Later
> this year there may be two other users.  So the convenience of LO Base
> makes sense, and the data size for the rest of the year is not likely to
> excede 200 MB.  The biggest limitation with LO Base is the report
> spftware - doesn't seem to support embedding charts in the report.
> Hopefully this problem gets fixed in 4.3.  Alternatively, I'll use a
> stand-alone report software product.  Hey, did I mention that this was
> SUPPOSED to be a quick simple project?  Aren't they all??
>
> My hope is that I can use LO Base as the front end for a more robust
> RDMS later this year.  I have been looking at MariaDB because it seems
> to have a lot of buz, but may not be the best chioce.  One of the things
> that really needs to happen is that I have to get my arms around this
> project in terms of potential size, number of users, on the web or not,
> ect.  My guess is that I won't have that done until very late this year.
>
> Dave,
>
> On Fri, Jul 11, 2014, at 09:07 AM, Marion & Noel Lodge wrote:

Hi Dave

My penny's worth - I battled with plain Base for about 3 years. 
Horrendous crashes and freezes and the amount of data I "lost" and had 
to re-enter was unbelievable!!! (I'm a single user, single machine 
running with Linux as my OpSys). Every time Base goes down it takes the 
entire Database with it!!!!! So the only way round it is to make copies 
every time you add data so that when it crashes you can rename the copy 
and get going again. You WILL lose data I promise you!!

I did everything I could but no luck. It then became obvious to me that 
the problem was the embedded DB so I took the plunge and moved to MySQL 
last year. I've had NO crashes or lost data since then. It's as solid as 
a rock!!

My recommendation would be to START right now with MySQL (or other 
backend). Base as a front end is great as long as the backend is solid!!

Just my opinion for what it's worth but I speak from hard experience!!!

Best wishes

IanW
Pretoria RSA.

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