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

Schema needs updating to support PostgreSQL storage configuration #48

Open
guillempuche opened this issue Jan 17, 2025 · 1 comment
Open

Comments

@guillempuche
Copy link

guillempuche commented Jan 17, 2025

The schema.json file seems outdated as it only allows MongoDB as a storage type, but according to the current documentation, PowerSync now supports PostgreSQL as a storage option.

The schema should be updated to:

  1. Allow "postgresql" as a valid storage type
  2. Include PostgreSQL-specific configuration options for the storage section
  3. Make it consistent with the example configurations in the documentation

Example from docs showing PostgreSQL storage:

storage:
  type: postgresql
  uri: postgresql://user:pass@localhost:5432/db
  sslmode: disable
@stevensJourney
Copy link
Collaborator

The schema file in this repository was manually generated and added as a convenience helper for the demos.

Other additions since the initial demo releases, such as MySQL and MongoDB replication are also not yet in this schema file, and would require some additional work to compile all the supported types into a single schema.

Ideally we would generate and publish the schema in the https://github.com/powersync-ja/powersync-service repository. It's not a large project, we'll add this to our internal trackers.

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

No branches or pull requests

2 participants