Linux Format

Answers

Q Access all areas

I’ve recently retired and now I’m learning about Linux and have installed Linux Mint on a spare laptop. I used to write MS Access database projects for the office where I used to work. I’d like to create some projects for myself and friends, and there was a feature that I used back then. Access allows you to store the data and tables on a server and distribute a front-end app of forms, queries and reports that users could use on their PC to access the database, basically a client-server app. I was wondering if you know of any Linux database apps that work in a similar manner. I didn’t see anything like that in LibreOffice Base and that’s the extent of my knowledge of database applications in Linux. Can you point me to a software source that has that feature or is there an extension in LibreOffice Base that can be added on that mimics that feature?

Lupe Flores

A Most database systems used on Linux are client-server arrangements and LibreOffice can be used as a client in this way. However, LibreOffice is only able to connect to an existing external database, it cannot create one. The most popular database engine on Linux is MySQL. This is the server but it also includes command-line programs for creating, querying and maintaining databases. However, you may want a graphical tool to create databases and a couple spring to mind. MySQL Workbench is part of the MySQL project and

You’re reading a preview, subscribe to read more.

More from Linux Format

Linux Format5 min read
Some Ansible Advice For Around The Home!
Of late, this writer has been busy creating new virtual hosts for different things and decided that it would be an ideal time to get stuck into Ansible. Things have evolved in system management since Bash. Ansible is a great way to deploy software c
Linux Format14 min read
Ubuntu at 20
Without Ubuntu, the current Linux landscape would be unrecognisable. Back in October 2004, the first 4.10 (2004.10) release of Ubuntu, with its intriguing Warty Warthog code name, leapt from obscurity to being one of the most downloaded Linux distrib
Linux Format3 min read
Kernel Watch
Linus Torvalds announced the fourth RC (Release Candidate) for what will become Linux 6.9 in another few weeks. In his announcement, he noted that there was “Nothing particularly unusual going on this week – some new hardware mitigations may stand o

Related Books & Audiobooks