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

Feature: add Postgres target #74

Closed
morsapaes opened this issue Mar 10, 2023 · 0 comments · Fixed by #101
Closed

Feature: add Postgres target #74

morsapaes opened this issue Mar 10, 2023 · 0 comments · Fixed by #101
Labels
enhancement New feature or request

Comments

@morsapaes
Copy link

Is your feature request related to a problem? Please describe.

Although Kafka is a great place to start building out the tool, it'd be useful to extend the generator and support producing data to a Postgres target. This would ensure we don't force users to adopt and/or learn Kafka if their use case just requires direct Postgres CDC to Materialize.

I can also see this being useful for internal testing of our Postgres source.

Describe the solution you'd like

Since we already support .sql files as input, we could run these against the specified connection to bootstrap the target database (+ which should be configured for logical replication). Generating relational data sounds a bit tricky, but there are a few SQL Faker implementations out there we could draw inspiration from (e.g. sqlfaker, sql-faker). I'd be motivated to work on a prototype! 🖖

@morsapaes morsapaes added the enhancement New feature or request label Mar 10, 2023
@bobbyiliev bobbyiliev mentioned this issue Jun 9, 2023
8 tasks
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

Successfully merging a pull request may close this issue.

1 participant