Skip to main content

butterdb is a Python ORM for Google Drive Spreadsheets.

Project description


| Master: |Build Status|
| Develop: |Build Status|


`butterdb on PyPi`_

butterdb is a Python ORM for Google Drive Spreadsheets. Never use this for anything important, it's an experiment.


``pip install butterdb``



import butterdb

database = butterdb.Database("MyDatabaseSheet", "", "password")

class User(butterdb.Model):
def __init__(self, name, password): = self.field(name)
self.password = self.field(password)

barry = User("Barry", "hunter2") = "Steve"

users = User.get_instances()


What works?
* Store data in Google Spreadsheets (the cloud!!!)
* Models from classes
* Fields as attributes. decimals, ints and strings only (as far as I know)
* Commits
* Mocked unit tests, mock database
* Arbitrary cell execution with `=blah()` (free stored procedures?)
* Auto backup/bad patch control

What's missing?
* Spreadsheets must exist before connecting
* References
* Collections
* Customizable fields
* Customizable table size (arbitrarily hardcoded)

Comments, concerns, issues and pull requests welcomed. Reddit /u/Widdershiny or email me at


MIT License. See LICENSE file for full text.

.. _Documentation:
.. _butterdb on PyPi:

.. |Build Status| image::
.. |Build Status| image::


0.1.0 7/3/14

* First release on PyPI.

0.1.1 7/3/14

* Converted readme to rst from md

0.1.2 7/3/14

* Included HISTORY.rst in package build

0.1.3 7/3/14

* Model.field no longer requires name to be specified. Attribute name will be used if none is provided.
* Model no longer needs to have id as a keyword argument, or call super in init
* Tests now use pep8 asserts

Project details

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page