Discord bot built with Pycord that offers AI chat and image generation inside of Discord. Image generations are saved in cloudinary and hosted online for all to download.
Is your feature request related to a problem? Please describe.
While my current SQLite3 setup is performing well and I haven't encountered significant issues, I want to keep the option open for future scalability as the bot grows. PostgreSQL could provide enhanced performance and concurrency support that may be beneficial down the line.
Describe the solution you'd like
I propose updating Cognibot to use PostgreSQL as the database instead of SQLite3. This would involve modifying the database connection settings and ensuring compatibility with PostgreSQL for all database interactions. Additionally, implementing any necessary migrations for existing data would be essential.
Describe alternatives you've considered
I've optimized the SQLite3 implementation and it works effectively for now. However, I believe that transitioning to PostgreSQL could be a strategic move for future growth and more complex data handling.
Additional context
I have reinstalled PostgreSQL on my Raspberry Pi and can handle the necessary configurations or commands for the transition. While this feature is a lower priority at the moment, I want to keep it on the radar as a potential enhancement for when the bot's usage increases. I have used PostgreSQL in this project before so this isn't going to be a giant pull to update.
Is your feature request related to a problem? Please describe.
While my current SQLite3 setup is performing well and I haven't encountered significant issues, I want to keep the option open for future scalability as the bot grows. PostgreSQL could provide enhanced performance and concurrency support that may be beneficial down the line.
Describe the solution you'd like
I propose updating Cognibot to use PostgreSQL as the database instead of SQLite3. This would involve modifying the database connection settings and ensuring compatibility with PostgreSQL for all database interactions. Additionally, implementing any necessary migrations for existing data would be essential.
Describe alternatives you've considered
I've optimized the SQLite3 implementation and it works effectively for now. However, I believe that transitioning to PostgreSQL could be a strategic move for future growth and more complex data handling.
Additional context
I have reinstalled PostgreSQL on my Raspberry Pi and can handle the necessary configurations or commands for the transition. While this feature is a lower priority at the moment, I want to keep it on the radar as a potential enhancement for when the bot's usage increases. I have used PostgreSQL in this project before so this isn't going to be a giant pull to update.