Database Manager : SQLiteSpy

SQLiteSpy is a fast and compact GUI database manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.

readmore

A simple SQLite Database with GUI, easy to manage, create and save SQL. Able to retrieve 500,000 rows within 5 minutes.

SQLite- Fetch

Fetch is a SQlite function, it writes in fetch( ). The purpose of this function is to

Return a result record of the query

For example:

1. fetchall( ) - return all as a tuple

for row in cur.fetchall( ):
print "name",row[0], "address",row[1]

2. fetchone( ) - return first row

for row in cur.fetchone( ):
print "............................

3. fetchmany( size) - return row according to size

for row in cur.fetchmany(200)
print "%s | %s |%s" %row

GoogleTalk on Python

Getting with Python Module

Introduction and Installation