Seek and ye shall…
A database without a search function is like a car without an engine. The second part of our Base series is dedicated to implementing a database search.
LibreOffice Base
|
Dmitry Naumov, 123RF
The first part of this tutorial [1] explained how to create an image database with easy input masks and a tagging system (Figure 1). It satisfied the Base [2] claim that you can do database programming using mouse clicks instead of having to resort to SQL in Linux. Wizards and a graphical query editor do the work and let even users without programming experience create a database, forms, and queries.
The Base application from the first article lacked just one important feature: a search function (Figure 2). However, this task is one where the graphical helpers in Base are not going to help much – you can't do it without getting down and dirty with SQL.
Manual Labor
A query that filters matching records by keyword is not something the graphical editor can handle. It requires SQL code – such as programmers use to communicate with the database – fortunately, you're only going to need homeopathic-like dosages.
[...]
Use Express-Checkout link below to read the full article (PDF).
Buy this article as PDF
Express-Checkout as PDF
Pages: 3
Price $0.99
(incl. VAT)
(incl. VAT)
Buy Ubuntu User
TABLET & SMARTPHONE APPS
US / Canada
UK / Australia
Related content
-
Getting started with LibreOffice Base
Creating database applications with wizards and graphic editors – without SQL and programming – that's what the LibreOffice program Base, modeled after Microsoft Access, is all about.
-
Create menus and dialogs for shell scripts
From simple queries to complex menus: Using dialog, you can create a graphical interface for shell scripts with only a few extra lines of code.
-
Editing and converting videos with Avidemux
The easiest way to save space for digital videos is to reach for Avidemux and convert them with just a few mouse clicks.
-
Working with SQLiteStudio
SQLiteStudio, a compact graphical tool, lets you complete everyday tasks relating to SQLite databases quickly and easily.
-
Creating images containing GPS data
When you get back from a trip, you're usually bursting to tell everybody all about it and share your photos. Organizing your pics by location makes it easier to describe your adventures.