How to create your own database on Linux

Best cloud databases
Image Credit: Pixabay (Image credit: Pixabay)

These days, databases are more routinely associated with powering websites and the best ecommerce platforms. To the casual user they look impenetrable, involving connecting to third-party database servers such as SQL and hiding behind opaque languages like PHP. 

But at their heart, databases are simple tables of information: each row represents a single record, and its specific characteristics – such as name, colour, or whether it’s currently in your possession or not – are recorded in columns known as fields.

If your needs are modest, then you don’t need to learn any programming languages or tackle complex database software to put together a collection of information you can later search in various ways to find what you need from it. 

About this article

This article first appeared in Linux Format Magazine, Issue #267, published in September 2020.

Indeed, many people build such simple databases using spreadsheet software, but even here there’s a whole new interface to learn and tools to find. There are only so many hours in the day. 

Luckily, there’s a whole host of simple, user-friendly tools that wrap up simple databases in software anyone can set up and use within minutes. Many are geared towards specific tasks, such as cataloguing a collection of plants, but there’s one tool that offers all the features you’d expect of a simple database in a user-friendly format: Symphytum.

Symphytum is a throwback to the days when databases were simple to construct. Start by designing your database. First, define the fields that make up each record. Assign each field a data type, such as text, numbers, date, image, check box or drop-down menu, then design a form into which you enter the details of each record. 

The form also serves as a viewing tool for individual records, while a secondary table view provides you with an overview of your entire database, with the means to sort and filter the view using a simple keyword-based search tool.

There’s no programming language to learn or no confusing interface to navigate, making Symphytum the perfect tool both for those with straightforward requirements as well as those looking for a gentle entry point into the world of databases in general.

screenshot of symphytum

When entering records in Form view, click the lock button to focus on data entry and not form redesign. (Image credit: Symphytum)

Get started

You can install Symphytum a number of ways. Snap is the most convenient for later versions of Ubuntu, but you can also download your choice of .deb. .aur or . AppImage package from the program’s website.

Once installed, launch Symphytum (from the App Launcher in Ubuntu) where you’ll see a small dummy database is already in place to help familiarise you with the program. There are two views: Form and Table. As we mentioned, Form is primarily for data entry and reviewing individual records, while Table enables you to view all the records at once. You can also edit individual records from here, too.

Symphytum stores all your collections in a single file – data.db – that’s buried deep inside a hidden folder. This is powered by an embedded SQLite database engine, so it’s a standard format easily ported to other programs (more on that later). If you’d rather move the file somewhere more accessible then choose Tools>Preferences and click Browse... 

Building a database from scratch is a simple affair with Symphytum: the step-by-step guide over the page reveals the basic process you need to follow in terms of setting up fields and designing the form for both data entry and reviewing individual records. And that’s the program’s beauty – you can have a fully formed database up and running in just minutes.

TOPICS
Read more
An abstract image of a database
Best database software of 2025
Ubuntu website screenshot
Best Ubuntu app of 2025
A close up of a person typing on a MacBook keyboard.
Best open source software of 2025
Cyber security Cloud computing blue abstract digital binary code background. Innovative technology and Artificial intelligence concept. New futuristic system technology symbol. Vector illustration.
Best cloud database of 2025
A young woman and a man shaking hands over a job contract
Best open source CRM of 2025
A computer screen showing a spreadsheet in use.
Best spreadsheet software of 2025
Latest in Software & Services
woman listening to computer
AWS vs Azure: choosing the right platform to maximize your company's investment
A person at a desktop computer working on spreadsheet tables.
Trello vs Jira: which project management solution is best for you?
Autonomous finance
Quickbooks vs Quicken: what are the main strengths and weaknesses for your business
finance
Quickbooks vs Xero: which is the best for your business?
Group of people meeting
Zoom vs Google Meet: which is the best video conferencing tool for your business?
Fingers typing on a computer keyboard.
Microsoft 365 Personal vs Microsoft 365 Family: are there any real differences?
Latest in How Tos
Trinity Rodman #2 of the Washington Spirit crosses the ball during a game between Bay FC and Washington Spirit at Audi Field on November 10, 2024 in Washington, DC.
National Women's Soccer League 2025: How to watch NWSL games live from anywhere
AMD Radeon RX 6000 Series Graphics Card on top wooden desk beside a keyboard
How to update AMD GPU drivers
tiktok
How to edit TikTok videos
Using an Amazon Fire Stick on a Smart TV
How to use a VPN with Fire Stick
Irish boxer TJ Doheny receives an undercard bout, ahead of the WBO super welterweight world title fight in March, 2023
Ball vs Doheny live stream: how to watch the boxing from anywhere now, full undercard, start time, weigh-in results
 Facebook social media app logo on log-in, sign-up registration page
How to delete all your Facebook posts