title: Concurrent inserts into database
body: <p>I'm building a program that takes push data from six different sources and inserts the data into a database. Each source has its own function to execute the inserts as soon as they come, but all sources write to the same table.</p>
  
  <p>I would have the following questions:</p>
  
  <ul>
  <li><p>If one source is currently writing to the table and another source begins to write at the same time is there any chance the inserts will block each other?</p></li>
  <li><p>The table is also constantly being used to read the data via a view that join some more tables to show the data, can this pose any problems?</p></li>
  <li><p>Currently each source has its own DB connection to write data, would it be better to have only one connection, or have each use its own?</p></li>
  </ul>