Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python Using Databases in Python Meet Peewee Meet Peewee, Our ORM

Posted by MUZ140920 Kudakwashe Murungu
MUZ140920 Kudakwashe Murungu
6,316 Points

SQLite Installation

I have WAMP on my local machine. How do I get to use SQLite with Python.

1 Answer

Aaron Gill-Braun
Aaron Gill-Braun
180 Points
Aaron Gill-Braun
Aaron Gill-Braun
180 Points 
import sqlite3
conn = sqlite3.connect('example.db')

c = conn.cursor()

# Create table
c.execute('''CREATE TABLE stocks
             (date text, trans text, symbol text, qty real, price real)''')

# Insert a row of data
c.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")

# Save (commit) the changes
conn.commit()

# We can also close the connection if we are done with it.
# Just be sure any changes have been committed or they will be lost.
conn.close()

maybe depends on version.

Ryan Duchene
Ryan Duchene
Courses Plus Student 46,022 Points

Tweaked your answer a bit to add syntax highlighting. Great job, by the way.