Android Server and B4A

[EduardoElias]

Hi there!

I am pretty new here, but I am happy with what I could get already.

I am looking to develop applications using B4A and Android that will be desktop replacements on stores and business alike.

the major difficult right now is database. I have followed the ideas here and examples, and created a HTTP server in Delphi that receive and send request for a database using JSON. It is working fine. My idea is to create or use a database library on B4A that is remote controler of the server database (something like JDBC)

Since it is a HTTP server (with a JSON service) I can reproduce it on B4A and substitute the PC based server.

Is there any recomendation from your experience of creating a Android database server? using the internal SQLite for a database, saving it on a external usb HD. Of course we are not talking about high loads of data, and lots of connections, but talking about around 20 users requesting items, stock, prices, that is not commonly too heavy.

Is there a device that fits better this idea?

Thanks on any thoughts.

 

[Erel]

Will the devices be always connected to the local network? In that case you may want to only use a remove database and contact it through a web service.

 

[EduardoElias]

Will the devices be always connected to the local network? In that case you may want to only use a remove database and contact it through a web service.

The idea is using like a regular PC based network. What i see is that Android OS already have all the tools for a daily work in an office/store. Users doesnt care what OS is in place, just want to do their work.

What i dont know is that if SQLite is ok for such operation, if B4A can handle few (max 20 I believe) simultaneos connections (http) that will ask for SQL to be executed and returned, and if using the database in a external storage works, USB HD

Thoughts or ideas are welcomed, since all this is new. Thanks

 

[Erel]

Do you want to use SQLite on the main server? SQLite should be able to handle this (though MySQL is better suited for a server database).

 

[TomDuncan]

"and created a HTTP server in Delphi that receive and send request for a database using JSON. It is working fine."

Do you have the source for this Delphi program. I am trying to do exactly that.
I need the server to be a Delphi app and the Android one of the clients.

Tom

 

[EduardoElias]

Tom,

I have created this server as a commercial product.

I am licensing it to software houses that use it as a server for android based applications. It took a lot of time and investment to make this server work.

What is your need, where do you want to use it? Eventually we could enter in agreement for licencing this server according your needs.

Please give me a better description of what you are looking for, and I am willing to work together in a solution for you.

Eduardo

 

[TomDuncan]

The software is used as a patient database. At the moment all remote users, use laptops while out of the office. When they return they sync with the master database. The tablet version I think will be much the same. Sync before the practitioner goes out, then sync when they return.
If this idea does not work and/or becomes too expensive I will go for the sqlite idea of doing a copy of the database via wireless then syncing with the master database.
Usage of this software is in the dozens not hundreds.

Tom Duncan

Any code snippets and general ideas would be of great help thanks.