[Biodevelopers] what databases are you using?

[Joe Landman]

Hi Pawel:

On Thu, 2002-07-11 at 08:34, Pawel Krasucki wrote:
> I was going to setup a test environment and was trying to figure what db
> to setup as well.  You mentioned using Postgres, have you ever worked
> with MySQL?  Although I've installed Postgres, I haven't worked with it
> at all, is it hard to pick up and work with?  I had it running on Linux,

I guess my comparison would be Oracle or Sybase.  Getting Postgres
working is not difficult.  It is easy if you are installing from rpms. 
If you are building it yourself (I do recommend this for larger usage
patterns), make sure you configure it to allow a large number of
connections.  Most RPM's by default are configured for 32 to 40
connections at max.  This is great for most small/tiny projects, but not
so great for larger projects.  Also make sure you build in SSL support,
as well as increasing various other constants.

You have to modify the pg_hba.conf file to allow users on remote
machines/clients to access the database.  You need a line that looks
like this:

    host         all         x.y.z.t   a.b.c.d	password 

where x.y.z.t (a.b.c.d) is the net (netmask) address.

Make sure you add the -i option to the /etc/init.d/postgresql startup
code.  Mandrake and a few others needed adjustment.  Change the
postgresql.conf file to turn on the enabled (-i on the postmaster) tcpip
support.

    tcpip_socket = true

will allow remote clients to connect.  

As far as GUI admin, there are several tools, but I havent used any of
them.  You can use phpPgAdmin
(http://freshmeat.net/projects/phppgadmin/?topic_id=68%2C67) or the Java
SQL Admin Tool
(http://freshmeat.net/projects/sql-admin/?topic_id=68%2C66%2C45%2C259).

> and was using GUI utility with Linux to administer Postgres,  is that a
> common way to administer that db?  

I do things by hand.  Gui tools are nice, but they dont work so well
from 2000+ miles away (~3300 km).

> 
> Paul Krasucki
> IT Supervisor
> Professional Solutions STAT Inc.,
> St. Louis, MO  63114
> (314) 428-8335 ext 129
>  
> 
> -----Original Message-----
> From: biodevelopers-admin at bioinformatics.org
> [mailto:biodevelopers-admin at bioinformatics.org] On Behalf Of Joe Landman
> Sent: Wednesday, July 10, 2002 09:55 PM
> To: biodevelopers
> Subject: [Biodevelopers] what databases are you using?
> 
> A few years ago, the db of choice was some sort of Oracle implementation
> for many people I spoke to/worked with at a variety of pharmas and
> biotechs.  I am curious what people are using now (if anything).  I do
> know people using flat files for a variety of reasons as well.
> 
> Just curious.  I use/like Postgres for my own development/testing.
> 
> -- 
> Joe Landman,
> email: landman at scientificappliance.com
> web  : http://scientificappliance.com
> 
> _______________________________________________
> Biodevelopers mailing list
> Biodevelopers at bioinformatics.org
> http://bioinformatics.org/mailman/listinfo/biodevelopers
> 
> _______________________________________________
> Biodevelopers mailing list
> Biodevelopers at bioinformatics.org
> http://bioinformatics.org/mailman/listinfo/biodevelopers
-- 
Joe Landman,
email: landman at scientificappliance.com
web  : http://scientificappliance.com