Re: Where do I start?

kynn......

> I just installed PostgreSQL in my machine (OS=Linux Debian). Where to
> next? What should I be reading to get to the point of being able to
> set up the PostgreSQL component of "learning project" as quickly as
> possible?

Check that you can connect to the database from as a user. If not, maybe
you can connect to it from pg's root, postgres, I think, in Debian. Then
figure out how to connect as another user.

Create a database (from root postgres? I forget). Then make a short file
defining a table and a few rows of data and put it in from pgsql command
line tool. Something simple, just to test.

Read it out, using pgsql, enter a select statement a see your table.

So now you know the server is working, it has a database with a table of
your data, and some user can connect and read it from the command line
using pgsql.

Next write a short perl script to connect and read the data. Then try
putting a copy of it in public_html and access it through Apache....

lynx 127.0.0.1/~user/script.pl

Sounds simple, but by the time you get this far you'll be well on your way
to learning the HowTo. Of course, then you go on to the other stuff, but
if you're like me it was so frustrating to get this far, but when you
figure it out you'll really know!

Of course, I don't know how much you know about Debian already, but it
probably took me about a week working a couple of hours a day to get this
far, if I recall. Embarrassing, really, but that's how I learn.

I like to use php under Apache for web connections to the database and
perl for background maintenance tasks, running them with cron, but of
course you can do it lots of ways.

Hope this helps..... but you WILL need to do lots of reading, too.

brew

==========================================================================
Strange Brew (brew(at)theMode(dot)com)
Check out my Musician's Online Database Exchange (The MODE Pages)
http://www.TheMode.com
==========================================================================