Skip to main content

SQL in Python __doc__-strings as an alternative to ORMs

Project description

SQL in F(unctions) Documentation Status Updates Snyk

SQL in Python __doc__-strings as an alternative to ORMs


  • 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


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


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.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlf-0.2.9.tar.gz (13.6 kB view hashes)

Uploaded source

Built Distribution

sqlf-0.2.9-py2.py3-none-any.whl (5.7 kB view hashes)

Uploaded py2 py3

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