List Info

Thread: Direct access to database




Direct access to database
user name
2006-05-31 09:43:57
Hi, I'm a new user of Spambayes.
As a linguist, I find it very exciting. The interface of the
pop-server version actually shows me
the "spamminess" of each word I ask for; wow!
However - being thus enticed, I want more. I would like to
directly see the spambayes database; for
instance to see a listing of words; to pick out the most
spammy as well as the most hammy terms,
etc. Is there a way to do that? Is there, for instance, an
odbc driver available somewhere? Or is
it even possible to use a different database system?
Or did I miss something and can it even be done with the
spambayes program itself?
Hans




_______________________________________________
SpamBayespython.org
htt
p://mail.python.org/mailman/listinfo/spambayes
Check the FAQ before asking: http://spambayes.sf.
net/faq.html
Direct access to database
user name
2006-05-31 22:17:58
> I would like to directly see the spambayes database;
for
> instance to see a listing of words; to pick out the
most spammy as  
> well as the most hammy terms,
> etc. Is there a way to do that?

Yes.  If you install Python <http://python.org/down
load> and download  
the SpamBayes source, you can use sb_dbexpimp.py to convert
the  
database to a CSV file (and then view it in Excel, or
whatever you  
like).

The command you'll want to run will be something like:

C:\location\of\spambayes\source>scripts\sb_dbexpimp.
py -f tokens.csv -e

> Is there, for instance, an odbc driver available
somewhere? Or is
> it even possible to use a different database system?

The possible storage options are:

  * A Python pickle.

  * Any of the Python dbm databases (e.g. BSDDB)

  * ZODB

  * ZEO

  * CDB

  * MySQL

  * postgresql

=Tony.Meyer

-- 
Please always include the list (spambayes at python.org) in
your replies
(reply-all), and please don't send me personal mail about
SpamBayes.
http://www.massey.ac.nz/~tameyer/writing/reply_all.html explains this.


_______________________________________________
SpamBayespython.org
htt
p://mail.python.org/mailman/listinfo/spambayes
Check the FAQ before asking: http://spambayes.sf.
net/faq.html
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )