pgAdmin 4 commit: Do not use the sqlite for session handling, as the ol

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin 4 commit: Do not use the sqlite for session handling, as the ol
Date: 2016-07-08 11:27:55
Message-ID: E1bLTwp-0003FM-Km@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

Do not use the sqlite for session handling, as the old implementation is
optimized to work from multiple threads. It has too many frequent
transaction from multiple threads, and that tends to result into the
'database is locked' error of sqlite.

With the new implemenation, we're using the caching mechanism, which
keep the data in the memory all the time, and saves it on request
completion, and loads it only for the first time. Also, it will storage
the data using pickle, which will be faster than accessing sqlite.

Fixes #1329

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=61698b7b4db3eea39a034c7ff0f90d0c710ffcb8

Modified Files
--------------
requirements_py2.txt | 1 +
web/pgadmin/__init__.py | 4 +-
web/pgadmin/utils/session.py | 424 +++++++++++++++++++++++--------------------
3 files changed, 234 insertions(+), 195 deletions(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Navnath Gadakh 2016-07-08 13:30:33 Fwd: pgAdmin IV : Unittest modular patch
Previous Message Priyanka Shendge 2016-07-08 09:38:14 Re: pgAdmin IV API test cases patch