I have an idea of pulling the data out of monday.com to an sql database.
** I have no experience in developing a database - except a local simple database like sqlite3 in python / mysql local server
- I don’t know how it works, how should i host a database, and where?
- how can I extract data from monday to sql database? - is this a good option (I’m concerned about data integrity issues)
- I was thinking to extract via Zapier, but they don’t seem to have option to track deleted columns/values
- I was also thinking Webhook option - is this hard to work with? I find the document only teaches how to create webhook on the monday side, how about on my end, what should I do?
- at the current stage, i just want to experiment with a basic demo prototype database with sqlite3 in vscode using python.
Thank you.