title: Insert data from files into SQLite database
body: <p>I have an SQLite database on this form:</p>
  
  <pre><code>Table1
  
  Column1 | Column 2 | Column 3 | Column 4
  </code></pre>
  
  <p>I want to populate this database with data stored in some hundred .out files in this form, where every file has millions of rows:</p>
  
  <pre><code>value1;value2;value3;value4;
  2value1;2value2;2value3;2value4;
  ... etc
  </code></pre>
  
  <p>Is there a fast way to populate the database with these data? One way would be to read in the data line for line in python and insert, however there probably should be a faster way to just input the whole file?</p>
  
  <p>Bash, SQLite, Python preferrably</p>