Portable Database Functions
(Page 1 of 5 )
Want to write a rock-solid, dependable application, but in record time? Code efficiency is the key! This article provides useful tools and ideas to speed up your database interactions in ASP, as well as a best-practice you just might be convinced to adapt for your database-driven applications.
Introduction
Let’s face it; we live in a fast-paced society! Demands are placed upon us to meet deadlines, and a good expectation to maintain is that those deadlines will seem stressfully unrealistic. When tasked with creating a web-based application, we have to factor in time for the requirements-gathering phase, design phase, development phase, debugging phase, and finally the tedious documentation phase. (No, we can’t include the stress-induced coma phase, sorry)
One of the best ways to speed up the development phase – well, besides just typing faster – is to simplify common procedures into reusable functions. This article will examine ways to do this with some common database interactions.
Many development suites (i.e. Dreamweaver) provide inbuilt mechanisms for handling some pf these common procedures. But if you’re at all like me, you prefer total control over your coding. If you’re not like me, you need to watch the Matrix, and ponder deeply its significance regarding your consent to allowing programs control over your work. Ok ok, there’s nothing wrong with your preference, but at least continue reading to see if the efficiencies described appeal to you.
I will cover two common procedures, and one perhaps not as common, but that I highly recommend. These are: executing SQL statements, retrieving a count of specific items within a table, and auto-incrementing. For all three we will examine a simple, reusable tool to do the job right, and fast. The most you can expect from using these tools is the burden of that deadline being lightened; the least you can expect is that they’ll make your life a little simpler.
Next: Tool #1: Quick Execution >>
More Database Articles
More By Justin Cook
