List-like wrapper for SQLite
Project description
SQList is like shelve but for lists. It serializes data with pickle and puts into SQLite database.
Usage
SQLite object behaves mostly like casual Python list. For example you can create SQList from list.
>>> import sqlist >>> values = sqlist.SQList([1, 2, 3]) >>> values sqlist.SQList([1, 2, 3])
You can get item from list by index.
>>> values[0] 1 >>> values[-1] 3
Slices are available too.
>>> values[0:2] [1, 2]
You can easily append item to SQList and pop them from it.
>>> values.append(23) >>> values sqlist.SQList([1, 2, 3, 23]) >>> valuea.pop(0) 1 >>> values sqlist.SQList([2, 3, 23])
Unfortunately inserting is not available yet but planned for future versions.
By the way, you can also sort SQList just in place, but be careful, this sorting a bit differs from usual list sorting. If you specify key parameter, it will be used for sorting, but if you leave it None, sorting order will be restored to order of appending items to SQList.
>>> values.sort(key=lambda x: 1 / x) >>> values sqlist.SQList([23, 3, 2]) >>> values.sort() >>> values sqlist.SQList([2, 3, 23])
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.