使用 GMail 作为我的数据库的接口
如果我选择在我的数据库上使用 GMail 出色的邮件存档搜索功能会怎么样?如果对于我的数据库负责的每笔交易,我都将该交易的详细信息通过电子邮件发送到一个仅用于搜索和检索交易的 GMail 地址,该怎么办?
任何登录该帐户的人都可以根据标签、发票号码、客户姓名进行搜索——无论使用谷歌的搜索引擎。结果以“电子邮件”的形式呈现。
想象一下,使用标准(基于网络)GMail 帐户的用户通过 GMail 的搜索框搜索发票编号 - 他返回了数据库执行包含该唯一编号的任何操作的所有实例。打开任何这些“电子邮件”都会包含交易时的静态文本(历史和跟踪黄金),但也可以携带一个小工具,可以将“消息”转换为编辑器,以便执行新交易在那张发票上。
进一步想象一下,我不是第一个想到这个的人 - 因为我肯定不是 - 即使我是,我也没有足够聪明来单独执行这个想法。
您知道类似的努力吗?
thx
[?属于超级用户?]
What if I choose to use GMail's awesome mail archive search capabilities on my database? What if, for every transaction that my database is responsible, I emailed details of that transaction to a GMail address that exists for the sole purpose of searching and retrieving transactions.
Anyone logged into that account could search according to labels, invoice numbers, customer names - whatever using Google's search engine. The results are presented as 'email messages'.
Imagine a user working from the standard (web-based) GMail account searches for an invoice number via GMail's search box - he's returned all instances where the db did anything that included that unique number. Opening any of these 'email messages' would have the static text text included at the time of the transactions (historical and tracking gold) but could also carry a Gadget that could transform the 'message' into an editor so as to execute a new transaction on that invoice.
Imagine further that I wasn't the first one to think of this - cuz surely i'm not - and even if i were, i'm not smart enough to execute the idea alone.
Are you aware of efforts similar to this?
thx
[?belongs on superuser instead?]
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
这是一个有趣的想法,但是考虑到您的搜索参数,它可能不可靠。虽然 gmail 的搜索很棒,但我在搜索部分术语时发现了问题。举个例子,我有一封主题行是“stuffas”的电子邮件。当我搜索“stuffa”时,我没有得到任何结果,当我搜索“stuffa”时,我在搜索结果中收到了电子邮件。此外,我还有一封电子邮件,正文中有一个 8 位数的号码。当我搜索 8 位数字中的 7 位时,没有得到任何结果,但是当我输入所有 8 位数字时,该电子邮件出现在结果中。因此,Gmail 中的搜索解决方案可能没有您想象的那么强大。这又是我的经验,我很想听听是否有人能够在 Gmail 中部分搜索号码。
An interesting idea, however given your search parameters it might be unreliable. Although gmail's search is great, I have found issues when searching for partial terms. Case in point, I had an email whose subject line was "stuffas". When I searched for "stuffa" I got no results, when I searched for "stuffas" I got the email in the search result. Additionally, I had an email with an 8 digit number inside the body. When I searched for 7 digits out of 8, I got no results, but when I put all 8 digits, the email appeared in the results. So, search in gmail may not be as powerful of a solution as you think. Again this is my experience, I'd love to hear if someone is able to partial search numbers in gmail.
我也有同样的想法;比你晚4年。从任何生产意义上来说,这看起来仍然“以前没有做过”。但现在已经是 2014 年了,我真的不明白为什么不这么做。用于与 gmail 连接的 Python 包已经存在并且使用起来非常简单。将其转变为通用的键值存储不需要大量的抽象。
它可能不是最快的数据库,也不是解决所有问题的最佳解决方案;但作为一个易于使用、易于搜索、配置简单、100% 正常运行时间、云存储和备份、免费的啤酒数据库,据我所知,它相当史诗般。
其他人以前见过这样的例子吗?
编辑:再想一想,有几个答案可以解释为什么这是一个坏主意:
I just had the same idea; 4 years after you. It still doesn't look like this has 'been done before' in any production sense. But now in 2014, I really don't see why not. Python packages for interfacing with gmail are already there and dead-simple to use. It does not take a whole lot of abstraction to turn this into a generalized key-value storage.
Its probably not exactly the fastest database, and not the best solution for everything; but as an easy-to-use, easy to search, trivial to configure, 100% uptime, cloud stored and backed up, free-as-in-beer database, its pretty epic as far as I can see.
Anyone else has seen examples of this having been done before?
Edit: having thought about it some more, there are several answers as to why this is a bad idea: