Re: [pilot-db-list] Is there a todo list / has anyone looked 'stealing code?'

[Tom D. <td...@vg...>]

On Sun, 6 Feb 2000, Robert Alatalo wrote:

> 	I didn't see any TODO or future plans and I would hate to see this
> project stagnate.  I am rusty with my C but downloaded some development
> tools and hope to brush up, so this isn't only I want someone else to do
> it post.  In any case, here is what I would like to see eventually
> implemented.

There is a TODO list in the top of the source tree. It is in the file
called "TODO". :)

> 	True relations with foreign keys linking to Primary keys.

This would probably end up as just linking to a column in another
database.

> 	Few more data types added.

This should be in the TODO file.

> 	Nulls and a subset of SQL added

The ability to have a 'null' or blank file would be okay. SQL would be
overkill for DB since it is more of a frontend than a backend. I don't see
a user entering SQL statements on the Palm Pilot.

> 	Transactions ( with commit and rollback ability )

Why would this be needed? DB is not running any sort of SQL or scripting
language that needs to support undoing any sort of changes.

> 	eventually functions and constraints
> 
> for growth.  So, maybe we have have a discussion about were this project
> is heading?

Sure. My only vision for the project is to see it become a useful
frontend for databases which store records with fields on PalmOS. I don't
see it as a full SQL style database system on the Palm Pilot. It would be
neat though if we had a conduit which interfaced DB with a SQL system on
the desktop.

The latest source tree is always availabe via anonymous CVS on the
SourceForge site. Current work is: 

* Flicker-free, fast list view (via my grid widget) [TESTING]
* Configurable list view [list view can use varying column definition,
still working on the editor for column definitions]
* New format for the app info block to be extensible [DONE, TESTED]

0.3.0 will be released once the list view stuff stabilizes. Also, DB has
been changed to use prc-tools 0.5.1b5 or higher. Instructions on what is
needed to build DB is now present in the db/docs/building.txt file in CVS. 

After 0.3.0, I'll tackle sorting and filters.

Tom