Re: using postgresql for session - Mailing list pgsql-general

From Bill Moran
Subject Re: using postgresql for session
Date
Msg-id 20151007125318.ec1301e1400c4f32a4900e6c@potentialtech.com
Whole thread Raw
In response to using postgresql for session  ("john.tiger" <john.tigernassau@gmail.com>)
Responses Re: using postgresql for session  (Rob Sargent <robjsargent@gmail.com>)
List pgsql-general
On Wed, 7 Oct 2015 09:58:04 -0600
"john.tiger" <john.tigernassau@gmail.com> wrote:

> has anyone used postgres jsonb for holding session ?  Since server side
> session is really just a piece of data, why bother with special
> "session" plugins and just use postgres to hold the data and retrieve it
> with psycopg2 ?  Maybe use some trigger if session changes?    We are
> using python Bottle with psycopg2 (super simple, powerful combo) - are
> we missing something magical about session plugins ?

Nothing that I'm aware of. I've worked on large projects that keep the
session data in a Postgres table with great success.

--
Bill Moran


pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Issues with german locale on CentOS 5,6,7
Next
From: "Ramalingam, Sankarakumar"
Date:
Subject: Re: postgres standby won't start