Post DB
Liste des Groupes
Revenir à s readers
Sujet :
Post DB
De :
ram (at) *nospam* zedat.fu-berlin.de (Stefan Ram)
Groupes :
news.software.readers
Date :
09. Sep 2024, 12:44:36
Autres entêtes
Organisation :
Stefan Ram
Message-ID :
<database-20240909114248@ram.dialup.fu-berlin.de>
I'm not 100% sure I'm barking up the right tree (newsgroup) here,
but whatever.
So, yesterday I was chewing the fat about how to whip up a database
for posts retrieved from newsservers.
I'm picturing some program that pulls newsgroups from newsservers
and dumps them into a database.
In my mind's eye, a post looks something like this, give or take:
Path: A
Message-ID: B
Body: C
. But if you snag the same post from a different server, it might
look like this:
Message-ID: B
Path: D
Body: C
. At first blush, you'd end up with the same body stored multiple
times in the database. Talk about a waste of space!
To trim the fat, we could rejigger these posts so all the variable
stuff is up front:
Path: A
Message-ID: B
Body: C
and
Path: D
Message-ID: B
Body: C
Now the tail end of both posts is identical, so we can toss that
in a separate table at position 0.
The posts themselves would then just contain the different parts
and a pointer to the shared bit that's only stored once:
Path: A
Rest: 0
Path: D
Rest: 0
0:
Message-ID: B
Body: C
. This way, you could store the same post from multiple newsservers
without eating up your hard drive space like it's In-N-Out fries.
Date
Sujet
#
Auteur
9 Sep 24
Post DB
3
Stefan Ram
10 Sep 24
Re: Post DB
1
D
10 Sep 24
Re: Post DB
1
D
Haut de la page
Les messages affichés proviennent d'
usenet
.
NewsPortal