Lightning Fast Database Communication Program

This program runs in the background to updates databases from database server(s). The databases are accessed by an application specific program. An overview is discussed on the database page.

Windows Lightning Fast Database Communications Program

Figure 1: Lightning Fast Database Communications Program

This screen shot shows the case when the database server is not running, but the system is accessible (Connection Refused), and the communications application cannot connect to the server for an update. Updates are eventually disabled after multiple tries, but can be re-enabled by editing the database control record.

Internal Update Database

A local control database is used to manage databases being updated.

Database Select

Update Database Select Window

The databases that are being updated by the Lightning Fast Database Communication Program are managed by an internal Lightning Fast Database. Access to this database is by drop down Menu->Database->Edit Database List, which brings up the Database Edit Select window. A new database can be added by clicking on the Create New Database button. A current database update record can be edited by selecting one of the database buttons.


Update Database Main Dialog

Update Database Main Dialog

The Update Database Main Dialog box provides buttons for calling other dialog boxes to edit the various sections of the update control database record or deletion of the selected update database record.


Update Database Name Dialog

Update Database Name Dialog

The particular data base information for database ID, Database Name, and Server Name are entered for the database to access and update for.


Database Update Time Dialog

Database Update Time Dialog

A full selection of update timing can be set to determine when the program should do updates. This includes periodic as well as specific time of the day. The update immediately check box will do an update and clear (there is also a drop down menu item that). When the program starts, such as when starting the computer in the morning, and an update is expired, an immediate update will occur. An update will occur when sending data to the server, which will put the new/changed data into the database and receive the update data back to put into the local database copy.


General Database Settings Dialog

Update Database Settings Dialog

This enables the display of the update information and sets the display position in the user interface.


Database Update Directory Dialog

Database Update Directory Dialog

The local system location of the database directories are set.


Database Update TCP/IP Server Location Dialog

Database Update TCP/IP Server Location Dialog

The TCP/IP Server location and port are set. In this case there are 2 settings with the primary server and secondary server. A future change would be to 3 servers since, the use to 3 servers, allows a quorum of 2 to make data block id decisions when one system is down.


The database records for the database was being edited with a series of dialog boxes to allow information to be set, however this an example of a quick way to get the job done. A specialized data block edit page using a template page with extra information, might be used in a future, if just a plain data record block edit is not desirable for the application.