title: How to work with sqlite3 and Python
body: <p>I was looking for any database solution with Python. And found the tutorial <a href="http://www.blog.pythonlibrary.org/2012/07/18/python-a-simple-step-by-step-sqlite-tutorial/" rel="nofollow">Python: A Simple Step-by-Step SQLite Tutorial</a>. There I found a code example which shows how to create a database and INSERT some data:</p>
  
  <pre><code>import sqlite3
  
  conn = sqlite3.connect("mydatabase.db") # or use :memory: to put it in RAM
  
  cursor = conn.cursor()
  
  # create a table
  cursor.execute("""CREATE TABLE albums
                    (title text, artist text, release_date text, 
                     publisher text, media_type text) 
                 """)
  </code></pre>
  
  <p>I am totally new to <code>sqlite3</code>. </p>
  
  <ul>
  <li>If I want to use <code>sqlite3</code> do I need to install any particular Python modules?</li>
  <li>In the above code I can see one database named <code>mydatabase.db</code>. How do I create that database?</li>
  </ul>
  
  <p>If anyone help me to get these confusions cleared from my head, I can give these new module a good start.</p>
  
  <p>Thanks</p>