I like the proposal.  I personally found the Derby documentation pretty
good and I get started quite well but I think with this document things
would have been even smoother.

Speaking of my experience I would have found Module 1, 2 and 4 to be
what I was looking for (note I am not suggesting the others are not
important - just thinking about my initial goals).  Based on the next
things I searched out information on I suggest the following additional
modules:

1) A module showing a more complex example of inserting data.  Introduce
the notion of temporary tables and show how they can be used to hold
simple data so that a more complex insert can be performed to populate a
database.  I am thinking here of something with a normalized set of
tables and how to insert data such that the ids of one table join with
another.  As someone with little SQL or database experience, creating
and populating the schema for my data was challenging (I have a friend
who helped design a good schema - but I was thinking that more advanced
database example would help us novices a lot).  I had to fall back on my
friend again for the SQL to perform the loading because the insert
examples I read in the documentation were all very simple.

2) A module showing how to use update.  I have discovered that each
database uses update slightly differently.  Some non trivial examples of
update (perhaps with the more advanced database idea above) would be
helpful.

3) A module showing how to produce and then connect to a read only
database.  Same thing in a .jar'ed database.  The documentation has a
good recipe at the moment but a step by step example to build on would
be even better.

I think the modules you have already will be very interesting I simply
wanted to suggest you add a few more.

Thanks,

Ian

-----Original Message-----
From: Stanley Bradbury [mailto:[EMAIL PROTECTED] 
<snip>
https://issues.apache.org/jira/browse/DERBY-913.  The proposed name is 
"Working With Derby" and I'd like to include it with the next release.  
The document would target new Derby users.
<snip>

Reply via email to