SRA OSS, Inc.
Last Update: 2003/03/10
JAPANESE   |   ENGLISH


What's PostgreSQL?


Our Support


High Availability
PostgreSQL Pack


Link


Contact










What is PostgreSQL?

Full-Scale RDBMS PostgreSQL is an open source software and was developed by volunteers from all over the world. Its distribution is based on the Berkeley License which places no limits on usage. Therefore it has infinite possibilities, not only as a teaching tool for those interested in learning about high performance database systems, but as a serious tool for production quality business applications.
Comparison of PostgreSQL and Commecial DB
Open Source PostgreSQL is an open source software and was developed by volunteers from all over the world. Its distribution is based on the Berkeley License which places no limits on usage. Therefore it has infinite possibilities, not only as a teaching tool for those interested in learning about high performance database systems, but as a serious tool for production quality business applications.
Other features of PostgreSQL
Low Cost
High Quality
High Correspondence
With PostgreSQL and Linux combined system, it is easy to cut down the initial cost, and to expand the system as the bussiness grows. We provide you the best cost-performing solution at the time of hardware deployment by reducing the usage of commercial operating system and commercial database.
Back End DB for Web Applications PostgreSQL is not just a batch database system; it also works well as online resource with Web applications. Our extensive experience shows that you gain the most leverage when combined with PHP, a server-side script language.

Comparison of PostgreSQL and Commecial DB

FEATURES PostgreSQL Commercial DB
TRANSACTION YES YES
MVCC YES SOME
ROW LOCK YES YES
FOREIGN KEY YES YES
SUBSELECT YES YES
OUTER JOIN YES YES
USER DEFINED DATA TYPE YES SOME
STORED PROCEDURE YES YES
TRIGGER YES YES
RULE YES NO
DISPERSION DATABASE NO YES
REPLICATION (*) SOME
TRANSACTION LOG YES YES
MULTIBYTE YES SOME
OPEN SOURCE/FREE SOFT YES NO
(*)Enable by using commercial tool.

Other features of PostgreSQL

Great For Enterprise Usage Since PostgreSQL is able to operate 24hours+365days, it is suitable for large-scale application. Also, you do not have to pay any kinds of license fee, so it is a quick solution for cost down. Using PostgreSQL in commercial software is possible.
Various API You may use: PHP, JAVA, Perl, Tcl/Tk, C, C++, Ruby, and many more.
Easy to Manage With automatic expansion of memory storage and "HOT BACKUP", which enables to backup consistent data while operating database, it is easy to manage and maintain database.
Works on Many Platforms Works on: Linux, Solaris, FreeBSD, AIX, HP-UX, Windows
Many Possible Usage From web application, enterprise systems, to POS system!


Copyright © 2005-2013 SRA OSS, Inc. Japan All rights reserved.