search

shotvibe / shotvibe-web

ShotVibe REST API webservice
1 stars 0 forks source link

Precision of timestamps in the database should be limited to millisecond #95

Open benny-shotvibe opened 10 years ago

benny-shotvibe commented 10 years ago

The apps and the server are supposed to synchronize their state. Java, and also Objective C have precision for timestamps only up to the millisecond level, while PostgreSQL has microsecond precision. This leads to obscure bugs.

The best solution is to configure the server so that all timestamps only have millisecond precision

benny-shotvibe commented 10 years ago

I made an initial start on this in #94 It adds a new custom DateTime field that stores only millisecond precision.

Not that the tests pass when setting SOUTH_TESTS_MIGRATE=False

If it is decided that this is the best approach, then what is left to be done is to set up south migrations to convert all the DateTime fields in the app to use it.