Xojo only (no plugins)
Central SQLite database (nobody can administrate PostGres or MySQL)
Accessed from 1-20 different client computers and mobile devices (iOS and Android)
Fairly low power / data throughput (the biggest will be syncing the database on connection so the client has a local copy to work with)
Clients connected on internal network or if external via VPN
Must be secure (eg encrypted database, encrypted communication)
Must be extremely easy to use
How should I structure this? I was thinking a central server app that deals with user management, changes/requests to the database, and communicates with the client apps.
What protocol to use best for communication?
Desktop or Webserver?
Don’t want to reinvent the wheel if anything open source is out there (Aloe?)
Anything else I need to think of?
As I haven’t done ANYTHING yet with servers and inter-app communication I’d be thankful for any advice that comes my way