Re: using postgresql for session

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: using postgresql for session
Дата
Msg-id 56155317.3030202@aklaver.com
обсуждение исходный текст
Ответ на using postgresql for session  ("john.tiger" <john.tigernassau@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Ramalingam, Sankarakumar"
Дата:
Сообщение: Re: postgres standby won't start
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to drop user if objects depend on it