LibreOffice Base
|
Conclusion
It's frustrating how quickly the principle of "click together" reaches its limits in Base. Even comparing table fields with each other loses its effectiveness in the graphical query editor. Fortunately, this sample database required an order of magnitude less code than a similar web application in Perl or PHP.
However, Base leaves a significantly less mature impression than LibreOffice text processing. The frequent program failures also add to this, some of which even cause database corruption in the worst cases. Consider well if you want to entrust critical data to Base. You should probably use an external database engine such as MySQL or PostgreSQL instead.
If you want to expand on the example given here, you can find comprehensive and clear guidance from the official handbook [3]. The online help accompanying the program is rather useless in comparison. l
Infos
- "Getting Started with LibreOffice Base" by Peter Kreussel, Ubuntu User , Issue 22: https://www.ubuntu-user.com/Magazine/Archive/2014/22/Getting-started-with-LibreOffice-Base
- LibreOffice Base: http://www.libreoffice.org/discover/base/
- Base handbook: https://wiki.documentfoundation.org/images/e/e8/BH40-BaseHandbook.pdf
« Previous 1 2 3 Next »
Buy this article as PDF
Pages: 3
(incl. VAT)
Buy Ubuntu User
US / Canada
UK / Australia
Related content
-
Getting started with LibreOffice Base
Creating database applications with wizards and graphic editors – without SQL and programming – that's what the LibreOffice program Base, modeled after Microsoft Access, is all about.
-
Create menus and dialogs for shell scripts
From simple queries to complex menus: Using dialog, you can create a graphical interface for shell scripts with only a few extra lines of code.
-
Editing and converting videos with Avidemux
The easiest way to save space for digital videos is to reach for Avidemux and convert them with just a few mouse clicks.
-
Creating images containing GPS data
When you get back from a trip, you're usually bursting to tell everybody all about it and share your photos. Organizing your pics by location makes it easier to describe your adventures.
-
Working with SQLiteStudio
SQLiteStudio, a compact graphical tool, lets you complete everyday tasks relating to SQLite databases quickly and easily.