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

Support filling postgres from sqlite and dumping postgres to sqlite #14541

Closed
3 tasks
Tracked by #14225
stevejalim opened this issue May 2, 2024 · 0 comments · Fixed by #14590
Closed
3 tasks
Tracked by #14225

Support filling postgres from sqlite and dumping postgres to sqlite #14541

stevejalim opened this issue May 2, 2024 · 0 comments · Fixed by #14590
Assignees

Comments

@stevejalim
Copy link
Collaborator

stevejalim commented May 2, 2024

Description

As part of integrating Wagtail into Bedrock, we'll have a RDBMs (Postgres) connected to an 'editing node' running Bedrock, and will export a sqlite DB with that same data, which the web pods will use (They currently use sqlite now, so this is just changing how we update/maintain the main sqlite DB that gets copied down to each web pod)

Of course, we'll also need to set up the latest version of Bedrock data in that postres DB before we can dump data from it


Success Criteria

  • A script will fill an empty postgres DB with an equivalent of the data from the latest cut of the sqlite DB
  • A script exists that will genrate a new, sqlite DB from a postgres DB that is connected to (local) Bedrock
  • When Bedrock is configured to use that generated sqlite DB, all data is usable, just as it is now.
@stevejalim stevejalim self-assigned this May 2, 2024
@stevejalim stevejalim changed the title Support dumping postgres to sqlite Support filling postgres from sqlote and dumping postgres to sqlite May 20, 2024
@stevejalim stevejalim changed the title Support filling postgres from sqlote and dumping postgres to sqlite Support filling postgres from sqlite and dumping postgres to sqlite May 20, 2024
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