MySQL touch column with milliseconds precision


In one app I’m working on we’re using a MySQL 5.6 database and we’re using a belongs_to association with the touch option pointing to a datetime column on other entity.

But we noticed that we need more precision so we could invalidate properly a cache key based on that column.

I was thinking on a feature request so we can use an integer column instead a datetime column (this MySQL doesn’t store millisecond precision) to be touched, we’ll store in that column the current time with millisecond precision.

Would the core team consider this feature request?

That’s weird - MySQL 5.6 does support millisecond precision for date/time fields, according to the docs? You have to use the right format on your column definitions though.