search

Prince-Mendiratta / BotsApp

Your personal assistant, on WhatsApp! The most user friendly userbot for the platform!
GNU General Public License v3.0
5.5k stars 1.27k forks source link

MongoDB support. #90

Closed z4nyx closed 2 years ago

z4nyx commented 2 years ago

Hi is it possible to add MongoDB support into this bot? Thank you!

Prince-Mendiratta commented 2 years ago

Hi @z4nyx . We are using PostgreSQL as a database on heroku and sqlite3 for local use. Why would you rather prefer to use MongoDB?

z4nyx commented 2 years ago

Hi @z4nyx . We are using PostgreSQL as a database on heroku and sqlite3 for local use. Why would you rather prefer to use MongoDB?

Since heroku has limited dynos for Free user I need to create another heroku account when the dynos ran out on my main account and I can't share the same Database across these two account using Heroku PostgreSQL but if It's MongoDB i can use the same Database for both heroku account. Well it's not a big issue but it would be nice but also not nice to people who aren't familiar with MongoDB. As you need to create account and create Database Manually.

Prince-Mendiratta commented 2 years ago

Just as you stated, many people are not familiar with with MongoDB and getting its connection URL will make the user experience extremely complex, which is rather detremential and against the concept of our bot.

As for your problem, you can copy the Postgres URL from config vars from your main account and use it on your alt account, the dyno limit won't interfere with the DB. If it does not work, try deleting the Postgres add-on from your alt heroku account by going to app -> resources -> add-ons -> Delete add-on. Then add config variable DATABASE_URL with the main account's connection string. This should work in most cases.

z4nyx commented 2 years ago

Just as you stated, many people are not familiar with with MongoDB and getting its connection URL will make the user experience extremely complex, which is rather detremential and against the concept of our bot.

As for your problem, you can copy the Postgres URL from config vars from your main account and use it on your alt account, the dyno limit won't interfere with the DB. If it does not work, try deleting the Postgres add-on from your alt heroku account by going to app -> resources -> add-ons -> Delete add-on. Then add config variable DATABASE_URL with the main account's connection string. This should work in most cases.

I tried and It doesn't work (already did the additional method you told me to) Still no luck. Heroku PostgreSQL doesn't work vice versa between two heroku account.

Prince-Mendiratta commented 2 years ago

Just as you stated, many people are not familiar with with MongoDB and getting its connection URL will make the user experience extremely complex, which is rather detremential and against the concept of our bot. As for your problem, you can copy the Postgres URL from config vars from your main account and use it on your alt account, the dyno limit won't interfere with the DB. If it does not work, try deleting the Postgres add-on from your alt heroku account by going to app -> resources -> add-ons -> Delete add-on. Then add config variable DATABASE_URL with the main account's connection string. This should work in most cases.

I tried and It doesn't work (already did the additional method you told me to) Still no luck. Heroku PostgreSQL doesn't work vice versa between two heroku account.

You're probably doing something wrong, I myself have been using a single shared Postgres database in three different apps and it works flawlessly. You should make sure the DATABASE_URL uses the correct url and the alt account does not have the postgres addon installed.

Prince-Mendiratta commented 2 years ago

Closing since no more conversations.