Base Report Builder

users
#21

Hi Hank,

The URL for the HSQLDB to H2 tutorial is -

http://www.oooforum.org/forum/viewtopic.phtml?p=365296#365296

As you will see, I had asked a series of questions and dacm kindly came up
with a very comprehensive set of answers. The steps he listed worked well
for me.

One point to watch when migrating each table. For Table name enter -
      <Database name>.PUBLIC.<Table name>
e.g. ROSTERS.PUBLIC.Availability

I think you can choose an alternative to PUBLIC, but I just went with the
default.

Regards,

Noel

#22

Hi :slight_smile:
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 :slight_smile:

#23

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

#24

Hi :slight_smile:
I think Dan is describing how to migrate tables out of the embedded back-end and then the next (hopefully last) stepping stone gets the tables into the latest version of HsqlDb.  Yes a pain but only a temporary one for most people making such a move.

I'm not sure about H2 beign such a great alternative.  Better and clearer documentation is a big plus but even so it is still based on Java so presumably as Java continues to fall apart under the 'new' owners (Oracle) it's just going to keep on being a problem.  Is it at all likely that either one will re-code their back-ends to C# or C++ (same thing as each other or different?) or Python or Qt (?) or anything else that Is also cross-platform but less troublesome?

I have heard that corporates love to have their valuable data in java based backends but is there something safer that is still good for smaller amounts of data?  Errr, i guess i should ask that as a separate question, sorry. 
Regards from
Tom :slight_smile:

#25

I have heard that corporates love to have their valuable data in java
based backends

That's because corporations are intrinsicly dysfunctional organisations
that promote opportunist egomaniacs who have no competence in any other
field than careerism into those positions where they can cause the
maximum damage to the entity.

FOSS projects shouldn't try to mimic corporate pathologies.

but is there something safer that is still good for smaller amounts
of data?

There's no (FOSS) RDBMS that beats PostgreSQL. And LO has a native
driver for it.

Sincerely,

Wolfgang

#26

Hi :slight_smile:
Lol!  I liked that post.  Very funny.

I thought PostgreSQL was for large databases?  Also i thought Firebird was supposed to be quite good?  I think that really is a large one though so possibly not what i am looking for.  I'm hoping it is because i think one of my bosses is buying a front-end that uses it and i was hoping to use the same back-end for other databases.

Regards from
Tom :slight_smile:

#27

Lol!  I liked that post.  Very funny.

The reality is much less funny for all screen-labourslaves who have to
work in those pathologically dysfunctional organisations.

I thought PostgreSQL was for large databases?

It's for anything.

Also i thought Firebird was supposed to be quite good?

Among FOSS client-server RDMBS, Firebird probably comes in second after
PostgreSQL, that's right.

But if I have any choice, I choose PostgreSQL.

Sincerely,

Wolfgang