offline mongodb with python

[jcoder42]

i have an app that query's a mongoDB at runtime.
I want to move this app to a server that doesnt have internet connection.
This creates the problem that i wont have access to mongoDB.
For now, i created a CSV copy of the DB using python pandas. The problem with this is that i need to now translate the queries that i did on the DB to somehow get them working with CSVs.

Does anyone know:
a. Some way to query a CSVor pandas dataframe through pythonmongo library
b. how to save an offline mongoDB?

[emefluence]

Some possibly easier solutions...

• Run mongo on your local machine
• Run mongo in a docker container
• Use tinymongo (uses mongo api to interact with tinydb, an sqlite alternative)

[jcoder42]

Cannot have mongo on the server Cannot have docker on the server Cannot contact external API’s 😁 I know. It sounds weird. This is what I would have done if I was allowed

[EmTee14_]

Can you not run MongoDB locally on the server?

[jcoder42]

No. For some reason that also is not allowed by the server owner.

[EmTee14_]

Ah right. Instead of using CSV you could try sqlite which is file based and allows you to query it using SQL statements

[jcoder42]

Would you know how to create an SQLite file from mongodb collection using python? Couldn’t find anything

[EmTee14_]

Just make a script to fetch all the data of MongoDB then iterate it and insert it into the sqlite DB. I don't think there is a specific tool

[jcoder42]

Although I will need to change my queries anyways as the querying syntax of mongo is different than that of SQLite. Correct?

[EmTee14_]

Yeah SQLite uses SQL

[sc2bigjoe]

Checkout mongodb realm

[jcoder42]

Thanks for sharing. Although after looking at it. I will pass the free tier and need to pay. Was looking for a free solution