title: SQLite PATH environment variable & db browser sqlite
body: <p>I’m a Java engineer (in training).  Recently started getting into databases and all involved: SQL, JDBC, MySQL &amp; SQLite.</p>
  
  <p>My questions are in regards to SQLite:</p>
  
  <p><a href="http://www.tutorialspoint.com/sqlite/sqlite_installation.htm" rel="nofollow noreferrer">According to tutorials point</a>, I have 4 steps in installing SQLite:</p>
  
  <blockquote>
    <p>Install SQLite On Windows:</p>
    
    <ol>
    <li>Go to SQLite download page, and download precompiled binaries from Windows section.</li>
    <li>You will need to download sqlite-shell-win32-<em>.zip and sqlite-dll-win32-</em>.zip zipped files.</li>
    <li>Create a folder C:>sqlite and unzip above two zipped files in this folder which will give you sqlite3.def, sqlite3.dll and sqlite3.exe
    files.</li>
    <li>Add C:>sqlite in your PATH environment variable and finally go to the command prompt and issue sqlite3 command, which should display a
    result something as below.</li>
    </ol>
  </blockquote>
  
  <p>I’m not sure what to make of step 4.</p>
  
  <p>Most of the SQLite tutorials I have found simply DL the shell, place it in a folder in C and then access SQLite3 via command, &amp; then start working.</p>
  
  <p>I’ve done all of this, made a DB and work with it a bit, etc…</p>
  
  <p>I also put a shortcut to the SQLite shell on my desktop.</p>
  
  <p>Question: what is sqlite-dll-win32-*.zip for?</p>
  
  <p>Question: How should I go about(do I need to) Add C:>sqlite in your PATH environment variable?</p>
  
  <p>I’ve also been learning how to use db browser sqlite. </p>
  
  <p>Qestion: I’m wondering if when I DL &amp; installed this(sqlitebrowser) if some of the above was taken care of/installed with?  And if you can recommend any tutorials for it(or SQLite for that matter)?</p>
  
  <p>I’ve set environment variable before(but limited experience).<br>
  Here is a pic of my system properties &amp; the value of my Path variable…if this helps in some way.</p>
  
  <p><a href="http://screencast.com/t/mbpfEMw8" rel="nofollow noreferrer">http://screencast.com/t/mbpfEMw8</a></p>
  
  <p>BTW: Windows 8.1, 64x. &amp; thanks.</p>
  
  <pre><code>C:\oraclexe\app\oracle\product\11.2.0\server\bin;;C:\ProgramData\Oracle\Java\javapath;C:\Program Files\Broadcom\Broadcom 802.11 Network Adapter;;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5.3 &amp; MySQL Utilities 1.5.3 1.5\;C:\Program Files (x86)\MySQL\MySQL Fabric 1.5.3 &amp; MySQL Utilities 1.5.3 1.5\Doctrine extensions for PHP\;C:\Program Files (x86)\Skype\Phone\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\
  </code></pre>