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.
|
Dmitry Naumov, 123RF
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.
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.
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.
[...]
Pages: 3
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.
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.
The easiest way to save space for digital videos is to reach for Avidemux and convert them with just a few mouse clicks.
SQLiteStudio, a compact graphical tool, lets you complete everyday tasks relating to SQLite databases quickly and easily.
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.
© 2025 Linux New Media USA, LLC – Legal Notice