Visual Basic DatabasesVisual Basic - Databases
Databases Are for Dorks
Do It Once, Do It
Right, and Forget It Forever
Let's Look at Data
Tiering and Data
Getting Data Back
Beefing Up Two-tier
Three Approaches
to Client/Server Interactions
Classic Client/Server Computing
Journal/Temporary Entry
Stateful/Transactional/Conversational
Servers
Locking and Unlocking
The Trouble with Teraflops
When to Open and Close
Connections
Deciding Where to Put
Transaction Scope
Let's Get Tiering
What About SQL?
Static Lookup Data
Tiers and Data
Objects, State, and
Data: The Buxom Server
Still Not Sure What Data
Is Where Objects Are Concerned?
Data?the Currency of
an Object System
Remoting
Componentizing All of This
Epilogue
Most Visual Basic applications must, regretfully, have dealings with a database somewhere along the line. The current propaganda figure is 95 percent. This data access thing can be a dirty business, so if you have to do it, do it once, do it right, and forget it forever. This means write such a generic and reusable thing that even a gibbering Java programmer will be able to reuse it. How about a middle-tier DLL that you can use over and over again?