expires_at is stored as a database datetime column
- Linguagem predominante
- Ruby
- Estrelas
- 700
- Forks
- 29
- Métricas de merge de PRs
- Nenhum PR com merge em 30d
Descrição
### Context
During the DST to standard time change, when the SQL server is running in a local time zone, records cannot be found when `expires_at` is set to 1 hour.
Given a PST time and a fallback to standard time at 2 AM, 1 hour from 1 AM, is going to be still 1 AM. The date s converted to the same date that was entered and few seconds after the record cannot be found again.
The `expires_at` column should be timezone agnostic, possible solution would be to store it as an integer (epoch time),
Guia de contribuição
Direção de pesquisa
Start at the model or schema definition for expires_at and ActiveRecord's datetime conversion, then reproduce the DST fallback with the SQL server in a local timezone. Done means expiration remains findable across the fallback, with timezone-agnostic storage and regression coverage agreed.
Escrita pelo modelo de indexação a partir do texto da issue.
Avaliação
- Stack de tecnologia
- rails, ruby
- Domínio
- database
- Tipo de issue
- Bug
- Dificuldade
- 4/5
- Tempo estimado
- 3-5 dias
- Status de atividade
- Estagnada
- Clareza
- Razoavelmente clara
- Facilidade para iniciantes
- 30/100