Unless someone wants to suggest a way to make an index which causally sorts to whole DB, removing published-at timestamps is not an option. Restoring your DB, or syncing for the first time would be a nightmare otherwise
Re: format, Piet and I have started using ISOStrings for timestamps in scuttle-poll :
> new Date().toISOString()
'2018-06-09T02:03:18.707Z'
What we've noticed so far:
- a human can read them
- they can still be queried against because ISO time stamps are ordered Large >> Small !
- bytewise / charwise comparison which the flumeview level uses works