Software ideas/Database Tools

PyLiteAdmin -- Database Competence is Discoverable

SQLite is included in python 2.5 and therefore on every XO.

This auspicious situation presents an opportunity to provide early hands-on experience with SQL and a local database application. Once database concepts are understood, the student can graduate to the more complex client/server environment which has become one of the dominant paradigms for online web applications (using Linxux, Apache, Mysql, Php --LAMP). The school server will be a LAMP server.

This project proposes to create a database administration tool for SQLite which mimics the look and the feel of Phpmyadmin in relation to MySQL.

Contact the proposer at georgejhunt@gmail.com

General Description

The application will be presented as a single page with clickable functions in tabs along the top and a left hand column (DbSelector) showing the tables and fields as a two level tree.

These two axes, the top row of tabs, and the left column for database selection, provide the visual anchors for discovery and exploration. The lower right portion of the screen provides feedback or interactivity that is particular to the tab selected.

Tabbed Functions

Browse

This is the tab which is selected when the application starts. By default, startup should bring up the last used database, so that all or the tabs and database objects along the left column cause something to happen on the screen when they are clicked.

The output panel show a table with field names along the top and record down the page. Selecting fields from the DbSelector displays just those fields in the table

Structure

When this tab is selected, the left column becomes only one level deep, displaying the table names but not the field names. By default the first table is highlighted in the left column and the field information is displayed in table form.

The field names, types can be changed, and new fields can be inserted into the table.