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!

NoSQL ORM for relational db backed by SQLAlchemy

Project Description

`nosql` is a schemaless ORM for relational db backed by SQLAlchemy.

It's ultermately an implementation of the schemaless ORM introduced by Bret Taylor.

No instruction is better than real code! Say you are building a `Flask` app.

import nosql
from app import db

class User(nosql.SchemalessModel):
engine = db.engine
indexes = (


user = User() = '' = 'Yixi Zhang'

# find returns a generator
>>> [ for user in User.find()]
['Yixi Zhang']

# find_one returns an instance, support any attribute
>>> User.find_one(email='').name
Yixi Zhang

# added_id & id is auto-generated

>>> user.added_id

# retrieve non-exist attr returns None
>>> user.idol

>>> user.delete()

>>> list(User.find())

Because `nosql` creates index tables, querying random attribute is fast.

Some todo's for index

* `index_updater` allows indexes to be added later on and schedule data pushing in the background.
* `sharding` on index.

Database Support
So far only tested `SQLite` and `PostgreSQL`

Do whatever you want. Hope you enjoy using it.

Release History

This version
History Node


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