From: | "Kevin Crenshaw" <kcrenshaw(at)viscient(dot)com> |
---|---|
To: | <brew(at)theMode(dot)com>, <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Best way to manage users |
Date: | 2006-01-04 17:20:06 |
Message-ID: | 20060104172010.A70BE9DC868@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Thanks for the replies. I appreciate the advice. However, I think that a
better way to pose my question is to ask - what are the pros and cons of
using Postgres to handle user authentication for my web app?
Thanks,
Kevin
-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of brew(at)theMode(dot)com
Sent: Wednesday, January 04, 2006 10:28 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Best way to manage users
Kevin.....
> I am talking about web app users. I would like to store contact
> information as well as billing related info like billing address and
> payment history and status.
If it's a web app the postgresql user will be only the web server.
That's separate from your web app users, you can set them up any way you
choose. Probably you'd use a table (perhaps called users) in your
database with a unique id (maybe user_id). Additional info (email_adr,
username, password, zip code, whatever) might be in other columns in that
table.
When those users get involved in data in other tables you'll use the
user_id as the foreign key to reference which user it is.
Sometimes novice posters have the postgresql user mixed up with the
website users.
Of course, they *might* be one and the same, in some cases, but *usually*
not in a web app.
What I did the first time I set up postgreSQL and a web app was read a lot
and set up a simple postgreSQL web app from a tutorial and play with it to
see how it worked.
What works for me is to learn by doing because I make mistakes, then learn
from them. (hopefully!)
brew
==========================================================================
Strange Brew (brew(at)theMode(dot)com)
Check out my Stock Option Covered Call website http://www.callpix.com
and my Musician's Online Database Exchange http://www.TheMode.com
==========================================================================
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Davis | 2006-01-04 17:36:55 | Re: Best way to manage users |
Previous Message | brew | 2006-01-04 15:27:57 | Re: Best way to manage users |