search

PostHog / posthog

🦔 PostHog provides open-source product analytics, session recording, feature flagging and A/B testing that you can self-host.
https://posthog.com
Other
19.39k stars 1.13k forks source link

feat: add the ability to connect to MySQL as a datawarehouse source #23370

Open jspizziri opened 4 days ago

jspizziri commented 4 days ago

Problem

Currently, the data warehouse functionality supports Postgres. This PR seeks to expand that functionality to allow for the import of MySQL/MariaDB databases.

Changes

posthog-dw-mysql posthog-dw-mysql-add

👉 Stay up-to-date with PostHog coding conventions for a smoother review.

Does this work well for both Cloud and self-hosted?

Yes

How did you test this code?

I tested the code by adding a MySQL flavored DB via the UI. However, it seems that there are some dependencies on a connection to an S3 bucket that I don't have. I'm largely looking for two things:

  1. I'd like to see if the Posthog team would consider adding this functionality/merging this PR.
  2. If the answer to the previous question is "yes", I'd like to ask for high-level guidance on this PR, as I have some questions.