gfsqlite

A simple SQL-Shell for SQLite in Python.

gfsqlite depends on pysqlite and gfsql

Features

• Simple SQL-Shell with history-function
  
  
• SQL-commands may be read from a file
  
  
• Supports a large subset of the SQL92-Standard (see the SQLite-Documentation for Details)
  
  
• Two-Language Mode (english, german)
  
  
• Export-Function
  
  
• Syntax-Coloring
  
  
• SQL-Snippets
  
  
• Works with SQLite 2.x or SQLite 3.x Databases
  
  

Documentation

• screenshot (gfsqlite in action)
  
  
• gfsqlite-tutorial (in german; try the following URL
  www.wspnet.de/gfsqlite/doku/anleitung.html
  in babelfish, it's funny! )
  
  
• gfsqlite-License
  
  

Download

• gfsqlite.zip (Windows: zipped, version 0.76, 2013-07-23, 75 KB)
  
  
• standalone-Version, for SQLite version 3.x (for windows only: exe-version 0.75, 2008-02-07, ca. 3.4 MB!)
  
  
• standalone-Version, for SQLite version 2.x (old SQLite version! For windows only: exe-version 0.75, 2008-02-07, ca. 2.5 MB!)
  
  
• gfsqlite.tar.gz (Linux: tared & gzipped, version 0.76, 2013-07-23, 60 KB)
  
  

Links

• SQLite
  
  
• pysqlite
  
  
• PyInstaller
  
  

Installation

1. First of all: you'll need Python (version 2.2 or later), Tkinter and Tix.
   
   
2. Install the Database-API pysqlite (version 0.5 or later). May be you must download the SQLite-source code from the SQLite-webpage for the proper installation of pysqlite, see the pysqlite-documentation for details.
   Note: Without the Installation of pysqlite gfsqlite will not work! And one more
   Note: Python 2.5 users under windows may have pysqlite, so you won't install pysqlite! Try import sqlite3 in the Python Shell!
   
   
3. Unzip gfsqlite.zip (Windows) or gfsqlite.tar.gz (Linux) in a subdirectory
   
   
4. Call gfsqlite.pyw in the gfsqlite-subdirectory
   
   

Installation of the Standalone-Version

With the PyInstaller you may create executables from Python-source. The standalone-version is a gfsqlite executable for windows only, created by the PyInstaller.

1. Download the standalone-version (depending on your SQLite-version!)
   
   
2. Unzip the file gfsqlite_exe_vers_3x.zip (or gfsqlite_exe_vers_2x.zip) in a subdirectory
   
   
3. Call gfsqlite.exe in the gfsqlite-subdirectory
   
   

Note: you won't need python or pysqlite for the standalone-version of gfsqlite.