Android Question Does jRDC2 work with MongoDB?

[Widget]

Are there any links for getting jRDC2 to work with MongoDB?
Is it the same as MySQL?

TIA

 

[DonManfred]

if there is a jdbc driver for it it should work.

Maybe here: https://mongodb.github.io/mongo-java-driver/

 

[Erel]

Is it the same as MySQL?

Not at all. It is not a relational database.

[B4X] Remote MongoDB Connector (RMDBC)

 

[Widget]

Not at all. It is not a relational database.

[B4X] Remote MongoDB Connector (RMDBC)

Not at all. It is not a relational database.

[B4X] Remote MongoDB Connector (RMDBC)

1) Why does jRDC2 only use relational databases? Why accept only SQL for server side commands? I would have hoped jRDC2 would pass the server side (MongoDB non-sql) command directly to the MongoDB engine and have it return the results, maybe as JSON.

2) I don't think the Remote MongoDB connector RMDBC will be secure enough for public access on a web server. I prefer to use some sort of middleware.

3) Does jRDC2 work with PostgreSQL databases? I'd rather use it than MySQL.

TIA

 

[OliverA]

3) Does jRDC2 work with PostgreSQL databases? I'd rather use it than MySQL.

if there is a jdbc driver for it it should work.

 

[OliverA]

Why accept only SQL for server side commands?

Modified version that can do "methods": https://www.b4x.com/android/forum/threads/jrdc-hikari-mix.90033/

have it return the results, maybe as JSON.

The source code is provided. You can gladly modify it to return JSON. You have to remember that JRDC2 is a solution for the B4X environment, so the type of return (serialized object) makes sense in the B4X environment.

 

[Widget]

Modified version that can do "methods": https://www.b4x.com/android/forum/threads/jrdc-hikari-mix.90033/

The source code is provided. You can gladly modify it to return JSON. You have to remember that JRDC2 is a solution for the B4X environment, so the type of return (serialized object) makes sense in the B4X environment.

A serialized object is ok too. I will try it out. Thanks.

 

[Widget]

1) Why does jRDC2 only use relational databases? Why accept only SQL for server side commands? I would have hoped jRDC2 would pass the server side (MongoDB non-sql) command directly to the MongoDB engine and have it return the results, maybe as JSON.

2) I don't think the Remote MongoDB connector RMDBC will be secure enough for public access on a web server. I prefer to use some sort of middleware.

3) Does jRDC2 work with PostgreSQL databases? I'd rather use it than MySQL.

TIA

Can the SQL statements in the config.properties file reference stored procedures and stored functions from MySQL or PostgreSQL?

TIA

 

[OliverA]

I don't think so. The client side request manager has ExecuteQuery and ExecuteBatch. On the server side ExecuteQuery uses the ExecQuery2 method of the SQL class and ExecuteBatch uses the ExecNonQuery2 method. Looking at this post (https://www.b4x.com/android/forum/threads/calling-a-mysql-stored-procedure.51312/#content), you'll need CreateCallStatment and ExecCall on the server (JRDC2) side in order to execute a stored procedure. You have two (at least two) options:
1) Modify the client side request manager and add an ExecuteStored (or whatever you want to call it) and modify the server to handle the new type of request
2) Use the modifed JRDC2 I mentioned above and make a method call.

Looking through the forum, certain stored procedures may need an additional library published by @keirS (depending on the return value of the stored procedure): https://www.b4x.com/android/forum/threads/sql-simplyfying-calling-stored-procedures.73181/#content