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.

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

Update the postgres-to-sqlite-export script to be a lot more cautious #14937

Closed
Tracked by #14225
stevejalim opened this issue Jul 31, 2024 · 0 comments · Fixed by #14993
Closed
Tracked by #14225

Update the postgres-to-sqlite-export script to be a lot more cautious #14937

stevejalim opened this issue Jul 31, 2024 · 0 comments · Fixed by #14993
Assignees

Comments

@stevejalim
Copy link
Collaborator

stevejalim commented Jul 31, 2024

We have a proof-of-concept script for generating a fresh sqlite DB from postgres, but we need to refactor it ahead of production use.

We need to ensure that:

  1. it's purely additive on the sqlite side, rather than having to delete certain things after loading
  2. it's atomic, so if any step fails, the whole thing is abandoned
  3. if failure occurs, no DB is generated (not even an empty one)
  4. if failure occurs, Sentry is notified, loudly
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant