title: Sqlite data insert from multiple applications
body: <p>I have a Sqlite database with two tables.  One table contains parameters to do calculations with.  The other table contains the results of the calculations.  Obviously the calculations should only be done once, that is why each table has a column with the same name so that the parameters and results can be recognized as a pair.</p>
  
  <p>I have an application that retrieves the parameters, do the calculations and update the database with the results.  Using one instance of this application works great.  The trouble begins when running multiple instances.</p>
  
  <p>Two problems persist:</p>
  
  <ol>
  <li><p>The instances calculate the same parameters since the parameters to pull from the database is determined by the completed test results in the database.  This problem I can maybe deal with by making use of csv files which all instances have access to to determine which parameter set is being calculated but a better solution will be appreciated.</p></li>
  <li><p>The database is updated at the same time by the different instances.  This does not work with Sqlite and the application skips the results and goes on to the next without updating the database or throws errors.</p></li>
  </ol>
  
  <p>Are there maybe built-in functions in Sqlite to overcome these problems?</p>
  
  <p>If anything is not clear please let me know and I will try to explain in more detail.</p>