Java Reference
In-Depth Information
14.8
P
ERSISTENCE
I
S
N
OT THE
W
HOLE
S
TORY
In this chapter and throughout this topic we take a practical view that a
database is there to store an application's data. That's far from the intent. A
relational database is designed to create collections of data and to perform logi-
cal queries within and between those collections. The relational model is much
more than application storage. It facilitates all kinds of data analysis. This is
often ignored in enterprises these days.
Don't forget that designing database tables should take into account
concerns beyond mere application storage.
14.9
S
ETTING
U
P
P
OSTGRE
SQL
FOR
B
UDGET
P
RO
Let's turn our attention to installing and starting PostgreSQL to support the
BudgetPro application.
14.9.1
The simplest way to install PostgreSQL is to use precompiled binary packages.
RedHat and Fedora have RPM packages for installing the database and client
software (although neither distributes the client libraries for Java due to licens-
ing issues with Java itself ). The PostgreSQL project produces RPM packages
of their own, including the Java JDBC class library. Those might be your easiest
course. Debian packages for PostgreSQL exist, but again, they do not provide
the JDBC library.
For our purposes, we are going to assume that you have downloaded and
installed the following RPM packages
9
from the PostgreSQL Download page:
10
Installing PostgreSQL
•
postgresql-server
•
postgresql-devel
•
postgresql-jdbc
•
postgresql-docs
(optional)
9. If you are a user of Debian or another Debian-based Linux distribution, you should be aware
that there is a Debian package called
alien
, which can install and manage RPM packages on
a Debian system.
10.
http://www.postgresql.org/mirrors-ftp.html
