使用 GMail 作为我的数据库的接口

发布于 2024-10-05 10:07:55 字数 452 浏览 0 评论 0原文

如果我选择在我的数据库上使用 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

゛时过境迁 2024-10-12 10:07:55

这是一个有趣的想法,但是考虑到您的搜索参数,它可能不可靠。虽然 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.

好倦 2024-10-12 10:07:55

我也有同样的想法;比你晚4年。从任何生产意义上来说,这看起来仍然“以前没有做过”。但现在已经是 2014 年了,我真的不明白为什么不这么做。用于与 gmail 连接的 Python 包已经存在并且使用起来非常简单。将其转变为通用的键值存储不需要大量的抽象。

它可能不是最快的数据库,也不是解决所有问题的最佳解决方案;但作为一个易于使用、易于搜索、配置简单、100% 正常运行时间、云存储和备份、免费的啤酒数据库,据我所知,它相当史诗般。

其他人以前见过这样的例子吗?

编辑:再想一想,有几个答案可以解释为什么这是一个坏主意:

  • gmail 不允许从不同位置进行随机访问;它会阻止您的帐户。相当出色的
  • amazon simpleDB 还为您提供了一个具有相同特征的简单键值存储(加上良好的 python 支持),如果您愿意花一天的时间来了解它,那么设置起来并不是那么痛苦。而且对于您可以塞入 Gmail 帐户的流量来说,它实际上也是免费的。

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:

  • gmail does not permit random access from different locations; it will block you account. quite a showstopper
  • amazon simpleDB also gives you a simple key-value store with the same characteristics (plus good python support), and isn't THAT big of a pain to set up if you are willing to spend a day wrapping your head around it. And is also effectively free for the kind of traffic that youd be able to cram into a gmail account.
~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文