Manually delete records that are present in a Foreign Key relationship
Open
@thivindu is already working on this.
Since Dec 3, 2025.
Type/Improvement
- Dominant language
- Go
- Stars
- 71
- Forks
- 111
- Avg merge
- 1d 14h
- Merged PRs (30d)
- 110
Description
Current Limitation
We cannot ensure that child records are deleted when the parent record is deleted even if they are bound by a Foreign Key with has cascade on DELETE in SQLite.
Suggested Improvement
Keep the Foreign Key with has cascade on DELETE in the DB scripts but manually delete child records that are present in a Foreign Key relationship before deleting the parent record. Then delete the parent record.
Version
No response
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.