Lead Image © yewkeo, 123RF.com

Lead Image © yewkeo, 123RF.com

Five graphical database front ends

Knowledge – Managed

Article from ADMIN 52/2019
By
Skillfully formulated SQL statements are not everyone's favorite pastime. But graphical front ends can help manage data, so even newcomers will benefit from complex data collections.

Whereas data records are typically quite manageable and simply structured, the search queries needed to manage them are quite different. Anyone who has ever formulated SQL queries manually will be familiar with this phenomenon. Management systems can help users access existing databases, but they differ considerably in terms of their options and functionality.

For smaller companies, several free software solutions make using and managing even complex databases easier. To ensure a database application's efficiency, as well as acceptance among non-IT employees, the decisive factor is how easily it can be operated in front ends. Above all, this includes how easily users can create queries that give them quick access to the data.

In this article, I look at several free front ends: Base [1], Glom [2], Kexi [3], MySQL Workbench [4], and Valentina Studio [5]. In particular, I examine how well the software helps end users create databases and queries.

Base

Base [1] is the integrated database system in LibreOffice [6] and OpenOffice [7]. It is not uncommon for Base to end up automatically on your drive when you install these office suites. If not, you can usually install manually from the package sources.

When you start Base, a wizard prompts you to select whether you want to create a new database file or load an existing one. The wizard also gives you access to external databases on request. The wizard supports a variety of servers, including Adabas, MySQL,

...
Use Express-Checkout link below to read the full article (PDF).

Buy this article as PDF

Express-Checkout as PDF
Price $2.95
(incl. VAT)

Buy ADMIN Magazine

SINGLE ISSUES
 
SUBSCRIPTIONS
 
TABLET & SMARTPHONE APPS
Get it on Google Play

US / Canada

Get it on Google Play

UK / Australia

Related content

  • Maatkit tools for database administrators
    The Maatkit tool suite helps administrators with performance tuning and other tasks for MySQL and other databases.
  • Speed up your MySQL database
    Sometimes, the throughput or response time of your MySQL database does not meet expectations. In this article, we show how you can handle some MySQL performance problems.
  • MariaDB vs. MySQL

    MariaDB is a cousin of MySQL – but not an identical twin.

  • Uncovering SQL Injections

    Hardly a day goes by without reports of hackers breaking into government, military, or enterprise servers. If you analyze the details of the hacker’s approach, you will see that, in 90 percent of all cases, SQL injection was the root cause of a server’s compromise.

  • Discovering SQL injection vulnerabilities
    Hardly a day goes by without reports of hackers breaking into government, military, or enterprise servers. If you analyze the details of the hacker's approach, you will see that, in 90 percent of all cases, SQL injection was the root cause of a server's compromise.
comments powered by Disqus
Subscribe to our ADMIN Newsletters
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs



Support Our Work

ADMIN content is made possible with support from readers like you. Please consider contributing when you've found an article to be beneficial.

Learn More”>
	</a>

<hr>		    
			</div>
		    		</div>

		<div class=