Re: [GENERAL] using postgresql for session

2015-10-15 Thread Jim Nasby
On 10/14/15 8:57 PM, Tiger Nassau wrote: maybe we will just use beaker with our bottle framework - thought it was duplicative to have redis since we have postgres and lookup speed should be trivial since session only has a couple of small fields like account id and role The problem with

Re: [GENERAL] using postgresql for session

2015-10-14 Thread Jonathan Vanasco
On Oct 7, 2015, at 11: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 > ? Maybe use

Re: [GENERAL] using postgresql for session

2015-10-14 Thread Tiger Nassau
maybe we will just use beaker with our bottle framework - thought it was duplicative to have redis since we have postgres and lookup speed should be  trivial since session only has a couple of small fields like account id and role Sent from Type Mail On Oct 14, 2015, 12:16, at 12:16,

[GENERAL] using postgresql for session

2015-10-07 Thread john.tiger
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

Re: [GENERAL] using postgresql for session

2015-10-07 Thread Rob Sargent
On 10/07/2015 10:53 AM, Bill Moran wrote: On Wed, 7 Oct 2015 09:58:04 -0600 "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

Re: [GENERAL] using postgresql for session

2015-10-07 Thread Bill Moran
On Wed, 7 Oct 2015 09:58:04 -0600 "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

Re: [GENERAL] using postgresql for session

2015-10-07 Thread Adrian Klaver
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.