Connecting to MongoDB

[cellanrust]

That’s great and all but as far as I know you can only query from Javascript which doesn’t help my situation

[malik]

Yes, Moralis is mainly a Javascript SDK. There will be more language supports with production ready code very soon. We are right now focusing on infrastructure thus the later release.

[waterglobal]

Is it possible to connect with a mongodb client such as Compass or noSqlBooster to the database?

[cryptokid]

I didn’t try those clients, but it is possible to connect from a Python script. You’ll have to use only IP and PORT without username and password, and you’ll have to whitelist your IP in your Moralis server settings.

[kstarek]

Hi could you please provide an example of this? I tried to do so but always get: pymongo.errors.ServerSelectionTimeoutError: xxxIPxxx:xxxPORTxxx: [WinError 10054] An existing connection was forcibly closed by the remote host, Timeout: 30s

[cryptokid]

How to do database backups?

You find the IP and port where to connect to mongo db in your Moralis server settings, you will also need to whitelist the IP that will connect to that mongo db instance (also in settings). After that you can connect to that database and make queries directly there, for example this is a python script that makes a simple query: import pprint import pymongo MONGO_HOST = "asfasdf.moralis.io" MONGO_PORT = 43234 con = pymongo.MongoClient(MONGO_HOST, MONGO_PORT) user_table = con['parse']['_User']…

[kstarek]

Thank you so much, one last thing:

MONGO_HOST = “asfasdf.moralis.io”

what would I replace asfasdf with?

The MongoDbIP? or the link to my dashboard? or my server URL?

very much appreciated

[cryptokid]

you put there the IP that you find in your admin interface for mongo db, in same place where you find the port

[blockCh41ner]

If I’d like to connect via mongodb in javascript (ignoring the moralis API), what would be the username or password?

Thanks!

[cryptokid]

no username or password, you’ll have to whitelist your IP in admin interface

[blockCh41ner]

Can you show how the url would look like, can I just leave out username and password?

Can i whitelist a domain if I have a changing IP address?

[cryptokid]

How to do database backups?

You find the IP and port where to connect to mongo db in your Moralis server settings, you will also need to whitelist the IP that will connect to that mongo db instance (also in settings). After that you can connect to that database and make queries directly there, for example this is a python script that makes a simple query: import pprint import pymongo MONGO_HOST = "asfasdf.moralis.io" MONGO_PORT = 43234 con = pymongo.MongoClient(MONGO_HOST, MONGO_PORT) user_table = con['parse']['_User']…

you can not whitelist a domain, only IPs

[blockCh41ner]

What is the correct way for implementing server side rendering database connections under varying IP addresses in production settings?

[cryptokid]

you could use a proxy that has a static IP, or you could use Moralis SDK to make queries in db and not connecting directly to DB (you can use master key server side)

[blockCh41ner]

Thanks for you fast feedback! Will give that a try

[blockCh41ner]

Works like a charm with the Moralis SDK. Great work!

[tigrewoooods]

I feel like a 2 or 3 minute video would be very helpful for this. I’m spending hours on this and still no luck. Like where do you put the python script query? in the database api?

[tigrewoooods]

there is such a small amount of official documentation on this compared to some other topics. one little paragraph and a couple forum posts

[cryptokid]

The python script you can run it locally after you whitelisted your public IP. You can use any other language to connect to mongo db. Or any other tool.

[tigrewoooods]

ok when i try to add an ip for whitelist and hit save it doesn’t do anything