>
> A understanding of client-server system administration is a requirement
> for successful installation. If fictious users, adduser, port assignment,
> /etc/services, placing configuration environment variables in system-wide
> login scripts, and /etc/profile), are familiar to you, integration is a
> straightforward 30min task. If these are unfamiliar, I recommend the
> "How to ... install ..." chapter from any book in the O'Reilly & Associates,
> Inc. line of system administrator books (e.g. chap. 4 of sendmail
> ISBN 1-56592-056-2).
If you use the Postgres RPM on a RedHat machine, it is REALLY easy.
>
> > MPSQL is a very nice GUI front-end for SQL work.
>
> What is MPSQL?
It is a X app that lets you compose SQL statements (and load,save,print them)
and see the results (and save, print those as well). Way better than the
command line stuff.
> Where can one get MPSQL?
>
http://www.troubador.com/~keidav
Also has MPMGR, a nice database admin app for checking configuration, seeing a
tree view of a database servers and objects. Can examine the users and views
defined in a database, etc... Just like using a "real" enagine you paid $10k
for.
> I have been searching for a web <-> sql interface for the purpose
> of developing an easy-to-use, dependable (= double-entry) accounting system.
> One of the potential methods is to use JDBC, but I haven't been able to
> compile it, and it seems insupportably large (>11M).
Have you searched the "3rd Party" section of www.postgresql.org, it has some
SQL<->HTTP kinda stuff. Also look into PHP, it is a 4gl language module that
loads in the apache server and supports postgres. I've never used it, but I
have used Keystone (http://www.stonekeep.com/keystone.php3) and all I can say
is COOL. It must be quite flexable to pull that off, and it seems fast.
> Have you been able to compile JDBC for postgres?
I haven't tried, but I've seen it work on some one else's machine. But I've
also read some hate mail about it on the newsgroups.
> Where did you get libXp.so?
> Where did you get javac?
>
It comes with the JDK from www.blackdown.org I use there Java port to run the
Citrix ICA client for Java on Linux workstations in a production environment
and it seems very stable and quite peppy.
> host: Dell Dimension XPS-133c
> cpu: Pentium i586-133
> os: linux-2.0.35
> browser:Communicator-5.0 (netscape java-aware)
> javac: jdk-1.1.6
>
I've got a home-built Dual Pentium 200MHz with 256 Ram running Redhat 5.1 with
all the patches and Blackdown's jdk 1.1.6, linked up the seven X-terminals I
got for next to nothing. Unfortunately I'm still stuck with IDE hard drives
though, but we can always hope.
