ok, ok, I stand corrected. I was a little harsh. But you first need to
look at current offerings out there like sqlite3explorer, sqlitespy,
to name a few.
Here's my $0.02:
10 things I would like in a Sqlite GUI:
1. Cross platform (C/C++ based, not Delphi)
2. Open source
3. 100% sqlite3 command line exe compatibility
4. Plug-in capable (for user-defined functions/collations)
5. Query management (save/load typed-in queries)
6. XML export (wizard?)
7. Visual data definition tools (create tables, columns, etc. without
typing SQL)
8. Visual performance aids like a user-friendly display of EXPLAIN output.
9. "Lite" in the same spirit as sqlite itself. Make it fit completely
in a 1.44 diskette or less.
10. QBE "and" the usual SQL window on top, results on bottom grid
interface (prereably tabbed) of what it created.
Good luck with your project!
jp.
John Newby wrote:
P.S. I can't start to build it until I have done the analysis of what I am
trying to build, that is why I am asking what people would like out of a
GUI.
John.
