luckyframework / luckyframework/avram

Document adding a timestamp column with SQL `NOW()` as default value

Open
#944 1 comment 0 reactions 0 assignees View on GitHub
documentation
Dominant language
Crystal
Stars
183
Forks
67
PR merge metrics
No merged PRs in 30d

Description

Is it possible to add a timestamp typed column to an existing table, with the default value being a raw SQL `NOW()`? So if a new record is added, the column value is set to the timestamp the column was added.

Contributor guide

Open the contributing guide

Research direction

Start by locating Avram's migration API and the PostgreSQL column-default handling. Check how existing-table timestamp columns and raw SQL defaults are represented, then run the relevant migration tests or add coverage showing that new records receive the database timestamp after the column is added.

Written by the indexing model from the issue text.

Assessment

Tech stack
crystal, postgresql
Domain
databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.