luckyframework/avram

Adding ensure UTC default to DB with config option

開放

#732 建立於 2021年9月23日

 (3 則留言) (0 個反應) (0 位負責人)Crystal (67 個分叉)auto 404
feature requesthacktoberfest

倉庫指標

星標
 (180 顆星)
PR 合併指標
 (PR 指標待抓取)

描述

When you create a new DB, postgres seems to set the timezone to the host machine by default. This could lead to some odd behavior, especially in development, where your local DB is in PST, but your production DB is in UTC.

Postgres allows you to set this timezone at the session, DB, and global levels. What we could do is add some SQL to set this when you first create your DB:

execute <<-SQL
alter database #{Avram::Migrator::Runner.db_name} set time zone '#{Avram.settings.default_timezone}';
SQL

By default we could have a habitat setting default_timezone that's UTC. Then if you wanted to change this, you could. If you inherit a DB, then this would never affect you since you'd never run the create task.

貢獻者指南