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

[K. Haley]

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.
>
> Questions:
> 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   http://www.sqlite.org  .  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.

signature.asc
Description: OpenPGP digital signature