[HPFGU-Catalogue] Re: Welcome and questions on Stage One

[silmariel]

> Carolyn:
>
> From what you are saying, I gather we could make an immediate start
> using the Excel cut and paste approach that I suggested, and you can
> incorporate any work done that way into the final database ?

Yes.

> But are you also saying that (with cooperation from Paul Kippes) you
> could also immediately create a mysql database that we could all
> access and work on directly ? 

No. I said it can be accesed remotely, but one has to be very brave, because 
it is a database session, so you have to work probably in a text console and 
using SQL (Simple Query Language to friends). That means the resources are 
there but one needs to be a guru, Gryffindor, or used enough to work with 
databases.

I said I would look for a graphic client user-friendly but I have no clue if 
it exists. I'll post the question to a programmer's forum.

>And would this database contain all the text of the posts, or just the title 
index ?

The index, I've sent the structure of the database, that later can be expanded 
to include posts.

Raw posts include a lot of information, and I won't go into them yet, I'd 
prefer to talk about them with Paul. An example heading for a post:

-------------------------------------------

Return-Path: 
<sentto-12099707-0-1077562730-silmariel=telefonica.net at returns.groups.yahoo.com>
Received: from telesmtp2.mail.isp ([10.20.4.62]) by
          mb120.terra.es (terra.es) with ESMTP id HTJWQ801.HWA for
          <silmariel at telefonica.net>; Mon, 23 Feb 2004 19:58:56 +0100 
Received: from n10.grp.scd.yahoo.com ([66.218.66.65]) by
          telesmtp2.mail.isp (terra.es) with SMTP id HTJWQ700.ORL for
          <silmariel at telefonica.net>; Mon, 23 Feb 2004 19:58:55 +0100 
X-eGroups-Return: 
sentto-12099707-0-1077562730-silmariel=telefonica.net at returns.groups.yahoo.com
Received: from [66.218.67.198] by n10.grp.scd.yahoo.com with NNFMP; 23 Feb 
2004 18:58:50 -0000
X-Sender: carolynwhite2 at aol.com
X-Apparently-To: HPFGU-Catalogue at yahoogroups.com
Received: (qmail 48121 invoked from network); 23 Feb 2004 18:58:49 -0000
Received: from unknown (66.218.66.166)
  by m5.grp.scd.yahoo.com with QMQP; 23 Feb 2004 18:58:49 -0000
Received: from unknown (HELO n37.grp.scd.yahoo.com) (66.218.66.105)
  by mta5.grp.scd.yahoo.com with SMTP; 23 Feb 2004 18:58:49 -0000
Received: from [66.218.67.147] by n37.grp.scd.yahoo.com with NNFMP; 23 Feb 
2004 18:57:43 -0000
To: HPFGU-Catalogue at yahoogroups.com
Message-ID: <c1dif7+3e15 at eGroups.com>
User-Agent: eGroups-EW/0.82
X-Mailer: Yahoo Groups Message Poster
X-eGroups-Remote-IP: 66.218.66.105
From: "a_reader2003" <carolynwhite2 at aol.com>
X-Originating-IP: 195.93.33.12
X-Yahoo-Profile: a_reader2003
MIME-Version: 1.0
Mailing-List: list HPFGU-Catalogue at yahoogroups.com; contact 
HPFGU-Catalogue-owner at yahoogroups.com
Delivered-To: mailing list HPFGU-Catalogue at yahoogroups.com
Precedence: bulk
List-Unsubscribe: <mailto:HPFGU-Catalogue-unsubscribe at yahoogroups.com>
Date: Mon, 23 Feb 2004 18:57:42 -0000
Subject: [HPFGU-Catalogue] Welcome and questions on Stage One
Reply-To: HPFGU-Catalogue at yahoogroups.com
Content-Type: text/plain;
  charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Status: R 
X-Status: N

--------------------------------------------

There is info in here that may be useful and I'd like to study it.

> I am slightly confused, as I understood from our previous emails that
> doing that might take a little time to set up, especially writing the
> programme to access it directly from a website.

Making a program to manage a database from a web page does take more time, but 
just granting access to remote users to a database is a matter of minutes. 
Replicating the database could take a day because we have to work in two 
places at once. 

> Sorry for stupid questions...also, we should probably discuss with
> the admin team where the database should live, long term, ie what
> server. I guess you won't want to host it yourself indefinitely !

No, really. Expect a lot of misunderstandings here. The normal operation would 
be to talk during hours or days, and by mail is more difficult.  

Carolina