faqts : Computers : Databases

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

1 of 4 people (25%) answered Yes
Recently 1 of 4 people (25%) answered Yes

Entry

Computer: Internet: Database: What are possibilities to connect to a database via the Web?

May 2nd, 2008 21:07
dman, Knud van Eeden, http://sturly.com


----------------------------------------------------------------------
--- Knud van Eeden --- 12 February 2005 - 11:25 pm -------------------
Computer: Internet: Database: What are possibilities to connect to a 
database via the Web?
---
Typical setup:
Database connection = Webbrowser + Webserver + Middleware + Database
---
Typical Web browsers:
 -Internet Explorer
 -Opera
 -Netscape
 -Mozilla
 -Firefox
---
Typical Web servers:
 -Apache (open source)
 -Microsoft Internet Information Server (IIS)
 -Microsoft Personal Web Server
 -Netscape Enterprise Server
 -Xitami
---
Typical middleware:
 -ASP (server side / included in HTML page)
 -Batch (interpreter) - CGI
 -BBCBasic (interpreter with compiled programs) - CGI
 -C++ (compiler) - CGI
 -ColdFusion (server side / included in HTML page)
 -JSP (server side / included in HTML page)
 -Java (virtual machine) - CGI or module
 -PHP (server side / included in HTML page / open source)
 -Perl (interpreter) - CGI or module
 -Python (interpreter) - CGI or module
 -Tck (interpreter) - CGI or module
---
Typical databases:
 -Borland Firebird (relational database / open source)
 -Borland InterBase (relational database)
 -IBM DB2 (relational database)
 -Informix (relational database)
 -Microsoft Access (relational database)
 -Microsoft SQL Server (relational database)
 -MySql (open source / relational database)
 -Oracle (relational database)
 -PostgreSQL (object oriented database / open source)
 -Sybase PowerBuilder (relational database)
 -mSql (open source / relational database)
---
This means here totally
=
( total amount web browser on client ) .
( total amount web server on server ) .
( total amount middleware programs ) .
( total amount database ) .
=
 5 . 5 . 11 . 12 = 3300
different possibilities for such a setup
---
total descriptions (e.g. manuals, books) =
5 + 5 + 11 + 12 = 33
for such a setup
---
Typical configurations:
-Microsoft Internet Information Server + ASP + Microsoft SQL server
-Microsoft Internet Information Server + ASP + Microsoft Access
-Apache + MySql + PHP
-Apache + MySql + Perl
-Apache + MySql + Python
-Apache + Oracle + PHP
---
---
---
---
Example of some typical installation possibilities
|
|
+--Windows
   |
   +--MySql
      |
      +--PHP
      |  |
      |  +--Apache
      |  |
      |  +--IIS
      |     |
      |     +--module
      |     |
      |     +--cgi
      |
      +--Perl
      |  |
      |  +--Apache
      |  |
      |  +--IIS
      |     |
      |     +--module
      |     |
      |     +--cgi
      |
      +--Python
         |
         +--Apache
         |
         +--IIS
            |
            +--module
            |
            +--cgi
---
---
Internet: see also:
---
Database: Internet: Database backed web site: Link: Overview: Can you 
give an overview of links?
http://www.faqts.com/knowledge_base/view.phtml/aid/33424/fid/132
----------------------------------------------------------------------