Model Operations Processing System

Some time has been spent today becoming familiar with how SQLite fits in with Python; and it has been reasonably painless!  A couple of transactions have already been built for MOPS, and the aim now is to convert a substantial amount of MOPS to use the SQLite database and then to give it the same kind of testing that surfaced the problems with the file-based key locking that was uncovered earlier in the week.

Assuming that there are no horrors lurking in the testing, then development will continue with SQLite.  This approach will provide an option to switch quite easily to a server-based database (such as MySQL) if necessary, or even to simply provide it as an option (when an add-in is available for Python).

The implementation of SQLite from Python is amazingly straightforward; it’s built into Python itself so there are no concerns about implementing databases and other related issues.  At some point in the near future the database will also be tested across a network, including accessing the Windows-based database using MOPS running on Linux.