Creating a LibreOffice Music Database
Tune Finder
LibreOffice Calc and Base are all you need to create a simple database for organizing the songs in your music collection.
MySQL is the most commonly used open source database management system. Developers often use MySQL and its cousin MariaDB to build database applications for organizing office records, managing inventories, and other common tasks. However, MySQL is often too complex and too much trouble for personal, home-office uses. LibreOffice offers a simpler alternative for users who just want to create a small, simple database to address a specific need. This article describes how to create a quick and easy database solution using LibreOffice tools. In this case, I'll show you how to set up a music database from an iTunes library.
The Plan
I'll use two tools from the LibreOffice integrated suite to create my music database: LibreOffice Calc (spreadsheet) and LibreOffice Base (database management). With these two applications plus iTunes, the general process is as follows:
- Export library from iTunes as a tab-separated text file.
- Import library into LibreOffice Calc for minor edits.
- Copy modified library data into LibreOffice Base.
- Create SQL queries.
- Run queries and filters to display results.
[...]
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
US / Canada
UK / Australia
Direct Download
Read full article as PDF:
Price $2.95
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Find SysAdmin Jobs
News
-
MNT Seeks Financial Backing for New Seven-Inch Linux Laptop
MNT Pocket Reform is a tiny laptop that is modular, upgradable, recyclable, reusable, and ships with Debian Linux.
-
Ubuntu Flatpak Remix Adds Flatpak Support Preinstalled
If you're looking for a version of Ubuntu that includes Flatpak support out of the box, there's one clear option.
-
Gnome 44 Release Candidate Now Available
The Gnome 44 release candidate has officially arrived and adds a few changes into the mix.
-
Flathub Vying to Become the Standard Linux App Store
If the Flathub team has any say in the matter, their product will become the default tool for installing Linux apps in 2023.
-
Debian 12 to Ship with KDE Plasma 5.27
The Debian development team has shifted to the latest version of KDE for their testing branch.
-
Planet Computers Launches ARM-based Linux Desktop PCs
The firm that originally released a line of mobile keyboards has taken a different direction and has developed a new line of out-of-the-box mini Linux desktop computers.
-
Ubuntu No Longer Shipping with Flatpak
In a move that probably won’t come as a shock to many, Ubuntu and all of its official spins will no longer ship with Flatpak installed.
-
openSUSE Leap 15.5 Beta Now Available
The final version of the Leap 15 series of openSUSE is available for beta testing and offers only new software versions.
-
Linux Kernel 6.2 Released with New Hardware Support
Find out what's new in the most recent release from Linus Torvalds and the Linux kernel team.
-
Kubuntu Focus Team Releases New Mini Desktop
The team behind Kubuntu Focus has released a new NX GEN 2 mini desktop PC powered by Linux.