Plugin with its own database

Openfire Openfire Dev
1

Hello,

I am seeking for a plugin example with specific database tables. Has anyone shared such an example, since it is not in the wildfire plugins source ?

And what is recommended between creating an external database or extending wildfire’'s one with new tables ?

Thanks, Guillaume

2

Hi Guillaume,

I am seeking for a plugin example with specific database tables. Has anyone shared such an example, since it is not in the wildfire plugins source?

Take a look at the source to the gateway plugin (which comes with the wildfire source) for an example of how to work with a database. Also, the Plugin Developer Guide has some general database related instructions.

And what is recommended between creating an external database or extending wildfire’'s one with new tables?

Unless you have a specific reason not to, I would suggest you just add your tables to the existing Wildfire database/schema. By doing so you can take advantage of Wildfire’'s db connection pooling and other db related classes and methods.

Hope that helps,

Ryan