Hi :) Actually HsqlDb from their own site is usually a huge improvement over the internal back-end version and is apparently really good too. However i think HsqlDb aims to be for small, light-weight but extremely fast databases so it probably wouldn't suit this particular use-case. I get the impression that H2 is also a small, fast one but could easily be wrong.
We often mention the heavy-duty back-ends such as Postgresql and MySql/MariaDb but rarely hear about the faster, lighter-weight ones and how they compare against each other. In general i think it is good to be reminded that there are other choices out there and what some of them are. Many thanks and regards from Tom :) On 11 July 2014 14:07, Marion & Noel Lodge <[email protected]> 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 > [email protected] > > > On 11 July 2014 05:27, dave boland <[email protected]> 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 > > [email protected] > > > > -- > > http://www.fastmail.fm - Or how I learned to stop worrying and > > love email again > > > > > > -- > > To unsubscribe e-mail to: [email protected] > > 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: [email protected] > 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: [email protected] 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
