This home page will give you an idea of the on-going applications of Postgres95. The applications are loosely divided into the following categories:
William Kearns (kearns@hal.fmhi.usf.edu): I've interfaced Postgres95 with our mosaic server and put a 4,338 record library database on it. Our faculty can now look up books held by the institute by title, author, notes, or abstract. (5/23/95)
The Earth Observations Lab in Toronto Canada is using postgres95 to store metadata about CASI Imaging Spectrometer. Data that has been collected as part of the BOREAS Project. They have developed a gateway, based on WDB, to provide access to their CASI database via the WWW. (Doug Dunlop dunlop@eol.ists.ca 5/25/95)
The HMWP is using Postgres95 to provide government and military sites with access to the Military Item Disposal Instructions (MIDI) database. The MIDI database provides guidance for proper disposal of a wide variety of items used by the military, from aspirin to paint. Items can be looked up based upon National Stock Number (NSN) or the name of the product. Non-exact searches for a portion of a name is supported. The database contains close to 70,000 NSN's. (Dave Davis ddavis@aehafs1.apgea.army.mil 7/22/95)
The Perseus Project is using Postgres95 to deliver its large database of ancient Greek art and archaeology to the the Web. The database contains 523 coins, 568 sculptures, and 1420 vases, with sites and architecture coming soon. The are currently about 3000 images on-line with new ones being added rapidly. Users can search the database through object attributes or keywords, or by full-text search of their textual descriptions. (David Smith dasmith@perseus.tufts.edu 8/24/95)
The Education Placement Service is a service of the University of Missouri College of Education that enables educators to search for statewide employment opportunities. It was developed with POSTGRES95 as its database backend and a custom World Wide Web front end built in-house. More information on the implementation is at the Education Placement Service Help Page. Contact Humphrey Loe <humphrey@coe.missouri.edu> for further information.
An Experimental Linux Directory Services Object Oriented Database using Postgres95. Advanced features under development; currently beta testing basic directory services on the net. Basic features include Postgres95, HTTPD cgi-bin, and lot's of perl-glue. (Tim Bass, The Silk Road Group, Ltd. bass@dune.silkroad.com 10/22/95)
Gautama Arts features Burmese, Thai and Khmer Works of Art and Antiques. Postgres95 is the back end DBMS to all works of art in the collection which includes Architectural, Buddhist, Decorative, and Ethnographic Art, ancient Manuscripts, Textiles, antique Furniture and Silver. Postgres95 is utilized, allowing customers to enter the Work of Art ID to retreive full details on particular items in the collection as well as automatic links to all graphical images (when available). (Awn Chiawvutthiphak, The Silk Road Group, Ltd. sales@silkroad.com 1/10/96)
The famous french bookstore "Le Monde En Tique" put its 18.000 titles database on the Web. Every people can browse the database and will be soon able to order books... A lot of books have summaries. Queries can be done by author, tittle, isbn number, thema, keyword...
Netscape's users will use the enhanced english form or the french form.
Other browsers will prefer the english form or the french form.
New titles are also availables on http://www.lmet.fr... (Paul COURBIS plc@lexem.fr 2/16/96)we here at Apuanet s.a.s. info@apuanet.bicnet.it use postgres95 in a wide range of applications interfacing httpd to postgres95 via cgi, libpq library and C. An example is our Marble Corner Infobase http://apuanet.bicnet.it/marble_corner/infobase.htm, a large database of companies and informations for the stone market, and we are currently working on many different projects where postgres95 will act as the database backend. (Arch. Luca Pregliasco upa@apuanet.bicnet.it 6/16/96)
Jalon Zimmerman (sneaker@powergrid.electriciti.com) of the Zimmerman Group: We market web services to businesses which need a full online application rather than a simple home page. Currently, we use Linux boxes for all parts of the development. All development is done in C and the C interface to postgres95. Right now, there is an online employment database going up which is a joint effort by several technology employment agencies across the US. They will share the database and the cost of maintenance. There are several apps being developed over the long term. One is a complete online service being designed for a major weight-loss company. This is a complete online service via HTML. I am currently basing it on postgres95. The system is designed for at least 30,000 members. There is also a proposal in the works for an html interface to telephony switching servers for online control of phone conferencing. This is being sent to the the military as a recommendation for the control of battlefield communications and group conferencing. The current system is under Visual Basic, but if this gets any bigger we will have to move Linux and postgres95. (5/28/95)
Brian Gallew (bg11@eden.as.cmu.edu): our helpdesk is written in Tcl/TK. 99% of the data is stored in Postgres. This includes tables of customers, operators/experts, mail groups and calls. The only data that isn't in Postgres is the actual text description (stored in flatfiles keyed by call id).
Operators enter calls, re-open closed calls, change shifts and update calls. The helpdesk software send email out to the groups the calls have been assigned to, requests regular updates and processes incoming mail. Users can close and update calls via email, with other functionality tentatively planned (like opening new calls).
I'm currently working on a WWW interface to it (which currently only does three queries). This helpdesk has been successful enough to have won our department a recognition award for our new service levels. (6/13/95)
Alistair Crooks (agc@uts.amdahl.com): I'm using Postgres95 as a repository for information relating to a large Operating System. This means including all the file levels that go into making a release, any modifications (which may touch more than one file in a single modification), and facilitating distribution of patches by identifying all the changed files that need to be distributed. This is done by a tcl script which runs using pgtksh. (5/26/95)
Stefan Golder (golder@informatik.uni-wuerzburg.de): I'm working on an image database holding medical images such as CT-images, X-ray images or photos of skin diseases. The doctor can start a retrieval by selecting several attributes as for example Name of patient, diagnose and so on. I have linked the database to the WWW to have a simple user interface and to have client-server support. The selected images can be viewed very easily with the external viewers supported by the WWW-clients. The images are stored as original and as a WFA (Weighted Finite Automata) compressed version to support slow networks. (5/26/95)
OpenLink Group Ltd. is a young middleware company which currently focuses on the ODBC market. We developed a suite of multi-tier ODBC clients for several operating systems, a UDBC library for developing ODBC-compliant applications on host systems, and a range of database agents which support this all (through a request broker) on the server side.
The core development team is hooked to Linux, and has been looking around for a way to make our product available (for free) on this system. Until we learned about Postgres95, no database system was `strong' enough to support our requirements.
At the moment, we are taking a very close look at P95, and are starting to build a database agent for it. As it is not a project where big customers put big bucks on the table, we can't give this project the high priority we think it deserves, but we hope we can deliver a first version in a couple of months.
The idea is to put a complete binary version of our product on the Net, so developers may use Linux as a free server for full-featured client-server development. We think Postgres95 will give those developers enough support to develop applications on this system, and run them against larger, commercial products later on.
This is not an official development of OpenLink Group Ltd., so please contact only me when you have questions or ideas (for general inquiries, contact oplodbc@openlink.co.uk).
(Cees de Groot cg@openlink.co.uk 5/27/95)
Go back to Postgres95 ...