When small businesses, community organizations, and similar-sized groups realize they need software to manage their data, they think first of Microsoft Access. That may be the right choice if you’re already paying for a Microsoft Office subscription or don’t care that it’s proprietary. But it’s far from your only option—whether you prefer to use open source alternatives from a philosophical standpoint or you don’t have the big budget for a Microsoft Office subscription—there are several open source database applications that are worthy alternatives to proprietary software like Microsoft Access or Apple FileMaker.
If that sounds like you, here are four open source database tools for your consideration.
In case it’s not obvious from its name, Base is part of the LibreOffice productivity suite, which includes Writer (word processing), Calc (spreadsheet), Impress (presentations), Draw (graphics), Charts (chart creation), and Math (formulas). As such, Base integrates with the other LibreOffice applications, much like Access does with the Microsoft Office suite. This means you can import and export data from Base into the suite’s other applications to create financial reports, mail merges, charts, and more.
Base includes drivers that natively support multi-user database engines, including the open source MySQL, MariaDB, and PostgreSQL; Access; and other JDBC and ODBC-compliant databases. Built-in wizards and table definitions make it easy for new users to quickly get started building tables, writing queries, and creating forms and reports (such as invoices, sales reports, and customer lists). To learn more, consult the comprehensive user manual and dive into the user forums. If you’re still stuck, you can find a certified support professional to help you out.
Installers are available for Linux, MacOS, Windows, and Android. LibreOffice is available under the Mozilla Public License v2; if you’d like to join the large contributor community and help improve the software, visit the Get Involved section of LibreOffice’s website.
DB Browser for SQLite
DB Browser for SQLite enables users to create and use SQLite database files without having to know complex SQL commands. This, plus its spreadsheet-like interface and pre-built wizards, make it a great option for new database users to get going without much background knowledge.
Although the application has gone through several name changes—from the original Arca Database Browser to the SQLite Database Browser and finally to the current name (in 2014, to avoid confusion with SQLite), it’s stayed true to its goal of being easy for users to operate.
Its wizards enable users to easily create and modify database files, tables, indexes, records, etc.; import and export data to common file formats; create and issue queries and searches; and more. Installers are available for Windows, MacOS, and a variety of Linux versions, and its wiki on GitHub offers a wealth of information for users and developers.
DB Browser for SQLite is bi-licensed under the Mozilla Public License Version 2 and the GNU General Public License Version 3 or later, and you can download the source code from the project’s website.
As the database application in the Calligra Suite productivity software for the KDE desktop, Kexi integrates with the other applications in the suite, including Words (word processing), Sheets (spreadsheet), Stage (presentations), and Plan (project management).
As a full member of the KDE project, Kexi is purpose-built for KDE Plasma, but it’s not limited to KDE users: Linux, BSD, and Unix users running GNOME can run the database, as can MacOS and Windows users.
Kexi’s website says its development was “motivated by the lack of rapid application development (RAD) tools for database systems that are sufficiently powerful, inexpensive, open standards driven, and portable across many operating systems and hardware platforms.” It has all the standard features you’d expect: designing databases, storing data, doing queries, processing data, and so forth.
Kexi is available under the LGPL open source license and you can download its source code from its development wiki. If you’d like to learn more, take a look at its user handbook, forums, and userbase wiki.
NuBuilder Forte is designed to be as easy as possible for people to use. It’s a browser-based tool for developing web-based database applications.
Its clean interface and low-code tools (including support for drag-and-drop) allow users to create and use a database quickly. As a fully web-based application, data is accessible anywhere from a browser. Everything is stored in MySQL and can be backed up in one database file.
Do you have a favorite open source database tool for building simple projects with little or no coding skill required? If so, please share in the comments.