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
----------------------------------------------------------------------
