5 ms·

I wish there'd be a native e-mail client that utilized a RDBMS properly, I want a really fast full-text search, I want fast filters. The current ones have all b

I wish there'd be a native e-mail client that utilized a RDBMS properly, I want a really fast full-text search, I want fast filters. The current ones have all been very unsatisfactory, mostly because the file-based approach doesn't allow them to. It really isn't sane in my opinion.

ses1984 7y ago
"fast full text search" is something better provided by software that specializes in fast full text search. Rdbms for the email use case is kind of orthogonal to fast full text search.
- Avamander 7y ago
  A RDBMS can provide a fast full text search alongside other useful features, can you elaborate how it's orthogonal? Oh, and I also dislike even the idea that I have to find some "specialized software" to have basic functionality in my e-mail client. That's why most still suck a*.
  - ses1984 7y ago
    You probably want something that checks for similarly spelled words, maybe natural language processing, whole or partial word matching, indices on all this, etc. If all you want is to grep your email, that's different, I think you can accomplish that with pine or other text mode email clients.
  - gnaritas 7y ago
    > Oh, and I also dislike even the idea that I have to find some "specialized software" to have basic functionality in my e-mail client. No you don't, you're asking for exactly that by wanting an RDBMs for your email client. That's about as specialized as it gets.
bronson 7y ago
Have you tried notmuch? https://notmuchmail.org/ https://notmuchmail.org/ It uses a Xapian index, not an RDBMS, but it's impressive. RDBMSes aren't known for producing good natural language search results.
- Avamander 7y ago
  I have not, I am tempted however, I really dislike the power Google has over me.
jakeogh 7y ago
O ya, you want alot:) links in my stack: https://github.com/jakeogh/gpgmda-client https://github.com/jakeogh/gpgmda-client

ses1984 7y ago

"fast full text search" is something better provided by software that specializes in fast full text search. Rdbms for the email use case is kind of orthogonal to fast full text search.

Avamander 7y ago
A RDBMS can provide a fast full text search alongside other useful features, can you elaborate how it's orthogonal? Oh, and I also dislike even the idea that I have to find some "specialized software" to have basic functionality in my e-mail client. That's why most still suck a*.
- ses1984 7y ago
  You probably want something that checks for similarly spelled words, maybe natural language processing, whole or partial word matching, indices on all this, etc. If all you want is to grep your email, that's different, I think you can accomplish that with pine or other text mode email clients.
- gnaritas 7y ago
  > Oh, and I also dislike even the idea that I have to find some "specialized software" to have basic functionality in my e-mail client. No you don't, you're asking for exactly that by wanting an RDBMs for your email client. That's about as specialized as it gets.

bronson 7y ago

Have you tried notmuch? https://notmuchmail.org/ https://notmuchmail.org/ It uses a Xapian index, not an RDBMS, but it's impressive. RDBMSes aren't known for producing good natural language search results.

Avamander 7y ago
I have not, I am tempted however, I really dislike the power Google has over me.

jakeogh 7y ago

O ya, you want alot:) links in my stack: https://github.com/jakeogh/gpgmda-client https://github.com/jakeogh/gpgmda-client