PostgreSQL - Jak To Zrobić w Linux-ie: Web Database Design/Implementation tool for PostgreSQL - EARP
Następna
Poprzednia
Spis treści
14. Web Database Design/Implementation tool for PostgreSQL - EARP
http://www.oswego.edu/Earp
ftp://ftp.oswego.edu in the directory 'pub/unix/earp'.
14.1 What is EARP ?
The "Easily Adjustable Response Program" (EARP) created by David Dougherty.
EARP is a Web Database Design/Implementation tool, built on top of the PostgreSQL database system. Its functionality includes:
A Visual Design System.
A sendmail interface. (can handle incoming and outgoing mail)
An Enhanced Security Mechanism.
A cgi driver.
14.2 Implementation
The main implementation of EARP is a CGI binary which runs under the http daemon to provide access to the database server. All of the design tools are built into the driver, no design takes place over anything but the web. The tools themselves require a graphical browser, the compatibility of objects designed with the tools is implementation independent, based on designing individuals preferences.
14.3 What you need to run EARP
EARP will likely run on a variety of platforms with little or no porting. The known working platforms consist of the following:
Solaris 2.5
Linux 1.2.13+
GNU C++
PostgreSQL (Version 1.01 / 1.02 )
netsite server
NCSA httpd
GNU C++
PostgreSQL (Version 1.01 / 1.02 )
NCSA httpd
Apache httpd
The current (1.3) release of Earp was designed on top of the libpq release that came with PostgreSQL v1.01/1.02.
If you are using a more recent version of Postgres, expect that the program will require some porting to work correctly. In the development version (Earp 2.0), libpq support is being
incorporated as a module.
14.4 How does it work ?
One of the main features of EARP is that it uses an Object
Oriented approach to producing html pages which interface to
the database. Most pages will consist of several objects. Each
object is produced by some sort of tool and given a name,
objects are then linked together in a callable sequence by the
page tool. Objects are also reusable across multiple pages.
Basic tools exist for HTML, Querys, Grabbing input from
forms, Extendable Formatting of Query and Input objects, and
Linking together of objects into other objects. More advanced
tools include the mail tool and the multithreaded query tool.
Another feature of EARP is advanced security. Access to
various areas of the EARP system can be limited in a variety
of ways. To facilitate its advanced security, EARP performs
checks for each connection to the system, determining what
ids and groups the connecting agent belongs to. Access to
areas is defined seperately, and the combination decides if
access to a specific area of Earp is allowed. Moreover, all that
is required to implement the security features is an http server
that supports basic (or better) user authentication.
14.5 Where to get EARP ?
EARP is available via anonymous ftp from
ftp://ftp.oswego.edu in the directory 'pub/unix/earp'.
Następna
Poprzednia
Spis treści
Wyszukiwarka
Podobne podstrony:
PostgreSQL HOWTO pl 18PostgreSQL HOWTO pl 29PostgreSQL HOWTO pl 5PostgreSQL HOWTO pl 7PostgreSQL HOWTO pl 20Keyboard HOWTO pl 14 (2)PostgreSQL HOWTO pl 6PostgreSQL HOWTO pl 3PostgreSQL HOWTO pl 9PostgreSQL HOWTO pl 1PostgreSQL HOWTO pl 32PostgreSQL HOWTO pl 8printing howto pl 14PostgreSQL HOWTO pl 22PostgreSQL HOWTO pl 26PostgreSQL HOWTO pl 27Serial HOWTO pl 14 (2)PostgreSQL HOWTO pl 10więcej podobnych podstron