title: How to create a database file in python
body: <p>How to create a database file in python.</p>
  
  <pre><code>import sqlite3
  from sqlite3 import Error
  
  def create_connection(db_file):
      """ create a database connection to a SQLite database """
      conn = None
      try:
          conn = sqlite3.connect(db_file)
          print(sqlite3.version)
      except Error as e:
          print(e)
      finally:
          if conn:
              conn.close()
  
  if __name__ == '__main__':
      create_connection(r"C:\sqlite\db\pythonsqlite.db")
  </code></pre>