MongoDB on mobile device with AppStudio - possible?

Anonymous User

Does anyone know of a way to get a MongoDB instance going on a device and accessible using AppStudio?

I want a local instance going that I can store and query JSON objects in.

Or, bonus points if anyone can tell me how to sync an AWS DynamoDB (a NoSql database) with a local database using just AppStudio.  

StephenQuan1

Hi Paul,

For a cross platform solution, yeah, you're pretty much restricted to REST API end points.

For that, we generally recommend either XMLHttpRequest or, AppStudio's NetworkRequest which has support for downloading blobs to files.

If you know you're running on Windows, you can consider using Simba's ODBC Drivers with the SqlDatabase to connect:

<SPAN class="comment token">// MongoDB ODBC sample</SPAN>

SqlDatabase <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; driverName<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"QODBC"</SPAN>
&nbsp;&nbsp;&nbsp; databaseName<SPAN class="punctuation token">:</SPAN> "Driver<SPAN class="operator token">=</SPAN>Simba MongoDB ODBC Driver<SPAN class="punctuation token">;</SPAN>Server<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>ServerInfo<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>
Port<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>PortNumber<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>Database<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN>MongoDBDatabase<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">;</SPAN>"
<SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token">// DynamoDB ODBC sample</SPAN>

SqlDatabase <SPAN class="punctuation token">{</SPAN>
&nbsp;&nbsp;&nbsp; driverName<SPAN class="punctuation token">:</SPAN> <SPAN class="string token">"QODBC"</SPAN>
&nbsp;&nbsp;&nbsp; databaseName<SPAN class="punctuation token">:</SPAN> "Driver<SPAN class="operator token">=</SPAN>SimbaDynamoDB ODBC Driver<SPAN class="punctuation token">;</SPAN>
Host<SPAN class="operator token">=</SPAN>dynamodb<SPAN class="punctuation token">.</SPAN>us<SPAN class="operator token">-</SPAN>west<SPAN class="number token">-2</SPAN><SPAN class="punctuation token">.</SPAN>amazonaws<SPAN class="punctuation token">.</SPAN>com<SPAN class="punctuation token">;</SPAN>Region<SPAN class="operator token">=</SPAN>us<SPAN class="operator token">-</SPAN>west<SPAN class="number token">-2</SPAN><SPAN class="punctuation token">;</SPAN>
AuthMechanism<SPAN class="operator token">=</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">;</SPAN>CredentialFile<SPAN class="operator token">=</SPAN>C<SPAN class="punctuation token">:</SPAN>\credentials<SPAN class="punctuation token">.</SPAN>txt<SPAN class="punctuation token">;</SPAN>
ProfileName<SPAN class="operator token">=</SPAN>simba<SPAN class="punctuation token">;</SPAN>"
<SPAN class="punctuation token">}</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

References:

   https://gist.github.com/search?utf8=%E2%9C%93&q=%40stephenquan+appstudio+sqldatabase+drivername&ref=searchresults

   https://www.simba.com/products/MongoDB/doc/ODBC_InstallGuide/win/content/odbc/m2/strings.htm 

   https://www.simba.com/products/DynamoDB/doc/ODBC_InstallGuide/win/content/odbc/dy/strings.htm 

Stephen