Re: using postgresql for session

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: using postgresql for session
Date: 2015-10-07 18:12:48
Message-ID: 561560A0.8070507@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/07/2015 10:53 AM, Bill Moran wrote:
> On Wed, 7 Oct 2015 09:58:04 -0600
> "john.tiger" <john(dot)tigernassau(at)gmail(dot)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.
>
Previous job gave up on mongo and switched to postgres since it was
faster, more reliable.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2015-10-07 18:52:00 Re: How to drop user if objects depend on it
Previous Message Andrus 2015-10-07 18:11:55 Re: How to drop user if objects depend on it