Creating a LibreOffice Music Database
Set Up and Run the Filter
The results that appear in the Table Data View list all songs and albums by Herbie Hancock in my music library. To narrow my search down to just songs in one of the three albums, I could create another query by repeating the five steps above, but there is an easier way. I use the Standard Filter in the Table Data View from this query result.
If the Table Data View is not already open, I can click on the Queries icon in the Database section Next I double-click Query_MyTable, and the Table Data View opens (Figure 11).
From there, I click on the Standard Filter icon in toolbar (Figure 12). In the Standard Filter dialog that opens, I select Album from the Field name drop-down list and like from the Condition drop-down list. Note: Using the like condition allows the use of wildcards to match partial strings in the Value field.
Next I enter the artist name in the Value text box. The Value string is case sensitive and requires exact spelling. Again I use the SQL wildcard percent (%) character (e.g., %Speak%), in place of the full album name Speak Like A Child. Other filter conditions can be applied to either the Artist, Song, or Album fields.
Filter Result
As shown from the six song tracks in Figure 13, the standard filter narrowed the album information to one album, Speak Like A Child.
This was a simple example to illustrate that by following the process I've described, LibreOffice can easily be used to migrate music information from iTunes into a searchable database and perform simple to moderately complex database queries.
Summary
To facilitate the database creation and query process for users that may have minimal familiarity with SQL, I used wizards to create a database table and SQL query. More sophisticated SQL users could write more complex queries and table relationships. Those features are available in LibreOffice Base.
Although I used the LibreOffice Base embedded database engine HSQLDB, Base can also connect to other popular SQL databases such as MySQL, MariaDB, and PostgreSQL, to name a few.
For users who need to create and manage one or more databases for personal, educational, or home office use, LibreOffice is faster to implement, simpler, and has a built-in user interface. LibreOffice achieves the same goals as the more complicated MySQL for simple to moderately complex database queries.
« Previous 1 2 3
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
![Learn More](https://www.linux-magazine.com/var/linux_magazin/storage/images/media/linux-magazine-eng-us/images/misc/learn-more/834592-1-eng-US/Learn-More_medium.png)
News
-
NVIDIA Released Driver for Upcoming NVIDIA 560 GPU for Linux
Not only has NVIDIA released the driver for its upcoming CPU series, it's the first release that defaults to using open-source GPU kernel modules.
-
OpenMandriva Lx 24.07 Released
If you’re into rolling release Linux distributions, OpenMandriva ROME has a new snapshot with a new kernel.
-
Kernel 6.10 Available for General Usage
Linus Torvalds has released the 6.10 kernel and it includes significant performance increases for Intel Core hybrid systems and more.
-
TUXEDO Computers Releases InfinityBook Pro 14 Gen9 Laptop
Sporting either AMD or Intel CPUs, the TUXEDO InfinityBook Pro 14 is an extremely compact, lightweight, sturdy powerhouse.
-
Google Extends Support for Linux Kernels Used for Android
Because the LTS Linux kernel releases are so important to Android, Google has decided to extend the support period beyond that offered by the kernel development team.
-
Linux Mint 22 Stable Delayed
If you're anxious about getting your hands on the stable release of Linux Mint 22, it looks as if you're going to have to wait a bit longer.
-
Nitrux 3.5.1 Available for Install
The latest version of the immutable, systemd-free distribution includes an updated kernel and NVIDIA driver.
-
Debian 12.6 Released with Plenty of Bug Fixes and Updates
The sixth update to Debian "Bookworm" is all about security mitigations and making adjustments for some "serious problems."
-
Canonical Offers 12-Year LTS for Open Source Docker Images
Canonical is expanding its LTS offering to reach beyond the DEB packages with a new distro-less Docker image.
-
Plasma Desktop 6.1 Released with Several Enhancements
If you're a fan of Plasma Desktop, you should be excited about this new point release.