How to add mysql libraries in calibre?

[esvorontsov]

Hello!
I'm developing a gui plugin that needs to write to mysql.
How to add the required libraries in calibre, for example, the MySqlDb connector?

[eschwartz]

calibre's metadata.db doesn't use a mysql database. sqlite is included in calibre, but only as a way to open and read the database.


If you want to store information in calibre's database, you can simply write your own namespaced fields to the db -- the same way calibre does.

[esvorontsov]

Originally Posted by eschwartz

If you want to store information in calibre's database, you can simply write your own namespaced fields to the db -- the same way calibre does.

I want to write information to mysql database

[esvorontsov]

the plugin needs to read from the calibre database and writes to mysql database from which the data is displayed on the website

[eschwartz]

Then you will have to bundle the necessary modules inside the plugin yourself.

All resources from inside the plugin zip are accessible by importing calibre_plugins.plugin_name.module_name

If you need a standalone mysql client that is implemented in pure python, try: https://github.com/PyMySQL/PyMySQL

[esvorontsov]

thanks