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

Create migration scripts to change from akka_ schema prefix to pekko_ prefix #17

Open
mdedetrich opened this issue Apr 13, 2023 · 5 comments
Labels
enhancement New feature or request

Comments

@mdedetrich
Copy link
Contributor

This persistence plugin used to store data in databases with the akka_ prefix but it has been changed to pekko_. A migration script should be provided to change this prefix for people coming from akka_

@mdedetrich mdedetrich added the enhancement New feature or request label Apr 13, 2023
@mdedetrich mdedetrich changed the title Create migration scripts to change from akka_ prefix to pekko_ prefix Create migration scripts to change from akka_ schema prefix to pekko_ prefix Apr 13, 2023
@pjfanning
Copy link
Contributor

@mdedetrich Is this a blocker? Could it just be release noted?

@mdedetrich
Copy link
Contributor Author

@mdedetrich Is this a blocker? Could it just be release noted?

@pjfanning I wouldn't say this is a release blocker however it would be ideal to have this here especially after #19 is merged on initial release if it doesn't make too much time.

@pjfanning
Copy link
Contributor

pjfanning commented Dec 7, 2023

The DDL is straightforward. I think most users who migrate from Akka can work it out themselves.

Renaming tables can be a little bit different on different databases. Most databases have good documentation on how to rename tables or how to export data and reimport it.

@nvollmar
Copy link

nvollmar commented Dec 7, 2023

We could advise them in the migration doc that overriding the keys for backwards compatibility is an option to renaming the tables:

    offset-table = "akka_projection_offset_store"
    timestamp-offset-table = "akka_projection_timestamp_offset_store"
    management-table = "akka_projection_management"

@pjfanning
Copy link
Contributor

full qualified configs:

pekko.projection.r2dbc.offset-store {
    offset-table = "akka_projection_offset_store"
    timestamp-offset-table = "akka_projection_timestamp_offset_store"
    management-table = "akka_projection_management"
}

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants