Support for Multiple Databases in Chatbot Storage

[Stonebanks-js]

Hi Samarth here is the description for my issue :

The current implementation of the chatbot uses chatterbot.storage.SQLStorageAdapter, which defaults to SQLite for storing the bot's training data and responses. While SQLite is a great lightweight database for development, it has limitations when scaling or deploying in production environments.

To make the chatbot more flexible and production-ready, it would be beneficial to support additional databases such as PostgreSQL, MySQL, or MongoDB. This will allow users to configure the chatbot storage according to their specific use case.

Proposed Solution:

1 : Modify the app.py to support multiple database adapters (e.g., PostgreSQL, MySQL). 2 : Introduce an environment-based configuration system (e.g., through .env files or Flask's configuration). 3 : Add documentation explaining how to set up different databases and configure the chatbot. 4 : Ensure backward compatibility with SQLite to avoid breaking current functionality.

Benefits :

1 : Enhances flexibility for users deploying the chatbot in various environments. 2 : Improves scalability for production use cases. 3 : Allows developers to choose the best database suited to their needs.

[Stonebanks-js]

@SamarthTech Assign me this issue with the label of hacktoberfest