Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

htables is a database library for storing mapping objects in a relational database.

Project Description

HTables is a library for storing string-to-string mapping objects in a database. Two backends are supported so far: ~htables.PostgresqlDB and ~htables.SqliteDB.

>>> import htables
>>> db = htables.SqliteDB(':memory:')
>>> with db.session() as dbs:
...     dbs['tweet'].create_table()
...     dbs['tweet'].new(text="Hello world!")
...     dbs.commit()

Tables are collections of Rows. A row is basically a dictionary with an extra id property. Its keys and values must be strings.

>>> with db.session() as dbs:
...     tweet = dbs['tweet'].find_first()
...     tweet['author'] = '1337 h4x0r'
...     dbs.commit()

There are many ways of retrieving rows. The following all fetch the same record:

>>> with db.session() as dbs:
...     tweet_table = dbs['tweet']
...     [tweet] = list(tweet_table.find())
...     [tweet] = list(tweet_table.find(author='1337 h4x0r'))
...     tweet = tweet_table.find_first()
...     tweet = tweet_table.find_single()
...     tweet = tweet_table.get(1)

Release History

This version
History Node


History Node


History Node


History Node


History Node


Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, Size & Hash SHA256 Hash Help File Type Python Version Upload Date
(8.9 kB) Copy SHA256 Hash SHA256
Source None Sep 10, 2012

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Google Google Cloud Servers DreamHost DreamHost Log Hosting