Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Simple object-relational mapper for SQLite3, includes plugin for Bottle web framework

Project Description

Macaron is a small object-relational mapper (ORM) for SQLite on Python. It is distributed as a single file module which has no dependencies other than the Python Standard Library.

Macaron provides easy access way to SQLite database as standalone. And also it can work in Bottle web framework through the plugin mechanism.


>>> import macaron
>>> macaron.macaronage("members.db")
>>> team = Team.create(name="Houkago Tea Time")
>>> team.members.append(name="Ritsu", part="Dr")
<Member object 1>
>>> mio = team.members.append(name="Mio", part="Ba")
>>> print mio
<Member 'Mio : Ba'>
>>> for member in team.members: print member
<Member 'Ritsu : Dr'>
<Member 'Mio : Ba'>
>>> macaron.bake()
>>> macaron.cleanup()

Release History

This version
History Node


History Node


History Node


History Node


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
(15.2 kB) Copy SHA256 Hash SHA256
Source None Feb 28, 2012

Supported By

Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Google Google Cloud Servers