title: SQLite foreign key constraints
body: <p>I am using Java with <a href="http://www.zentus.com/sqlitejdbc/" rel="nofollow">SQLiteJDBC</a>.</p>
  
  <p>I was struggling to understand why my foreign keys were not acting as constraints, until I read the following:</p>
  
  <p><em>Prior to version 3.6.19, SQLite did not support foreign key constraints.</em></p>
  
  <p>I then took a closer look at the SQLiteJDBC website and found:</p>
  
  <p><em>The current version is v056, based on SQLite 3.6.14.2.</em></p>
  
  <p>There is a solution documented <a href="http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers" rel="nofollow">here</a>, although it is a very old article - is it still  the best way to proceed?  Would other SQLite Java connectors be recommended?</p>