MongoCBridge a dependency free and native MongoDB Autoit Driver

[emcodem]

Introduction

• This UDF is a Bridge between Autoit and the native Mongodb C Driver, namely mongoc-1.0.dll and parts of bson-1.0.dll
• As a native driver, the functions are extremely performant e.g. 10.000 queries per second to a simple Mongo Table
• It does not expose "all" functionalities of the original mongoc driver dll but hopefully it translates everything that one needs in real life. 
• In difference to all known to me existing ways of using Mongodb from autoit, this is fully portable and dependency free.
• The reason why i worked on this is because i wanted @steipal to migrate FFAStrans from using Filesystem as a Database to a real Database. FFAStrans has been introduced here, it is a huge Tool for Workflow Automation written in Autoit.  Why i want to change from FS to DB is this is that the filesystem is not a database and in larger scenarios with concurrent access in a distributed system, one hits many issues which are hard or even impossible to debug and workaround.

Requirements

• DLL and UDF package: https://github.com/emcodem/MongoCBridge/releases/
• Only 64bit build is provided.
• OS must be above Win 7 because the original mongoc dll links to bcrypt.dll and therefore cannot work in old windows. 
• Otherwise the build is fully static and standalone, my dll contains all dependencies, even the mongoc and bson dlls.
   

Source Code

https://github.com/emcodem/MongoCBridge

Documentation

The core functions of the UDF, MongoDB.au3, are documented with comments inside the file as usual.

For some understanding which JSON payload some functions require, especially "command_simple", you will need to consult the original MongoC documentation, direct links to the functions are also found in MongoDB.au3, example: https://mongoc.org/libmongoc/1.29.1/mongoc_client_command_simple.html

The release package includes an example implementation, showing how to utilize the mongodb driver, _DB_FileFuncAbstraction_Test.au3.

Note that you only need to make the connection ONCE in your code (using func _Mongo_CreateCollection). The underlying MongoC Driver DLL takes care about networking issues so even if the network connection gets lost or mongo offline in some way, it will automatically continue working again once the DB is back alive and connectable. Of course all requests to the DB will fail while it is offline, setting corresponding autoit errors structs as usual. This means instead of re-init connection in case of error, you can just retry the action (read/insert/admin cmd)

Example wind up (and issue "drop collection" command for testing):

#include "MongoDB_UDF\MongoDB.au3"
#include "MongoDB_UDF\MongoDB_SimpleJson.au3"

_Mongo_Init(@ScriptDir & "\MongoDB_UDF")
Local $s_mongo_url         = "mongodb://localhost:27017"
Local $s_mongo_database_name     = "tests"
Local $s_mongo_collection_name     = "db"
Local $pDB = _Mongo_CreateCollection($s_mongo_url, $s_mongo_database_name, $s_mongo_collection_name)
;; from here $pDB is used for all database commands to this collection, it does not ever need to be renewed
_Mongo_ClientCommandSimple($pDB, '{"drop": "'&$s_mongo_collection_name&'"}')

Help / Support

Please post questions directly in this thread.

 

 

Edited 13 hours ago by emcodem
Dcoumentation