sqlf

================== SQL in F(unctions)

.. image:: https://img.shields.io/pypi/v/sqlf.svg :target: https://pypi.python.org/pypi/sqlf

.. image:: https://img.shields.io/travis/digitalmensch/sqlf.svg :target: https://travis-ci.org/digitalmensch/sqlf

.. image:: https://readthedocs.org/projects/sqlf/badge/?version=latest :target: https://sqlf.readthedocs.io/en/latest/?badge=latest :alt: Documentation Status

.. image:: https://pyup.io/repos/github/digitalmensch/sqlf/shield.svg :target: https://pyup.io/repos/github/digitalmensch/sqlf/ :alt: Updates

.. image:: https://snyk.io/test/github/digitalmensch/sqlf/badge.svg :target: https://snyk.io/test/github/digitalmensch/sqlf :alt: Snyk

.. image:: https://api.codacy.com/project/badge/Grade/391c7b2d4f0143cf9edf62f7c0ec38c0 :target: https://www.codacy.com/app/betabrain/sqlf

SQL in Python doc-strings as an alternative to ORMs

• Free software: MIT license
• Documentation: https://sqlf.readthedocs.io.

Features

• Access to in-memory and/or file-backed databases (Sqlite3)
• Lightweight, ORM-less abstraction
• Support for Sqlite3's UDFs (user-defined functions)
• Convenient library of UDFs

Credits

This package was created with Cookiecutter_ and the audreyr/cookiecutter-pypackage_ project template.

.. _Cookiecutter: https://github.com/audreyr/cookiecutter .. _audreyr/cookiecutter-pypackage: https://github.com/audreyr/cookiecutter-pypackage

======= History

0.2.9 (2018-04-11)

• Add support for aggregate UDFs
• Extend cbor support
• Refactor UDF library
• Rename sql -> sqlf
• Rewrite and extend tests
• Add UDF b91enc, b91dec
• Drop support for Python 3.5
• Add as_type

0.2.8 (2018-04-10)

• Add single_row decorator
• Fix naming of match UDF to similar
• Add UDF sha3
• Add UDF nounce
• Add UDF hex
• Satisfy linter

0.2.7 (2018-04-03)

• Update docs
• Remove old sqlfunc code
• Add UDF cbor, uncbor
• Add helper to list history

0.2.6 (2018-04-03)

• Add UDF number
• Disable support for Python 3.4 (Travis CI)
• Add dependency typeguard
• Add UDF match

0.2.2 (2018-03-31)

• Automatic deployment to PyPI.

0.2.1 (2018-03-31)

• Various fixes to the repo.

0.2.0 (2018-03-31)

• Moved project to the cookiecutter-pypackage template.
• Disabled support for Python 2.7.