sessions and postgres
Posted: Fri Dec 13, 2002 3:19 pm
well since cookies are to quirky(will work some of the time, but relies to much on the user). can i get any suggestions from the group on how to make a session management tool with postgres.
basically the user will login to the page (utilizing https) and from that form we validate off of the postgres user table the person is a member and set the sessions.
would i set all sessions the ie:
userid
userlevel
userteam
from the data in the table? or do i create a table and enter user data for the sesison when they logon and delete the data when they logoff?
or set one session userid and query the db on each page to get the rest of the data?
this is on a pretty weak server so i was concerned about using up memory.
i know there are many questions, any suggestions on the best path would be appreciated.
soshea
basically the user will login to the page (utilizing https) and from that form we validate off of the postgres user table the person is a member and set the sessions.
would i set all sessions the ie:
userid
userlevel
userteam
from the data in the table? or do i create a table and enter user data for the sesison when they logon and delete the data when they logoff?
or set one session userid and query the db on each page to get the rest of the data?
this is on a pretty weak server so i was concerned about using up memory.
i know there are many questions, any suggestions on the best path would be appreciated.
soshea