John Newby wrote:
No, I'm not asking the community to do my homework for me, I need to do a
user analysis phase for my dissertation, and as I don't know anyone who uses
SQLite this is the only place I can get my questions answered.
Many thanks.
John.
On 13/12/05, juan perez <[EMAIL PROTECTED]> wrote:
So in a nutshell you are asking the community to do your homework. What
a shame.
Start by analyzing the sqlite3 command line interface, make a GUI that
replicates that (and more, heck its a GUI), contribute it to the sqlite
project, THEN talk about your dissertation.
jp.
John Stanton wrote:
john.newby wrote:
Hi, I am doing my final year project/dissertation on "Creating a GUI to
SQLite"
I am after help for my analysis phase and would like any comments/help
from
members or if you could put me in the right direction as to where I
could
find out this information.
I would like information regarding SQLite for the following if at all
possible:-
Why users use SQLite instead of other SQL databases?
SQLite has two fine features. Firstly it is simple, lives in one file
and doesn't require a server process. Secondly it implements all the
important elements of SQL.
Would a GUI detract users from using SQLite?
There is a wagon load of GUIs to SQLite already. They neither add nor
detract from the DBMS.
Regarding a GUI to SQLite:-
What features a GUI MUST have?
What features you would LIKE a GUI to have?
What features you would NOT LIKE to have?
This is like asking what features are needed in a coat without
specifying its intended usage.
Any help on these questions or any other information you may feel
would help
me on my journey would be greatfully appreciated.
You can contact me at my University email address on
[EMAIL PROTECTED]
Many thanks for your help.
John.
====
This e-mail is intended solely for the addressee. It may contain
private and
confidential information. If you are not the intended addressee,
please take
no action based on it nor show a copy to anyone. Please reply to this
e-mail
to highlight the error. You should also be aware that all electronic
mail
from, to, or within Northumbria University may be the subject of a
request
under the Freedom of Information Act 2000 and related legislation, and
therefore may be required to be disclosed to third parties.
This e-mail and attachments have been scanned for viruses prior to
leaving
Northumbria University. Northumbria University will not be liable for
any
losses as a result of any viruses being passed on.
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/198 - Release Date: 12/12/2005
Hello,
I would propose :
Creates a stand alone explorer like utility.
Left pane a tree view showing table, views and indexes.
Right pane, a tab control where each opened table will be displayed.
In the tree view, a context menu to open a table, create a new table,
create an index, a view, drop a table and so on.
In the right pane use a virtual ListView control to show the data.
A shell like control to enter direct sql commands.
A form editor to defines editing mask (saved in xml of course and in a
"system table").
A small scripting language (lua ?) to create user defined commands.
There must be dialog boxes or wizard to help the creation of table, and
data query.
There must be facilities to import and export data in various format.
Utility must be stand alone, does not depends on any runtime besides sqlite.
Must be cross platform, so use wxwindows, or qt, and run on a PDA.
Must be open source, BSD licensed or public domain so that I can steal it.
Anything else ?
Regards
--
Noël Frankinet
Gistek Software SA
http://www.gistek.net
