Skip to main content
Help us improve PyPI by participating in user testing. All experience levels needed!

JSAM (JSON Storage Access Methods) is a "NoSQL" Database for JSON objects.

Project description

JSAM’s basic operations are get, put and remove, with basic support for transactions via begin, commit and rollback. All stored objects are identified by an integer key.

A JSAM database is opened by supplying a URL to jsam.jsurl.parse() and calling the open() method on the returned object. The syntax of URL depends on the particular “access method”.

The following URL types currently exist:

* file:   directory plain text JSON files
* rcs:    directory plain text JSON files under RCS
* cvs:    directory plain text JSON files under CVS (not tested)
* svn:    directory plain text JSON files under SVN (not tested)
* sqlite: object trees stored in an SQLite3 database
* mysql:  object trees stored in a MySQL database (lightly tested)
* pgsql:  object trees stored in a PostgreSQL database (lightly tested)

Query methods include:

* Collections: a jQuery/Django-like method-chained interface
* XPath query language subset (only supported for SQL backends)
* P4J (E4X-like) query language (only supported for SQL backends)
    which allows construction of "xpath" queries in Python using
    method chaining and operator overload, bridging the lexical divide
    between code and query.
pydoc jsam.<URLTYPE>_jsam
gives information on the URL syntax for <URLTYPE>
pydoc jsam.jsam.JSAM
gives information on jsam object methods
pydoc jsam.xpath
gives information on XPath query syntax (SQL backends only)
pydoc jsam.p4j
gives information on P4J Python native query syntax


* uses Python 2.6+ supplied "json"; requires "simplejson" on Python 2.5
* file-based storage depends on POSIX file semantics
* requires "MySQLdb" for MySQL
* requires "psycopg2" for PostgreSQL

The name “JSAM” is a joke on IBM Mainframe O/S data “Access Methods” (BDAM, BSAM, VSAM, ISAM, QSAM, BPAM).

The obvious name ‘jsonstore’ was already taken by another package in the Python Package Index (PyPI).

The URL/URI syntax was cribbed from Django, which copied SQLAlchemy.

Project details

Release history Release notifications

This version
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
jsam-0.7.tar.gz (56.9 kB) Copy SHA256 hash SHA256 Source None Jan 6, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page