Re: [libreoffice-users] Re: Base Report Builder

Hi Tom, Noel,
Dan, Alex and the others were all quite helpful. I'm going to explore some
of my options. Noel suggested H2 as a back end and I was impressed with its
specs. I downloaded the program and was pleased with the very clear
documentation. In Noel's last post he was good enough to point me to a step
by step tutorial for replacing embedded HSQLDB with H2. Unfortunately, that
server appears to be down the last few days. Nevertheless I was able to get
a connection to the H2 backend with JDBC using the H2 documentation. I have
run into some syntax and database naming differences which I shall have to
clear up. I expect I shall have plenty of questions about Base's behavior
as a client.
Hank


On Tue, Jan 29, 2013 at 7:06 AM, Tom Davies <tomdavies04@yahoo.co.uk> wrote:

> Hi :)
> Sorry about scaring you!  Hopefully you have picked up some good ways of
> doing this from some of the other threads.
>
> If the database is not small then there are tons of good back-ends any one
> of which would be great to use.  I think Postgresql might be the best at
> the moment but you might also enjoy using MySql/MariaDb instead and there
> are other good ones.
>
> Hopefully it should be reasonably easy to migrate the tables and doing so
> should not affect tables and forms especially if they are built up from
> Queries rather than directly from the tables.  If they were do directly
> refer to the tables then they probably do need a bit of editing but
> hopefully nothing too drastic.
>
> Apols for not replying sooner!  I've just been a bit snowed under and
> anyway Dan, Alex and others know far more about specifically Base itself so
> hopefully someone has been able to give you much better help!
> Regards from
> tom :)
>
>
>   ------------------------------
> *From:* Hank Alper <hankalper@gmail.com>
> *To:* Alexander Thurgood <alex.thurgood@gmail.com>
> *Cc:* users@global.libreoffice.org
> *Sent:* Sunday, 27 January 2013, 6:24
>
> *Subject:* Re: [libreoffice-users] Re: Base Report Builder
>
> Hi Alex, Mark, Tom,
> You guys scare me !  I'm beginning to think I'd better start looking for a
> new back end. I've put a lot of work into this project. Tom, this is not a
> small database like an address book. After normalizing, my design has 16
> tables.( with a few more coming as I've discovered  as I feed more data
> into it.) If I connect to an external server is there any way I can save my
> forms and reports? Or shall I have to start anew ? My tables, queries and
> views were all produced using  SQL and I have text copies of all of them to
> feed any server I might select. Transfer of data becomes a problem, of
> course.
> Hank
>
> On Mon, Jan 21, 2013 at 10:36 AM, Alexander Thurgood <
> alex.thurgood@gmail.com> wrote:
>
> > Le 21/01/13 16:01, Mark Stanton a écrit :
> >
> > > Isn't hsqldb *still* a (relatively) good choice, as long as it is
> > installed and
> > > used *external* to Base?  That does of course mean it's still not the
> > "default"
> > > setting.
> >
> > As I mentioned in my answer to Tom, if you use an external version of
> > hsqldb, it can only be the same version number as the internal version
> > provided with LO, else the old ODB files can no longer be opened. In
> > other words, you can not install an external hsqldb jar and expect your
> > old ODB(hsqldb) files to keep working, as this will throw an error.
> >
> > So yes, it still remains a possibility, but one that you may want to
> > avoid if you still have old ODB files that use the internal hsqldb with
> > an older revision number than the externa jar you plug into LO.
> >
> > Alex
> >
> >
> >
> > --
> > For unsubscribe instructions e-mail to: users+
> help@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
>
> --
> For unsubscribe instructions e-mail to: users+help@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

-- 
For unsubscribe instructions e-mail to: users+help@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