Server side session management using the SQLite (per session) database

Поиск
Список
Период
Сортировка
От Ashesh Vashi
Тема Server side session management using the SQLite (per session) database
Дата
Msg-id CAG7mmowDB7Nb0tp5Bj_X1kZDvCFOBtUHi_cK=BhC_U74puEw3A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Server side session management using the SQLite (per session) database  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-hackers
Hi Dave/team,

As discussed, I have implemented the server side session management using the SQLite database.

Implementation:
* It creates/reuses the sqlite database per session.
* Stores the key (as text)/value (as blob) in the sqlite database.
* Needs to provide the session directory, where you want to store those sessions. If this directory does not exist, it creates the directory with 700 permission. (Default: <USER_HOME>/.pgadmin/sessions directory.)
* Also - sets default value for the log file to be stored in the '<USER_HOME>/.pgadmin' directory. This will allow us to keep separate configuration per user on any operation system, when running through runtime.

This implementation uses sqlite as session storage, it may affect because of explicit file system I/O operation. Though - performance should not be a big issue, as we're not targeting to support very huge parallel sessions.


Murtuza,

I have tested it on Python 2.7.
Can you please take a look at it, and do the needful to make it work on Python 3.x?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi

Вложения

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Khushboo Vashi
Дата:
Сообщение: Re: pgAdmin4 PATCH: Domain Module
Следующее
От: Ashesh Vashi
Дата:
Сообщение: pgAdmin 4 commit: Updated the jQuery-contextMenu to 1.9.2 (latest stabl