Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Add to the readme information about SQLite features #121

Open
zhabinka opened this issue Dec 15, 2019 · 3 comments
Open

Add to the readme information about SQLite features #121

zhabinka opened this issue Dec 15, 2019 · 3 comments
Labels
bug Something isn't working documentation Improvements or additions to documentation good first issue Good for newcomers help wanted Extra attention is needed

Comments

@zhabinka
Copy link
Contributor

zhabinka commented Dec 15, 2019 •
edited
Loading

При использовании SQLite невозможно откатить миграцию, если в таблице хотя бы один столбец использует FOREIGN KEY. При внесении изменений пересоздаётся вся таблица целиком.

Решение: пересоздавать всю базу данных: migrate:fresh.
@fey
Copy link
Collaborator

fey commented Dec 15, 2019

В общем, большая беда с тем, что в разработке используется SQLite, а на проде Постгрес. Я уже не раз столкнулся с тем, что в некоторых местах код вел себя по-другому чисто из-за базы. Надо подумать, не пора ли перейти для локальной разработки на постгрес

@fey fey added documentation Improvements or additions to documentation good first issue Good for newcomers help wanted Extra attention is needed labels Dec 15, 2019
@acidmaksim
Copy link
Contributor

@zhabinka перешли на постгрес?

@acidmaksim acidmaksim changed the title Добавить в readme информацию об особенности работы SQLite Add to the readme information about SQLite features Sep 13, 2022
@acidmaksim acidmaksim added the bug Something isn't working label Oct 31, 2022
@acidmaksim
Copy link
Contributor

Задача актуальна

@acidmaksim acidmaksim mentioned this issue Nov 8, 2022
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug Something isn't working documentation Improvements or additions to documentation good first issue Good for newcomers help wanted Extra attention is needed
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@fey @zhabinka @acidmaksim