This issue tracker has been migrated to GitHub, and is currently read-only.
For more information, see the GitHub FAQs in the Python's Developer Guide.

classification
Title: dbm.sqlite proof of concept
Type: enhancement Stage: needs patch
Components: Library (Lib) Versions: Python 3.4
process
Status: open Resolution:
Dependencies: Superseder:
Assigned To: Nosy List: doko, eric.araujo, erlendaasland, erno, flox, ghaering, gregburd, jcea, pitrou, rhettinger, rute
Priority: low Keywords: patch

Created on 2008-09-04 23:57 by skip.montanaro, last changed 2022-04-11 14:56 by admin.

Files
File name Uploaded Description Edit
sq_dict.py josiahcarlson, 2008-09-25 16:27 an alternate sqlite dbm-like interface v.5
dbsqlite.py rhettinger, 2009-02-03 23:11 Fixed __len__
dbdict.py rhettinger, 2009-02-04 20:18 Non-synchronous DB based on a dict subclass.
Messages (51)
msg72556 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-04 23:57
Based on recent discussions about ridding Python of bsddb I decided to
see how hard it would be to implement a barebones dbm.sqlite module.
Turns out, not very hard.

No docs.  No test cases.  Caveat emptor.  But I think it can serve as
at least a proof of concept, maybe as the basis for a new module in
3.1.
msg72565 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 04:44
Attaching corrected module.
msg72566 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 04:45
Attaching test cases based on dumbdbm tests.
msg72567 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 04:54
Another slight revision to the module.
msg72568 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 04:55
Trivial doc diffs against 3.0b3 doc.
msg72569 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 05:00
Another tweak - add values()
msg72570 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 05:02
Updated test cases
msg72587 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2008-09-05 12:01
It would be more efficient to base keys() on iterkeys() than the
reverse, IMO.
Other than that, why not open a branch or at least upload full-fledged
patch files? :)
msg72595 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-05 14:39
Antoine> It would be more efficient to base keys() on iterkeys() than the
    Antoine> reverse, IMO.

True.  I was just modifying the dumbdbm implementation.

    Antoine> Other than that, why not open a branch or at least upload
    Antoine> full-fledged patch files? :)

Well, I only intended to create the initial proof of concept, but then last
night I couldn't sleep so I cobbled the test module and docs from the
existing stuff ... ;-)

When I get a couple minutes free I'll try and condense it into a more
suitable form.  Probably not until the weekend though.

Skip
msg72661 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-06 02:55
OK, I made a sandbox project out of it:

svn+ssh://pythondev@svn.python.org/sandbox/trunk/dbm_sqlite

Hack away!
msg72677 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2008-09-06 18:06
I would like to see something like this go into 3.0 so that shelves
don't become useless for Windows users.
msg72719 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-06 22:43
Here's an alternate version with most of bsddb's interface intact.
msg72725 - (view) Author: Gregory P. Smith (gregory.p.smith) * (Python committer) Date: 2008-09-07 00:54
sq_dict review:

have sqlite quote/escape self._mtn before using it with a python %s
substitution.  or pass it into the sql query function as a positional ?
parameter like you do for keys and values.  (avoid sql injection)

raise a TypeError rather than a ValueError when you don't like the key
or value type.

also, to test the type, isinstance(val, str) is better than using type(val).
msg72729 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-07 03:34
I tried passing the db name as a parameter with '?', it doesn't always 
work.  Also, there shouldn't be any SQL injection issues here unless 
someone designed their system wrong (if a third party is allowed to pass 
the name of a db table into the open/create function, then they can do 
much worse than mangle or hide data in a sqlite database).

With regards to isinstance being better than type; it's only better if 
you want to support subclasses.  When writing the module, I had no 
interest in supporting subclasses (though supporting both str and buffer 
in 2.x, and bytes and memoryview in 3.x seems reasonable).
msg73012 - (view) Author: Gerhard Häring (ghaering) * (Python committer) Date: 2008-09-11 10:37
I like Skip's version better, because it's closer to the dbm
"specification" instead of trying to mimic bsddb (first, last, etc.).
I'd like to keep such things out.

I've made a few changes to the sandbox project which I will check in
later today. The most important change is support for a "fast mode",
which doesn't commit changes until you call the synch() method. synch()
is also called on close().

Perhaps we should do automatic commits every n (like 1000) changes, too?

What's all this ORDER BY in both your implementations about? The dbm
"spec" says nothing about keys being ordered AFAIC. Can we get rid of these?
msg73013 - (view) Author: Gerhard Häring (ghaering) * (Python committer) Date: 2008-09-11 10:42
One question about Josiah's _check_value(). SQLite is less crippled than
other simplistic databases and also supports integers, reals and blobs
in addition to strings.

Shouldn't we make this accessible to users? Or is compatibility with
other dbm implementations more important?
msg73018 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-11 12:45
Gerhard> What's all this ORDER BY in both your implementations about?
    Gerhard> The dbm "spec" says nothing about keys being ordered AFAIC. Can
    Gerhard> we get rid of these?

I'd like to guarantee that zip(db.keys(), db.values() == db.items().

Skip
msg73020 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2008-09-11 13:10
Le jeudi 11 septembre 2008 à 12:46 +0000, Skip Montanaro a écrit :
> Gerhard> What's all this ORDER BY in both your implementations about?
>     Gerhard> The dbm "spec" says nothing about keys being ordered AFAIC. Can
>     Gerhard> we get rid of these?
> 
> I'd like to guarantee that zip(db.keys(), db.values() == db.items().

It doesn't sound very useful, and it may hurt performance on big tables.
msg73025 - (view) Author: Gerhard Häring (ghaering) * (Python committer) Date: 2008-09-11 13:41
> I'd like to guarantee that zip(db.keys(), db.values() == db.items().

Ok. If that isn't guaranteed elsewhere just drop it here?

FWIW that will also work without the ORDER BY, because you're getting
the rows back in the same ORDER. Something cheaper would also be "ORDER
BY ROWID". I still propose to just do without the ORDER BY.
msg73026 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-11 13:46
>> I'd like to guarantee that zip(db.keys(), db.values() == db.items().

    Antoine> It doesn't sound very useful, and it may hurt performance on
    Antoine> big tables.

Actually, I think Python guarantees (for dicts at least - other mappings
should probably follow suit) that if you call keys() then call values()
without making any changes to the dict that their orders match, e.g., that

    zip(d.keys(), d.values()) == d.items()

Skip
msg73027 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-11 13:49
Gerhard> FWIW that will also work without the ORDER BY, because you're
    Gerhard> getting the rows back in the same ORDER. Something cheaper
    Gerhard> would also be "ORDER BY ROWID". I still propose to just do
    Gerhard> without the ORDER BY.

As long as SQLite guarantees that the ordering is identical, then sure, dump
the ORDER BY clause.

Skip
msg73028 - (view) Author: Gerhard Häring (ghaering) * (Python committer) Date: 2008-09-11 13:53
Skip Montanaro wrote:
> Skip Montanaro <skip@pobox.com> added the comment:
> 
> Gerhard> FWIW that will also work without the ORDER BY, because you're
>     Gerhard> getting the rows back in the same ORDER. Something cheaper
>     Gerhard> would also be "ORDER BY ROWID". I still propose to just do
>     Gerhard> without the ORDER BY.
> 
> As long as SQLite guarantees that the ordering is identical, then sure, dump
> the ORDER BY clause.

It doesn't guarantee it, but the implementation behaves like this.

-- Gerhard
msg73032 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2008-09-11 14:16
Le jeudi 11 septembre 2008 à 13:48 +0000, Skip Montanaro a écrit :
> Actually, I think Python guarantees (for dicts at least - other mappings
> should probably follow suit) that if you call keys() then call values()
> without making any changes to the dict that their orders match, e.g., that
> 
>     zip(d.keys(), d.values()) == d.items()

Perhaps. I've never written any code that relies this, though, and it
doesn't sound like an useful guarantee since you can just use the
items() method anyway. It probably dates back to an era when list
comprehensions didn't exist, and extracting keys or values from the
items list required several lines of code and costly method calls.

Also, the point is that Python dicts can make that guarantee without
being any slower. It may not be the same for an RDBMS backend. Why?
Because, depending on the backend, index and data can be stored in
separate areas with different storage layouts (e.g. keys are in a B tree
while values are just dumped sequentially). If you only ask for
unordered keys, they will be read in optimal (sequential) index order,
and if you only ask for unordered values, they will be read in optimal
(sequential) data order, which is not the same. This is true for e.g.
MySQL.

(also, IMO this discussion proves that the module shouldn't be included
in Python 3.0. It's too young, its API hasn't even settled down)
msg73034 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2008-09-11 14:33
I might add that calling keys() then values() is suboptimal, because it
will issue two SQL queries while calling items() will issue just one.
msg73046 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-11 18:25
> I like Skip's version better, because it's closer to the dbm
> "specification" instead of trying to mimic bsddb (first, last, etc.).
> I'd like to keep such things out.

dbm.sqlite is meant as a potential replacement of dbm.bsddb.  Since 
people do use the extra methods (.first(), .last(), etc.), not having 
them could lead to breakage.

Separating them out into a subclass (regular open doesn't have it, but 
btopen does), along with all of the other order guarantees (the ORDER BY 
clauses in the SQL statements), could keep it fast for people who don't 
care about ordering, and keep it consistent for those who do care about 
ordering.

Attached you will find an updated version.
msg73053 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-11 19:48
>> As long as SQLite guarantees that the ordering is identical, then
    >> sure, dump the ORDER BY clause.

    Gerhard> It doesn't guarantee it, but the implementation behaves like
    Gerhard> this.

If the behavior isn't guaranteed, I think you need to retain ORDER BY.

Skip
msg73054 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-11 20:12
Antoine> I might add that calling keys() then values() is suboptimal,
    Antoine> because it will issue two SQL queries while calling items()
    Antoine> will issue just one.

Well, sure, but heaven only knows what an application programmer will do...

S
msg73067 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2008-09-11 23:30
> Well, sure, but heaven only knows what an application programmer will do...

If the docs clearly explain that there is no guarantee, we don't need
heaven.
I would find it strange to potentially ruin performance just for a
guarantee which has no useful purpose.
msg73068 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-11 23:59
> I would find it strange to potentially ruin performance just for a
> guarantee which has no useful purpose.

Benchmarks to prove or disprove performance changes?  Subclasses to 
offer different order by semantics (see the version I uploaded for an 
example)?  Consistent behavior wrt dictionaries?
msg73070 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2008-09-12 00:25
> Benchmarks to prove or disprove performance changes?

Agreed, benchmarks should be run.

> Subclasses to 
> offer different order by semantics (see the version I uploaded for an
> example)?

If you like, but "ordering semantics" is something which is just as
easily done in Python, so I don't understand the point of integrating it
in the dbm layer...

> Consistent behavior wrt dictionaries?

It sounds like an example of foolish consistency to me. The performance
characteristics are certainly too different to consider dbm.anything a
transparent replacement for standard dicts. And dbm.sqlite only accepts
strings, not the wide range of datatypes that dicts accept as keys and
values... so, given the big picture, I don't see why you care about such
a mostly pointless detail.
msg73072 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-12 01:28
>> Well, sure, but heaven only knows what an application programmer will
    >> do...

    Antoine> If the docs clearly explain that there is no guarantee, we
    Antoine> don't need heaven.  I would find it strange to potentially ruin
    Antoine> performance just for a guarantee which has no useful purpose.

From <http://docs.python.org/lib/typesmapping.html>:

    If items(), keys(), values(), iteritems(), iterkeys(), and itervalues()
    are called with no intervening modifications to the dictionary, the
    lists will directly correspond. This allows the creation of (value, key)
    pairs using zip(): "pairs = zip(a.values(), a.keys())". The same
    relationship holds for the iterkeys() and itervalues() methods: "pairs =
    zip(a.itervalues(), a.iterkeys())" provides the same value for
    pairs. Another way to create the same list is "pairs = [(v, k) for (k,
    v) in a.iteritems()]".

While the emphasis is on dictionaries, it seems to me that page describes
the notation and properties of mappings in general, not specifically
dictionaries.

I think it might be worthwhile to get a verdict from Guido on this one.

Skip
msg73074 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-12 01:33
> If you like, but "ordering semantics" is something which is just as
> easily done in Python, so I don't understand the point of integrating
> it in the dbm layer...

Actually, the db layer is *exactly* where it should be implemented, 
especially when an index can already exist (as is the case with the 
implementation I provided), especially when the total size of keys can 
easily overflow memory.  Implementing ordering semantics in Python would 
be a waste of what the db is good at: storing and ordering data.

> It sounds like an example of foolish consistency to me. The 
> performance characteristics are certainly too different to consider 
> dbm.anything a transparent replacement for standard dicts. And 
> dbm.sqlite only accepts strings, not the wide range of datatypes that 
> dicts accept as keys and values... so, given the big picture, I don't 
> see why you care about such a mostly pointless detail.

No one here has ever claimed that dbm should be a replacement for dicts, 
even if shelve attempts to do so.  This module should provide a shelve 
interface that mirrors bsddb's interface.  One of the things that was 
offered earlier was that since sqlite can store ints, floats, etc., as 
keys, maybe we should offer that ability.  I think that the base should 
act like a regular dbm object.  I think that a key-ordering should be 
available.  And if we are to offer arbitrary keys (ints, floats, unicode 
strings, byte strings, or None), it should be unordered like the base 
version.

I've uploaded a new copy of sq_dict that offers unordered shelve and 
arbitrary keys in a shelve db.
msg73077 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-12 05:43
Here's a version with views from Python 3.0 for keys, values, and items 
:) .  I know that no one hear likes my particular implementation (though 
it offers more or less the full interface), but the Keys, Values, and 
Items classes in the following version are quite generic (they only 
require that the base class implement __iter__, _itervalues, and 
_iteritems), and reasonably optimized.  They could probably be moved 
into the generic dbm stuff and used by everyone.
msg73080 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2008-09-12 10:48
Josiah> I know that no one hear likes my particular implementation
    Josiah> (though it offers more or less the full interface)...

I think implementing as much of the bsddb interface as you can is fine.  I
agree people used first, next, last, etc and having them present is a good
idea.  My initial aim was to get a replacement for use with shelve.  Its
limitations shouldn't deter people from extending it (or the other dbm.*
modules) in other ways.

Even if all the modules aren't going to be widely cross-platform I see no
reason they can't strive to be more-or-less API-compatible.

Skip
msg73775 - (view) Author: Erno Kuusela (erno) Date: 2008-09-25 10:50
I'm looking for a bsddb-shelve replacement (because of we bsddb
corruption problems), and decided to give this a try. Don't overlook
the free locking you get from sqlite when evaluating this for inclusion!

A small bug:

>>> from sq_dict import shelve
>>> shelve('zz', 'c')[42] = 2
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "sq_dict.py", line 144, in __setitem__
    key = self._check_key(key)
  File "sq_dict.py", line 287, in _check_key
    (", ".join(i.__name__ for i in self._allowed_keys), type(key)))
NameError: global name 'self' is not defined
msg73800 - (view) Author: Josiah Carlson (josiahcarlson) * (Python triager) Date: 2008-09-25 16:27
Thank you for the report (fixed in the newly attached version) :) .
msg79050 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2009-01-04 12:36
Hopefully I'm not picking at a scab here.  I updated the dbm.sqlite
module in the sandbox.  It now orders by rowid instead of by key.
(I saw no performance penalty for the small table sizes I was using
to ordering.  I switched from ordering by key to ordering by rowid
based on Gerhard's comment.

I got a big performance boost on writes by only committing once every
100 calls to __setitem__.  I still commit when deleting keys and 
explicitly commit when closing.

The main performance bottleneck now appears to be keys() and iterkeys().
I don't see how to make them any simpler.  Oddly enough, it seems
that iterkeys() is slower than keys().  Maybe it's just lack of sleep
but I can't see why this is so.
msg80802 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2009-01-30 01:18
Am also working on a patch for this and would like to coordinate.  My
first draft is attached:
msg80803 - (view) Author: Jean-Paul Calderone (exarkun) * (Python committer) Date: 2009-01-30 01:37
Some comments on tmp_dev_shelver.py...

Regarding SQLhash.__init__, it would be better to avoid relying on the
"sqlite_master" table by using the CREATE TABLE IF NOT EXISTS form of
table creation.

Setting the isolation_level in __init__ will have essentially no effect
on this code because there is currently no transaction management in the
code.  However, the rest of the code also has almost no effect, because
there are no commits anywhere in SQLhash.  All the data is always lost
when the connection is closed.

Regarding the XXX in SQLhash.__len__, there is no faster way using
"sqlite_master".  There is basically just one way to make COUNT(*) fast.
 Keep track of the count in the database (update it on inserts and
deletes).  Then, use that instead of using COUNT(*).

Once there is some use of transactions, it will indeed be important, in
DBhash.__setitem__, to make sure the delete and the insert are in the
same transaction.  Actually, a different approach would be better,
though.  INSERT OR REPLACE INTO will let you replace a row's value with
one statement.  It's also faster, since the row only has to be found once.

Additionally, an index on the key column will assist performance
substantially for large data sets.
msg80808 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2009-01-30 03:06
Thanks for looking at this.  I'll do an update in the next few days.
msg80817 - (view) Author: Skip Montanaro (skip.montanaro) * (Python triager) Date: 2009-01-30 13:57
Unassigning myself.  I don't have time for this.  I've taken my sandbox
version about as far as I can, and the subject of this ticket has
gone a bit far afield from just adding a sqlite module to the dbm pkg.
msg81109 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2009-02-03 22:36
Here's an updated patch (it's also in the sandbox):

* Added a sync() method to support shelves.
* Removed commits on granular sets and gets.
* Optimized __len__ and __contains__.
msg81110 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2009-02-03 22:42
I think issuing 'SELECT MAX(ROWID)' to compute the length of the table
is not correct if some rows get deleted in the table.
I've found a thread about it here:
http://osdir.com/ml/db.sqlite.general/2004-03/msg00329.html
In that thread someone suggested caching the length in another table and
updating it through a trigger each time the main table is modified.
msg81113 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2009-02-03 23:11
That's a bummer.  Changing this method to __bool__ and then setting
__len__ back to "count(*)".
msg81155 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2009-02-04 20:18
FWIW, I put an alternative in the sandbox /dbm_sqlite/alt/dbdict.py and
am attaching a copy here.  The idea is to emulate gdbm's fast mode and
delay all writes until closing.  That lets us subclass from dict and get
high-speed lookups, sets, and deletions.  Freeing ourselves from an DB
also gets us a choice of ultra-portable file formats (json, csv, pickle,
eval).
msg81483 - (view) Author: Raymond Hettinger (rhettinger) * (Python committer) Date: 2009-02-09 20:12
Unassigning.  The code works but no one seems to be pushing for or
caring about inclusion in Py3.1.  

If commits are delayed, then you might as well adopt the dbdict.py
approach instead (reading the file in once at the beginning, operating
directly on a dict subclass, and atomically writing it out at the end).
msg85717 - (view) Author: Matthias Klose (doko) * (Python committer) Date: 2009-04-07 15:36
is there any chance for inclusion in 3.1?
msg95492 - (view) Author: Runar Tenfjord (rute) Date: 2009-11-19 16:56
By utilizing triggers on inserts and deletes it is possible to
keep track of the size and speed up __len__ by 10 x.

SQL:

CREATE TABLE IF NOT EXISTS info
   (key TEXT UNIQUE NOT NULL,
    value INTEGER NOT NULL);

INSERT OR IGNORE INTO info (key,value) VALUES ('size',0);

CREATE TABLE IF NOT EXISTS shelf
    (key TEXT UNIQUE NOT NULL,
     value TEXT NOT NULL);

CREATE TRIGGER IF NOT EXISTS insert_shelf
    AFTER INSERT ON shelf
    BEGIN
         UPDATE info SET value = value + 1 WHERE key = 'size';
    END;

CREATE TRIGGER IF NOT EXISTS delete_shelf
    AFTER DELETE ON shelf
    BEGIN
         UPDATE info SET value = value - 1 WHERE key = 'size';
    END;

On my laptop this increase the speed of 'len' about 10x

I have a slightly modified version of dbsqlite.py for
running on python 2.5 utilizing the triggers for 
keep track of the size:

http://dpaste.com/hold/122439/
msg95804 - (view) Author: Antoine Pitrou (pitrou) * (Python committer) Date: 2009-11-29 12:47
It would be nice to try to advance this at PyCon, or at another time.
msg97473 - (view) Author: Runar Tenfjord (rute) Date: 2010-01-09 21:58
Multi threading:

According to http://www.sqlite.org/cvstrac/wiki?p=MultiThreading
we need to keep a connection for each thread to support multi threaded
access to the database. 

I came across this when deploying an application in a multi threaded
environment. Solution is to keep the connection in the thread local-data.

Also note that a memory database is not shared between threads and
a hairy workaround with a separate working thread with queues for access
is needed. A memory database could perhaps be disallowed as the dbm is file only?

import threading

class SQLhash(collections.MutableMapping):
    def __init__(self, filename=':memory:', flags='r', mode=None):
        self.__filename = filename
        self.__local = threading.local()
        
        MAKE_SHELF = 'CREATE TABLE IF NOT EXISTS shelf (key TEXT PRIMARY KEY, value TEXT NOT NULL)'
        self.conn.execute(MAKE_SHELF)
        self.conn.commit()
    
    @property
    def conn(self):
        try:
            conn = self.__local.conn
        except AttributeError:
            conn = self.__local.conn = sqlite3.connect(self.__filename)
            self.conn.text_factory = bytes
            
        return conn
msg248835 - (view) Author: Gerhard Häring (ghaering) * (Python committer) Date: 2015-08-19 13:06
This wiki page is out of date. It appears that SQlite is now threadsafe by default: http://www.sqlite.org/threadsafe.html
History
Date User Action Args
2022-04-11 14:56:38adminsetgithub: 48033
2021-07-28 20:11:08erlendaaslandsetnosy: + erlendaasland
2019-05-02 04:30:18josiahcarlsonsetnosy: - josiahcarlson
2015-08-19 13:06:06ghaeringsetmessages: + msg248835
2012-07-21 13:36:28floxsetversions: + Python 3.4, - Python 3.3
2011-02-22 12:53:31ysj.raysetnosy: rhettinger, doko, jcea, ghaering, josiahcarlson, pitrou, erno, eric.araujo, gregburd, flox, rute
versions: + Python 3.3, - Python 3.2
2010-04-13 19:03:47eric.araujosetnosy: + eric.araujo
2010-03-21 18:23:49skip.montanarosetnosy: - skip.montanaro
2010-03-21 18:04:46gregory.p.smithsetnosy: - gregory.p.smith
2010-03-17 17:31:01pitrousettype: behavior -> enhancement
2010-03-17 11:38:35floxsetnosy: + flox
2010-03-17 11:16:59jceasetnosy: skip.montanaro, rhettinger, doko, gregory.p.smith, jcea, ghaering, josiahcarlson, pitrou, erno, gregburd, rute
2010-01-09 21:58:37rutesettype: enhancement -> behavior
messages: + msg97473
2009-11-29 12:47:18pitrousetmessages: + msg95804
2009-11-19 16:59:10pitrousetstage: needs patch
versions: + Python 3.2, - Python 3.1
2009-11-19 16:56:48rutesetnosy: + rute
messages: + msg95492
2009-04-07 15:36:31dokosetnosy: + doko
messages: + msg85717
2009-02-09 20:12:14rhettingersetassignee: rhettinger ->
messages: + msg81483
2009-02-04 20:29:15exarkunsetnosy: - exarkun
2009-02-04 20:18:55rhettingersetpriority: low
files: + dbdict.py
messages: + msg81155
2009-02-03 23:11:57rhettingersetfiles: - dbsqlite.py
2009-02-03 23:11:46rhettingersetfiles: + dbsqlite.py
messages: + msg81113
2009-02-03 22:42:21pitrousetmessages: + msg81110
2009-02-03 22:36:03rhettingersetfiles: + dbsqlite.py
messages: + msg81109
2009-02-03 22:32:50rhettingersetfiles: - dbsqlite.py
2009-02-03 22:32:44rhettingersetfiles: - tmp_dev_shelver.py
2009-01-30 18:25:44rhettingersetfiles: + dbsqlite.py
2009-01-30 16:31:23rhettingersetassignee: rhettinger
2009-01-30 13:57:39skip.montanarosetassignee: skip.montanaro -> (no value)
messages: + msg80817
2009-01-30 03:06:30rhettingersetmessages: + msg80808
2009-01-30 01:37:34exarkunsetnosy: + exarkun
messages: + msg80803
2009-01-30 01:18:32rhettingersetfiles: + tmp_dev_shelver.py
messages: + msg80802
2009-01-04 12:36:35skip.montanarosetmessages: + msg79050
2008-09-25 16:27:38josiahcarlsonsetfiles: + sq_dict.py
messages: + msg73800
2008-09-25 16:26:05josiahcarlsonsetfiles: - sq_dict.py
2008-09-25 10:50:13ernosetnosy: + erno
messages: + msg73775
2008-09-12 10:48:24skip.montanarosetmessages: + msg73080
2008-09-12 05:43:55josiahcarlsonsetfiles: + sq_dict.py
messages: + msg73077
2008-09-12 05:39:30josiahcarlsonsetfiles: - sq_dict.py
2008-09-12 01:34:12josiahcarlsonsetfiles: - sq_dict.py
2008-09-12 01:33:40josiahcarlsonsetfiles: + sq_dict.py
messages: + msg73074
2008-09-12 01:28:29skip.montanarosetmessages: + msg73072
2008-09-12 00:25:33pitrousetmessages: + msg73070
2008-09-11 23:59:49josiahcarlsonsetmessages: + msg73068
2008-09-11 23:30:28pitrousetmessages: + msg73067
2008-09-11 20:12:45skip.montanarosetmessages: + msg73054
2008-09-11 19:48:03skip.montanarosetmessages: + msg73053
2008-09-11 18:27:24josiahcarlsonsetfiles: - sq_dict.py
2008-09-11 18:26:00josiahcarlsonsetfiles: + sq_dict.py
messages: + msg73046
2008-09-11 14:33:44pitrousetmessages: + msg73034
2008-09-11 14:16:52pitrousetmessages: + msg73032
2008-09-11 13:53:03ghaeringsetmessages: + msg73028
2008-09-11 13:49:23skip.montanarosetmessages: + msg73027
2008-09-11 13:46:50skip.montanarosetmessages: + msg73026
2008-09-11 13:41:20ghaeringsetmessages: + msg73025
2008-09-11 13:10:22pitrousetmessages: + msg73020
2008-09-11 12:45:45skip.montanarosetmessages: + msg73018
2008-09-11 10:42:32ghaeringsetmessages: + msg73013
2008-09-11 10:37:45ghaeringsetnosy: + ghaering
messages: + msg73012
2008-09-07 03:34:22josiahcarlsonsetmessages: + msg72729
2008-09-07 00:54:45gregory.p.smithsetmessages: + msg72725
2008-09-06 22:43:16josiahcarlsonsetfiles: + sq_dict.py
nosy: + josiahcarlson
messages: + msg72719
2008-09-06 18:06:07rhettingersetnosy: + rhettinger
messages: + msg72677
2008-09-06 17:44:31gregory.p.smithsetnosy: + gregory.p.smith
2008-09-06 02:55:38skip.montanarosetfiles: - test_dbm_sqlite.py
2008-09-06 02:55:35skip.montanarosetfiles: - sqlite.py
2008-09-06 02:55:31skip.montanarosetfiles: - dbm.diff
2008-09-06 02:55:25skip.montanarosetassignee: skip.montanaro
messages: + msg72661
2008-09-05 16:29:54gregburdsetnosy: + gregburd
2008-09-05 14:40:18jceasetnosy: + jcea
2008-09-05 14:39:37skip.montanarosetmessages: + msg72595
2008-09-05 12:01:33pitrousetnosy: + pitrou
messages: + msg72587
2008-09-05 05:02:25skip.montanarosetfiles: - sqlite.py
2008-09-05 05:02:20skip.montanarosetfiles: - test_dbm_sqlite.py
2008-09-05 05:02:13skip.montanarosetfiles: + test_dbm_sqlite.py
messages: + msg72570
2008-09-05 05:00:53skip.montanarosetfiles: + sqlite.py
messages: + msg72569
2008-09-05 04:55:57skip.montanarosetfiles: + dbm.diff
messages: + msg72568
2008-09-05 04:54:47skip.montanarosetfiles: - sqlite.py
2008-09-05 04:54:41skip.montanarosetfiles: + sqlite.py
messages: + msg72567
2008-09-05 04:45:20skip.montanarosetfiles: + test_dbm_sqlite.py
messages: + msg72566
2008-09-05 04:44:37skip.montanarosetfiles: - sqlite.py
2008-09-05 04:44:28skip.montanarosetfiles: + sqlite.py
messages: + msg72565
2008-09-04 23:57:30skip.montanarocreate