What database and mechanisms to be used for work with different devices?
Writing a desktop application in C#. Application for processing data receives and stores data, outputs the statistics. I also want to write an app on Android with the same functionality for mobility. Wonder what database to use to both programs worked with her and were always in sync.
Tell me, please.
The logic, as I understand it, processing will execute the app itself?
In your case two applications that's not right.
The application should only be one console (thin client).
All the logic for obtaining data (from the side), the design task must be performed on the server.
The clients only send commands and display the result.
If you work with large amounts of data - you do not need them all to pull on the client for the calculations and send back the results.
Synchronization can be achieved through periodic updates of the status of the client or if the clients communicate via sockets with the server, the server can notify the client of the changed condition instant.
kailyn_O answered on March 25th 20 at 13:15
the priority of Postgresql
a good option for the backend (DBMS on a remote server. so, for safety at least and covered with a layer of API)
if you want local, the same cross-platform DBMS as the application itself, this is most likely SQLite
priscilla72 answered on March 25th 20 at 13:17
It is strange that you have a question about database but not about architecture.
What architecture is?
Nathanael_Renner answered on March 25th 20 at 13:19
Absolutely no difference in what will be a DB: MySQL, Postgre, MSSQL, but at least Redis or Mongo...
As a first step I would need to do the web part and write API.
And after this API will work all mobile devices, desktop app and web.
PostgreSql is a good choice
Deja.Cronin answered on March 25th 20 at 13:21
Database can use any what you like more. Data exchange can be arranged through JSON