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

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,
>
> You might also like to have a look at the H2 Database Engine, see -
> http://www.h2database.com/html/main.html
>
> I have found that it is a good stable replacement for HSQLDB and have
> used
> it in 6 different databases with good success.  There is an active users
> group, and some of them report success with very large databases.
>
> Noel
> --
> Noel Lodge
> lodgemn@gmail.com
>
>
> On 11 July 2014 05:27, dave boland <dboland9@fastmail.fm> wrote:
>
> > I'm setting up a database that is small (three tables, may grow to 3GB
> > over next year).  I need a strategy to deal with the unknown, which is
> > how to add fields to an existing table.  I read in the docs that doing
> > this can be painful and it is required to put something in each field
> > for each record.  Do I have this correct?  If so, how do I handle the
> > inevitable "...would you add..." that is sure to come within the next
> > few months?  I would add them now, but I really can't anticipate how
> > many fields will be added or their requirements.
> >
> > In general, do other databases have similar restrictions?  At some time,
> > when I have time, I will consider MySQL, MariaDB, and others.
> >
> > Thanks,
> > Dave
> > --
> >   dave boland
> >   dboland9@fastmail.fm
> >
> > --
> > http://www.fastmail.fm - Or how I learned to stop worrying and
> >                           love email again
> >
> >
> > --
> > 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
>
> -- 
> 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
-- 
  dave boland
  dboland9@fastmail.fm

-- 
http://www.fastmail.fm - Email service worth paying for. Try it for free


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