A python app has been successfully configured with the MySQL connector to write records to a small table to demonstrate a concept (very low volume of writes).
I will need to write to a database and read them back. I was hoping I could recreate the small table on Kodi's database and write with the MySQL connector. I then found out that SQLite (and not MySQL) is the Kodi RDBMS.
I suspect that that it is unlikely that I can use the MySQL connector to write to the Kodi's SQLite database (I am reluctant to experiment because I do not want to bork up the database). That being said:
Is it possible to read / write records with the python MySQL connector to a SQLite RDBMS?
If it is not possible: what pitfalls must be avoided when installing mySQL alongside Kodi?
If you have successfully performed either please indicate this in your response along with any lesson learned \ pitfalls to avoid? Thank you