title: How to use sqlite database on symfony2 project?
body: <p>In a Symfony2 project, you can configure the databases connections at the app/config/parameters.ini file. Documentation states that you can use, among others, sqlite3 PDO driver.</p>
  
  <p>But configuring sqlite doesn't works well:</p>
  
  <pre><code>[parameters]
      database_driver   = pdo_sqlite
      database_host     = localhost
      database_port     =
      database_name     = test_project.db
      database_user     = root
      database_password = 
  </code></pre>
  
  <p>Using app/console doctrine:database:create, successfully creates a test_project.db file at the project root directory.</p>
  
  <p>But after creating some entities, then running app/console doctrine:schema:update --force should create the tables on the database file, but it doesn't, file appears empty, with O bytes size.</p>
  
  <p>Note that using any other PDO driver works well, but not with SQLite...</p>
  
  <p>I've also tried to use the full path for the db file in the database_name parameter, but to no avail, database still doesn't gets updated.</p>
  
  <p>For reference, here's the doctrine dbal section of the config.yml file:</p>
  
  <pre><code>doctrine:
      dbal:
          driver:   %database_driver%
          host:     %database_host%
          port:     %database_port%
          dbname:   %database_name%
          user:     %database_user%
          password: %database_password%
          charset:  UTF8
  </code></pre>
  
  <p>Is there a way around this? configurations missing? something not stated on the official doc of symfony2 project?</p>