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

From Adrian Klaver
Subject Re: using postgresql for session
Date
Msg-id 56155317.3030202@aklaver.com
Whole thread Raw
In response to using postgresql for session  ("john.tiger" <john.tigernassau@gmail.com>)
List pgsql-general
On 10/07/2015 08:58 AM, john.tiger 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 ?

That is how Django does it. It uses the django_session table.

  Maybe use some trigger if session changes?

That would seem to the tricky part, determining when a session changes.

   We are
> using python Bottle with psycopg2 (super simple, powerful combo) - are
> we missing something magical about session plugins ?

What sort of plugin are you talking about?

>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: "Ramalingam, Sankarakumar"
Date:
Subject: Re: postgres standby won't start
Next
From: Adrian Klaver
Date:
Subject: Re: How to drop user if objects depend on it