Best practice to manipulate database in plugin development

chenglongma

Hi all,

I hope you are doing well.

I was wondering how we should store **structured** and **permanent** information in a plugin.

* Could I add a new table in Zotero's default database (i.e., zotero.sqlite)?
* Or should I add a new database like better-bibtex (i.e., better-bibtex.sqlite)?
* Or are there any other better practices to deal with permanent data?

Thank you so much!

Best regards,
Chenglong

emilianoeheyns

You could easily add a table to zotero.sqlite, but that could also easily break zotero database migrations. I'd recommend against it. Adding your own database (as BBT does) is really simple, you just attach it and it becomes available under the same connection you use to talk to the zotero database without the risk of polluting the zotero database.

chenglongma

Thank you @emilianoeheyns for your prompt reply.

I will follow your advice and add my own database.

Thanks.

Best,
Chenglong

adamsmith

The quick answer here non-withstanding, generally the zotero-dev google group is the better place for technical questions -- though it does occur to me with more folks from mainland China contributing, is that a problem? Can you access that without too much of a hassle?

chenglongma

Thank you for informing me about the existence of this group.

I am Chinese but currently residing in Australia, so accessing the group is no problem.

Thanks.