Libreoffice Base

users
#1

1. Is Base being supported or is it dead in the water. I have read some
comments in the forums and wonder.
I am trying to assemble a small database but wonder should I continue if it
is not being supported.
I actually enjoy working with Base and only wish I was more computer
literate.

2. In my database forms I have two layouts, in one both the main form and
sub form use the third layout like a spreadsheet. In the second form the
main form uses the second layout and the sub form the third layout.
One of the cells is for notes which can be up to approx 500 letters.
In the second form I can see all the notes in this particular cell but in
the first form, spreadsheet, I can only see one line. I have multiline on
and by using the up and down arrow keys I can see all the text albeit one
line at a time.
What do I need to do to be able to see all text at once

#2

1. Is Base being supported or is it dead in the water.

Base is, and will continue to be supported.

The embedded database engine is in the process of changing from HSQLdb
to FireBird. This change has caused some users to be confused, and think
that the Base component is going away.

I am trying to assemble a small database but wonder should I continue if it is not being supported.

Spend some time thinking about which database engine you want to use.

Base can be used both as a database front end, or as combined front
end/database engine.

I don't know Base well enough to answer the rest of your questions. :frowning:

jonathon

#3

Hi Jonathan,
Thank you for your reply. I am using Libreoffice on Microsoft Windows 10
and always update Libreoffice when one becomes available. I have seen
comments that say Java can be a problem, if you moved over to Firebird does
this remove Java. These are questions being raised by someone who loves to
experiment but does not have a clue when it comes to programming, I leave
that to the experts.
If I continue to develop my database(s) and a change from HSQLdb to
Firebird takes place what effect might that have?

John

#4

Hi John,

Thank you for your reply. I am using Libreoffice on Microsoft
Windows 10 and always update Libreoffice when one becomes
available. I have seen comments that say Java can be a problem, if
you moved over to Firebird does this remove Java. These are
questions being raised by someone who loves to experiment but does
not have a clue when it comes to programming, I leave that to the
experts. If I continue to develop my database(s) and a change from
HSQLdb to Firebird takes place what effect might that have?

I won't change to Firebird with any version of LO at this moment.
Firebird is experimental since LO 4.2. Internal Firebird-DB has been
changed with LO 5.3 to a new version and those people, who have used
the experimental version for all LO-versions before have problems to
get the data from the old FB 2.5 to the new FB 3.0.

There is no problem to use the internal HSQLDB. It will work much
better than the internal Firebird-database at this moment. Many
databases have been designed with the internal HSQLDB. So it wouldn't
be moved away suddenly. There is no problem to switch from the
internal HSQLDB to a external HSQLDB.

I you need a more stable database: Switch to a external database. If
you need a database with more functions than the old HSQLDB you could
use MySQL/MariaDB or PostgreSQL or something else.

Java will also be nedded when using the internal Firebir-Database. It
isn't only the connection to the internal HSQLDB, which will need Java.

Regards

Robert
- --
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3

#5

I won't change to Firebird with any version of LO at this moment.

I haven't been following the FireBird migration. (I'd rather use
SQLite. But SQLite is only for those who like to live dangerously.)

There is no problem to use the internal HSQLDB. It will work much
better than the internal Firebird-database at this moment.

My concern is/was HSqlDb gets dropped from LibO. OTOH, even after being
dropped, it can be used as an external database. And, on the gripping
hand, it looks like in LibO 5.3.2.1 dBase 3 support is still alive. So
maybe a decade from now, both HSqlDB and FireBird support will be built
into LibO.

jonathon