B4J Question B4J MQTT Connector for B4J Database

[CR95]

I would like to connect an SQLite database running with a B4J server by using MQTT transactions from Android clients.

I found this old thread (2016) :
https://www.b4x.com/android/forum/threads/rdc-based-on-mqtt.72416/#foote

But the example's attached library is for Arduino (RDC.b4r)

Is there an equivalent RDC Connector for running under Linux with B4J ?

 

[Erel]

It shouldn't be complicated to convert the B4R client to B4X. B4RSerializator module is available here: https://www.b4x.com/android/forum/t...ceive-objects-instead-of-bytes.72404/#content

 

[CR95]

Thanks for the quick reply
Let me explain what I would like to do.
Below is a picture with my actual situation using WebSocket for both standard (NON SQL) or SQL requests :

I know how to replace NON SQL requests by using MQTT on both sides Client and Server.

Question is for for replacing WebSocket Database transactions by MQTT transactions.
My understanding is :
- Client Side : B4A DBRequest manager has to be changed for sending SQL instructions by MQTT demands
- Server Side : B4J Server has to be completed for managing MQTT demands (similar to the change for NON SQL requests)
- Server Side : B4J RDC Handler has to be changed for managing MQTT SQL instructions
- Server Side : B4J RDC Connector has NOT to be changed

Please could you confirm ?

 

[Erel]

I think that your description is correct, though you don't need to change the existing handlers. You can add the "mqtt gate" as done in the linked example. This way you will have both options available.

 

[CR95]

Thanks. I go deeper