luckyframework / luckyframework/avram

Migrations should run SQL statements sequentially, not all together.

Open
#761 0 comments 1 reaction 0 assignees View on GitHub
Dominant language
Crystal
Stars
183
Forks
67
PR merge metrics
No merged PRs in 30d

Description

It's difficult to debug migrations because the SQL for an entire file is concatenated into one piece before execution. The error report is on the entire glob of statements, rather than a particular statement, and generally doesn't say anything helpful. I doubt there is any significant speed increase to be had on *migrations* by executing all statements as one.

Contributor guide

Open the contributing guide

Research direction

Start by locating the migration execution path that concatenates the SQL for an entire file before running it. Change the behavior so statements run sequentially, then verify that failures identify an individual statement and that the migration behavior remains correct.

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
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.