Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#27 MySQL support

open
nobody
None
1
2004-11-30
2004-11-22
B. Wright
No

Is there any initiative to support MySQL in the future?
Bogofilter would be a lot more flexible were it to
support a database like MySQL or other networkable
relational database. This would also allow for better
database management as well as better tools were the
database to get corrupted. In addition, it would offer
better access controls. I know this is a pretty big
feature request, but I think it would make Bogofilter a
lot more flexible of a product.

This isn't to say that BerkeleyDB is a bad database
product. It isn't. But, it also doesn't have many of
the features that a database like MySQL has. Plus, you
can't move BerkeleyDB files around. You always have to
export and then import to recreate BDB files. With
MySQL, you can replicate the data or simply copy the
files (if using ISAM or InnoDB tables).

Of course, MySQL does support BDB tables within it. Of
course, you still have to know/use SQL statements to
get to the data.

Thanks.

Discussion

    • priority: 5 --> 1
     
  • Logged In: YES
    user_id=2788

    I wonder how much of a performance hit we'd get through IPC
    alone, let alone SQL parsing.

     
  • David Relson
    David Relson
    2004-11-30

    Logged In: YES
    user_id=30510

    Nope. No plans at our end. Bogofilter's design has a
    database independent level, in files datastore.h and
    datastore.c, which is currently used to support 3 databases
    - Berkeley DB, qdbm, and tdb.
    If you want to write a datastore_mysql module, go for it!

    David