BlanketDB

https://img.shields.io/pypi/v/blanketdb.svg https://travis-ci.com/luphord/blanketdb.svg Documentation Status Docker Automated build

BlanketDB is a very simple database written in Python based on SQLite. It is intended for small IoT projects where you need a quick way to collect and store data from sensors and other devices. You communicate to BlanketDB using HTTP GET / POST / DELETE requests. Request and response bodies are usually JSON, but you can also POST HTML forms directly to BlanketDB. There is no schema in the database, you simply store objects in buckets.

BlanketDB is free software provided under a MIT license. Documentation is available at https://blanketdb.readthedocs.io.

Why is it called BlanketDB? Well, a blanket is simple, lightweight, portable and keeps you warm. But if you really want to relax, you’ll need a couch.

Features

  • GET / POST / DELETE requests to communicate with BlanketDB
  • JSON requests / responses
  • HTML forms can POST directly to BlanketDB
  • Data stored in buckets
  • Schemaless
  • Query using various parameters to a HTTP GET request
  • Data is stored in a single file on the file system which is a SQLite database
  • BlanketDB is a single Python file without any dependencies besides the standard library
  • No sequrity whatsoever; BlanketDB is completely open to readers and writers (use with care!)

Quickstart

To install BlanketDB, you’ll need a Python (>=3.4) installation with pip:

$ pip install blanketdb

To use BlanketDB as a standalone database (and communicate over HTTP), enter the following command:

$ python3 -m blanketdb -i localhost -p 8080 -f /path/to/db.sqlite

BlanketDB will now serve its web interface at http://localhost:8080. You can open this page in your browser to check if everything works.

To use BlanketDB in a Python project, enter the following code:

from blanketdb import BlanketDB
db = BlanketDB('/path/to/db.sqlite')

# you can now use db using its Python API
db.store_dict(x='test')['id']
for entry in db:
    print(entry)

# db is alse a wsgi conforming callable
# you can use it e.g. with the wsgi reference implementation
from wsgiref.simple_server import make_server
httpd = make_server('localhost', 8080, db)
httpd.serve_forever()

Detailed documentation is available at https://blanketdb.readthedocs.io.

Credits

Main author and project maintainer is luphord.

This package was prepared with Cookiecutter and the audreyr/cookiecutter-pypackage project template.