Technical Paper

Development of a Server/Client Type Reagent Management System (Servo) Using PostgreSQL as a Database

Masahiko SUENAGA

Department of Chemistry, Faculty of Sciences, Kyushu University
812-8581 Hakozaki 6-10-1, Higashi-ku, Fukuoka Japan

(Received: July 26, 2002; Accepted for publication: November 25, 2002; Published on Web: January 31, 2003)

A server/client type reagent management system was developed. The system is briefly illustrated in Figure 1. PostgreSQL 6.5.1 running on the RedHat Linux 6.1 serves as a database. As a client to the database server, reagent management software was newly programmed with Java language. In order to obtain the weight readings automatically, an electric balance is connected to the client machine via RS-232C. Additionally, the barcode reader facilitates barcode input.
In the system, each of the reagents is managed by a barcode labled on the bottle. Since the system is server/client type, multiusers can access the database simultaneously from remote client machines and the maintenance of the database can be centralized.
The client software including the source code can be downloaded from the Web site of the author.

Keywords: Reagent management system, PostgreSQL, Java

Abstract in Japanese

Text in Japanese

PDF file(1,043kB)