Is there a database management software for Ubuntu alternative to LibreOffice Base?
LObase works fine for a while, but occasionally the files I'm working on get corrupted and I lose all my work.
-
The only consideration I would mention is that LO Base is a front-end tool for the database of your choice. It has a default db that it will use if you do not provide it with a database to use. I have to wonder if your corruption issue is due to the database engine, and might be addressed by switching databases, not the front-end (Base). Example - switch to MySQL as your back end. I can't say I know this is your problem - but it is a thought.– Mark G BFeb 21, 2014 at 0:22
Add a comment
|
4 Answers
Try Kexi.
Kexi is an open source visual database creator, a long-awaited competitor for programs like MS Access or Filemaker.
It is part of the Calligra Suite (but can be used completely independently).
To install from the software center:
Kexi 
From the command line:
Press Ctrl+Alt+T on your keyboard to open Terminal.
When it opens, run the following command:
sudo apt-get install kexi
For more information, or to download Kexi, see the Kexi website
-
Kexi does look promising, however, there are problems importing data from MySql/CSV/ODS and the process terminates. Also, there doesn't seem to be any option to directly work on MySql database although it connects alright. Note: for MySql connection on localhost, uncheck the socket file based connection option on the details tab of add new connection.– SriFeb 26, 2014 at 9:33
-
The install link redirects to snapcraft.io, which in turn does not find "kexi". But I found it on packages.ubuntu.com, so you can install it with
apt-get.– LeventeApr 8, 2021 at 19:23
You can try Glom. It's a complete database system like FileMaker Pro (or Access).
With Glom you can design table definitions and the relationships between them, plus arrange the fields on the screen. You can edit and search the data in those tables, and specify field values in terms of other fields. It's as easy as it should be. The design is loosely based on FileMaker Pro, with the added advantage of separation between interface and data. Its simple framework should be enough to implement most database applications. Without Glom these systems normally consist of lots of repetitive, unmaintainable code.
To install from the software center:
Glom
From the command line:
Press Ctrl+Alt+T on your keyboard to open Terminal.
When it opens, run the following command:
sudo apt-get install glom
For more information, see the Glom website
Since the reason for looking for an alternative was data corruption, here's another option: use LibreOffice Base with a split-database configuration, instead of with the default embedded datatabase.
By default Base uses HSQLDB (v1.8) combined with the Base configuration in a zip file. This bundling of database structure and data with other settings makes the file susceptible to data corruption.
Instead, you can convert existing databases to a split-database configuration, and/or start new projects with a split-database wizard which uses HSQLDB (v2.3).
The split-database configuration requires macro functionality to be enabled.
I just found out about
The best one I found yet for connecting to a server and editing simple databases with a simple GUI. Currently free for Linux (not floss tough).
Kexi is great too, but according to the FAQ, it cannot use an existing database because it needs to store metadata in the database also.
