InterBase in a Multitier World (ID #19041)

Craig Stuntz

The topic of creating multi-tier clients and application servers could easily -- and does -- fill several books. It is far too large for one presentation. This paper, therefore, is not intended to be a comprehensive guide to the subject, but, rather, is designed to shed more light on some areas which existing references don't cover in great detail. In particular, this paper examines how to integrate InterBase into common patterns for multi-tier development.

Before reading this paper you should be generally familiar with the DataSnap framework in Delphi. No attempt will be made to explain how to use TClientDataset! (Note: If you're not familiar with the DataSnap architecture in Delphi, see the papers listed in the References section of this paper and the various applications in the DemosMidas directory of your Delphi installation.) You should also be very comfortable working with InterBase.

So what will the paper cover?

* Using multiple remote data modules and data module inheritance to partition and reuse code in both the client application and the app server.
* Using InterBase-specific features such as generators.
* Understanding transaction management in DataSnap..
* Understanding state, especially as it pertains to database user security.
* Choosing a threading option which works with the InterBase client.

InterBase in a Multitier World home page