Hey hey, has anyone thought of doing target-mysql?...
# singer-target-developmentk
keith_siilats
07/21/2021, 8:07 PMHey hey, has anyone thought of doing target-mysql? I found a project with no code here: https://github.com/czardien/target-mysql
e
edgar_ramirez_mondragon
07/21/2021, 8:24 PMNo code but it's already version 0.0.4 🤔. I'd like to know what features MySQL is missing (e.g. compared to postgres) that make it not such a great option for warehousing, seeing how it's been largely ignored in that regard.
v
visch
07/21/2021, 9:45 PM@keith_siilats https://gitlab.com/autoidm/autoidm-target-mssql , uses ODBC would be a great starting point.
Highly recommend updating to the singer-sdk instead of my singer sdk implementation
visch
07/21/2021, 9:45 PMTons and tons of love needed but it does work, be careful though it's not super standard. No incremental, only support full table replication, no upserts etc
k
keith_siilats
07/21/2021, 10:21 PMok I will try to hack the upserts, I saw you do have the primary keys there already
v
visch
07/22/2021, 2:46 AMyeah the rename table call drops them right now. Also you should switch to actual temp tables. I'll throw in issues for these since you're looking at it
visch
07/22/2021, 3:01 AMmirrored to github as well 😄 https://github.com/AutoIDM/autoidm-target-mssql