Alternative implementation of DateTime column for MySQL.
MySQL, unlike for instance, PostgreSQL, doesn’t support datetime columns with a sub-second granularity. This means that it is not possible to distinguish between two datetimes that were generated in the same second.
This can however be very useful. This package defines a new field type for SQLAlchemy that should be a drop-in replacement for the standard SQLAlchemy DateTime. It stores its information in a Numeric column to enable sub-second granularity.
It’s probably also not properly timezone aware.
To use it in a SQLAlchemy table definition as a column type, import it instead of SQLAlchemy’s version:
>>> from sa_mysql_dt import DateTime
- Nothing changed yet.
- Bugfix release; somehow CHANGES.txt wasn’t included.
- Initial public release.