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

Add new unified database, migrate actor data #135

Open
johnholdun opened this issue Oct 4, 2023 · 0 comments · May be fixed by #138
Open

Add new unified database, migrate actor data #135

johnholdun opened this issue Oct 4, 2023 · 0 comments · May be fixed by #138
Assignees

Comments

@johnholdun
Copy link
Collaborator

The app currently stores data and configuration across two SQLite databases and a static JSON file. This issue describes the first part of a multi-step process to consolidate these stores into one new SQLite database, enabling more flexibility in administrative settings and general long-term stability. Extracted from #6, as written by @ckolderup:

  1. Create a new application.db database file with a unified setup process that establishes the new schema + migration process with a barebones schema
  2. Create a process by which the setup process detects existing account.json + activitypub.db actor singleton tables and imports them into an application.db settings table with schema defined in the migration .sql file (or files).
  3. Make the application code read this info from application.db instead of account.json/activitypub.db. Add the admin settings to manage the relevant settings data in application.db to make account.json obsolete. Set things up so that on startup, if all the required settings table key/value pairs are present, the owner is notified that they can remove account.json from their filesystem.
@johnholdun johnholdun self-assigned this Oct 4, 2023
@johnholdun johnholdun changed the title Add new unified database Add new unified database, migrate account.json Oct 4, 2023
@johnholdun johnholdun changed the title Add new unified database, migrate account.json Add new unified database, migrate actor data Oct 4, 2023
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