Skip to main content

A simple HTTP accessible database for IoT projects

Project description

BlanketDB

https://img.shields.io/pypi/v/blanketdb.svg https://img.shields.io/travis/luphord/blanketdb.svg Documentation Status

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.

History

0.3.1 (2019-03-06)

  • Improved clarity with default values

0.3 (2019-03-06)

  • Type annotations for BlanketDB
  • Python 3.4 is not supported anymore (as it does not know type annotations)

0.2.2 (2019-01-31)

  • setuptools entrypoint for cli
  • quickstart documentation
  • added logo

0.2.1 (2019-01-24)

  • fix tag confusion

0.2.0 (2019-01-24)

  • Added CLI for starting BlanketDB with wsgiref.simple_server
  • Tests for BlanketDB Web API using webtest
  • Added documentation for usage and Web API

0.1.0 (2019-01-18)

  • First release on PyPI.

Project details


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
blanketdb-0.3.1-py2.py3-none-any.whl (12.6 kB) Copy SHA256 hash SHA256 Wheel py2.py3
blanketdb-0.3.1.tar.gz (40.1 kB) Copy SHA256 hash SHA256 Source None

Supported by

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