Monday.com to SQL

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

  1. I don’t know how it works, how should i host a database, and where?
  2. how can I extract data from monday to sql database? - is this a good option (I’m concerned about data integrity issues)
  3. I was thinking to extract via Zapier, but they don’t seem to have option to track deleted columns/values
  4. 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.