[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Pan-devel] Move to database back-end

From: K. Haley
Subject: Re: [Pan-devel] Move to database back-end
Date: Thu, 11 Mar 2004 00:47:11 -0700
User-agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.6) Gecko/20040113

Hi Tom,
I'm not one of the devs but I'll respond just so you know this group's not empty. My experience here has been with a couple of bug fixes and a new feature.

Tom wrote:

Basically I thought of doing the following, at last as a start:
1. Make a first cut at a database design/schema, and implement it.
Quite a while back Charles posted a possible schema on one of the lists. I used that as a starting point and came with a modified version back in august but I never posted it. If you or anyone else here is interested I can clean it up and post it. The problem is that several issues were never resolved as to how certain state info was to be tracked ie. per group or per article.

2. Write a conversion routine/utility which would read the current files
and load the database. I've been looking at the CVS tree, specifically
pan/base/file_headers.c and related files.

1. First, is this the right place to raise these questions? The list
seems to be fairly low in traffic.
This should be the right place, and you're right about it being quiet in here. I think yours is the first post I've seen this year.

2. How much of this work is already done?
Not a clue.

3. What db will be used? I thought Charles had mentioned it at some
point on pan_users, but I couldn't find it now.
The last I heard it was SQLite . It's a small embeddable database. I've been thinking about changing the article cache to use it just to see what the memory savings would be. Maybe I'll get around to it or maybe the devs will make the change first.

Attachment: signature.asc
Description: OpenPGP digital signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]