This section provides examples of common queries that you may wish to run to retrieve data.
The queries below correspond to the latest version of the SQLite Database.
These can be implemented in the programming language of choice, or alternatively executed using a database viewer such as DBeaver.
hhhh is starting letters of the first 4 words in the line.
Note: it is preferable to select a translation source by its
id, than a text value, unlike the example above, since text values can change.
Fetch a list of Banis and their corresponding
SELECT * FROM banis.
Fetch a list of writers and their
SELECT * FROM writers.