Android Question JSON and SQL Server/MySQL

[GrahamJBrown]

Hello. I am a newbie. I have been tasked with writing a new application for collecting shop floor information such as clocking in and out, starting a job, ending a job etc. I've already written the first version in VB.NET and Windows Forms. The shop floor have touchscreens so this works. The SQL database has various stored procedures to move the data.

I want to create this on an android tablet. I am presuming I would use the HTTP requests with JSON to post this possibly to a webservice running on the server. I have two servers, the internal one runs Windows Server (2016) and the external one (hosted) runs Linux and MySQL

Is there a detailed walk through to discuss the technologies involved.

Thanks
Graham

 

[Erel]

Http requests: [B4X] OkHttpUtils2 with Wait For

Json: https://www.b4x.com/android/forum/threads/convert-collections-to-json-and-vice-versa.132678/#content

Also check jRDC2: [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

 

[GrahamJBrown]

Thanks, that looks good