Although Rekall automatically accesses the server database when it gets data for a form or report, or when the user makes changes to data in a form, Rekall also allows direct access to the server database. It does this by providing a python class RekallPYDBI which is a (partial) implementation of the python DBI2 specification.
Essentially, RekallPYDBI allows you to write and execute SQL queries that interact directly with the server database ( You can, of course, import another python DBI module and use that to access a server database, however you will need to code in details such as the username and password for the server database. ) . Currently, just the select, insert, update and delete SQL commands are supported (so you cannot, for instance, create or drop a table).
The third section of this chapter describes how you can shortcut some of the logic described below, so you may want to have a quick look before returning.
Connecting to the server database