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

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