ash-project / ash-project/ash_postgres

Switch to using `timestamp with time zone` by default

Open
#264 0 comments 10 reactions 0 assignees View on GitHub
bug
Dominant language
Elixir
Stars
189
Forks
168
Avg merge
13h 1m
Merged PRs (30d)
22

Description

https://wiki.postgresql.org/wiki/Don't_Do_This#Don.27t_use_timestamp_.28without_time_zone.29

While all of the Ash built-in primitives work fine on top of timestamp without timezone, we want to push users towards best practices. To this end, we will (at some point) add an opt-in toggle that switches `AshPostgres` to use `timestamp with time zone` for all of its datetime storage. This should (barring any investigation done when it's time to do the work) essentially just transparently make things better for users. The migration generator would pick up any changes and migrate them to UTC timestamps with time zone, and then basically this just have less trouble when working directly with the database in the future (in fragments or in SQL queries)

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.