title: SQLAlchemy engine absolute path URL in windows
body: <p>I'm trying to connect to a sqlite-database file in a python 3.3 application on a windows 7 x64 machine. To do so, the documentation states:</p>
  
  <pre><code># sqlite://&lt;nohostname&gt;/&lt;path&gt;
  # where &lt;path&gt; is relative:
  engine = create_engine('sqlite:///foo.db')
  
  # or absolute, starting with a slash:
  engine = create_engine('sqlite:////absolute/path/to/foo.db')
  </code></pre>
  
  <p>I would like to use the absolute path, what is the windows-equivalent to <code>sqlite:////absolute/path/to/foo.db</code>? The database is stored in <code>C:/Users/Username/AppData/Roaming/Appname/mydatabase.db</code>.</p>
  
  <p>Any help is appreciated!</p>