From derby-user-return-3449-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu Feb 02 21:01:52 2006 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 9104 invoked from network); 2 Feb 2006 21:01:52 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 2 Feb 2006 21:01:52 -0000 Received: (qmail 16807 invoked by uid 500); 2 Feb 2006 21:01:50 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 16781 invoked by uid 500); 2 Feb 2006 21:01:50 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 16770 invoked by uid 99); 2 Feb 2006 21:01:50 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2006 13:01:50 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [209.217.94.68] (HELO klocwork.com) (209.217.94.68) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Feb 2006 13:01:47 -0800 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: [WWD] Feedback requested on a new document proposal Date: Thu, 2 Feb 2006 15:59:55 -0500 Message-ID: <163F7F1E1F71E343991916E5E3E0277F014286B4@server06.klocwork.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [WWD] Feedback requested on a new document proposal Thread-Index: AcYoNVF63F5zorv1REOQYFcHxhIk1QAA/vrg From: "Ian Leslie" To: "Derby Discussion" X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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:Stan.Bradbury@gmail.com]=20 https://issues.apache.org/jira/browse/DERBY-913. The proposed name is=20 "Working With Derby" and I'd like to include it with the next release. =20 The document would target new Derby users.