[Mydatabasepilot-cvs] Docs DatabaseConnection.html,NONE,1.1
Status: Alpha
Brought to you by:
nanoface
Menu
▾
▴
[Mydatabasepilot-cvs] Docs DatabaseConnection.html,NONE,1.1
|
From: <nan...@us...> - 2003-04-06 07:59:11
|
Update of /cvsroot/mydatabasepilot/Docs In directory sc8-pr-cvs1:/tmp/cvs-serv17685 Added Files: DatabaseConnection.html Log Message: New File Added --- NEW FILE: DatabaseConnection.html --- <?xml version="1.0" encoding="iso-8859-1"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>MyDatabase Pilot Docs - ALGORITHM ANALYSIS - Database Connection</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body> <div style="font-size: 24px;font-weight: bold;color: #003399; background-color: #FFFFCC; text-align: center; margin: 3px 0px;">ALGORITHM ANALYSIS<br>Database Connection</div> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Connection Mechanism</div> <p style="text-align: justify;">We need a mechanism to connect to a Database and to simulate a constant connection to a database even though this is not physically possible over the stateless nature of the world wide web. The end user must perceive as if they have an open connection to the database once they have made an initial connection. This will be accomplished with session variables in the Application.cfm file.</p> <p style="text-align: justify;">The usual database connection variables in ColdFusion are datasource, username and password. These connection variables are usually hard coded in the <cfquery> tag. We will make these variables dynamic and give them a session scope. This will allow us to simulate a constant connection to a particular database.</p> <div style="font-size: 18px; font-weight: bold; color: #003399; margin: 3px 0px;">Flexibility</div> <p style="text-align: justify;">Some users will only ever use MyDatabase Pilot with one database (or at least most of the time). While others will connect to many different databases on a regular basis. The first set of users will demand the ability to hard code the most common database connection variables in MyDatabase Pilot so they will not have to manually connect to the same database every time they start using MyDatabase Pilot. This has security implications that need to be explained in the user guide. The users who are connecting to different databases regularly, or are more security conscious and want to avoid hard coding passwords, will require a login page to connect to the database. We will provide the flexibility to both types of users.</p> <p style="text-align: justify;">We will create a login page for security conscious, and multiple database users. We will also allow our users to hard code the connection variables to the most commonly used database in the Application.cfm file, and give them a link on the login page to use this "default database".</p> </body> </html> |
