title: How should I handle decimal in SQLalchemy & SQLite
body: <p>SQLalchemy gives me the following warning when I use a Numeric column with an SQLite database engine.</p>
  <blockquote>
  <p>SAWarning: Dialect sqlite+pysqlite does <em>not</em> support Decimal objects natively</p>
  </blockquote>
  <p>I'm trying to figure out the best way to have <code>pkgPrice = Column(Numeric(12,2))</code> in SQLalchemy while still using SQLite.</p>
  <p>This question [1] <a href="https://stackoverflow.com/questions/6319409/how-to-convert-python-decimal-to-sqlite-numeric">How to convert Python decimal to SQLite numeric?</a> shows a way to use <code>sqlite3.register_adapter(D, adapt_decimal)</code> to have SQLite receive and return Decimal, but store Strings, but I don't know how to dig into the SQLAlchemy core to do this yet. Type Decorators look like the right approach but I don't grok them yet.</p>
  <p>Does anyone have a SQLAlchemy Type Decorator Recipe that will have Numeric or Decimal numbers in the SQLAlchemy model, but store them as strings in SQLite?</p>