title: Database sync solutions for Delphi
body: <p>I am looking for some starting points integrating a Win32 Delphi application's data with a remote database for a web application.</p>
  
  <p>Problem(s) this project intends to solve:</p>
  
  <p>1) The desktop does not perform well over vpns.  Users in remote office could use the web app instead.</p>
  
  <p>2) Some companies prefer a web app to the desktop app</p>
  
  <p>3) Mobile devices could hit the web app as a front end.</p>
  
  <p>Issues I've identified:</p>
  
  <p>Web application will run on a Unix based system, probably Linux while the desktop application uses NexusDB while the web application will likely be Postgres.  Dissimilar platforms and databases.</p>
  
  <p>Using Delphi it appears the Microsoft Sync Framework is not available for this project.</p>
  
  <p>My first thought was to give the web app your standard REST API and have the desktop app hit the API as though it's a client every n-minutes from the local database server.  Tons of issues I see with this already!</p>