地理空间应用程序：mySql、CouchDB 与其他
我正在谷歌地图上开发一个应用程序，并检查在边界框中存储和检索空间信息的各种选项。
最初我认为 MySql 不是一个好的选择，但检查后 http://dev.mysql.com/doc/refman/5.6/en/spatial-analysis-functions.html 和 http://code.google.com/apis/maps/articles/phpsqlsearch.html，看起来我可以使用 MySql 并且它确实支持我的用例。
我还在评估node.js和couchdb与geocouch..对于socket.io、geo等模块，看起来这也是一个不错的选择。查看《GEO、CouchDB 和 Node.js 入门》一书。我的应用程序将是一页应用程序，我无法预见将来是否需要 RDBMS。
我也看到了这个 - http://nodeguide.com/convincing_the_boss.html 这让我有点担心关于是否使用node.js-geocouch......
如果您的下一个应用程序的架构读起来像食谱 NoSQL 成分，请暂停一下并阅读本文。
是的，Redis、CouchDB、MongoDB、Riak、Casandra 等看起来都很真实 诱人，但那个红苹果夏娃也无法抗拒。如果你是 使用 Node.js 已经承担了技术风险，你不应该 将其与更多您可能不完全理解的技术相乘 还没有。
当然，选择面向文档的方法有合法的用例 数据库。但如果您想在自己的基础上开展业务 软件，坚持保守的数据库技术（如 postgres 或 mysql）可能会超过满足你内心的好处 书呆子并给你的朋友留下深刻印象。
你的意见是什么？
I am developing an application on google map and checking out various options to store and retrieve spatial information within a bounding box.
Initially I thought MySql was not a good option, but after checking http://dev.mysql.com/doc/refman/5.6/en/spatial-analysis-functions.html and http://code.google.com/apis/maps/articles/phpsqlsearch.html, looks like I can use MySql and it does support my use cases.
I was also evaluating node.js and couchdb with geocouch.. With modules like socket.io, geo etc looks like this is also a good choice. check out the book "Getting Started with GEO, CouchDB, and Node.js". My application would be 1 page application and I do not foresee if I would require rdbms anytime in future.
i have also seen this - http://nodeguide.com/convincing_the_boss.html and this makes me little apprehensive about whether to go with node.js-geocouch....
If the architecture for your next apps reads like the cookbook of
NoSQL ingredients, please pause for a second and read this.Yes, Redis, CouchDB, MongoDB, Riak, Casandra, etc. all look really
tempting, but so did that red apple Eve couldn't resist. If you're
already taking a technological risk with using node.js, you shouldn't
multiply it with more technology you probably don't fully understand
yet.Sure, there are legitimate use cases for choosing a document oriented
database. But if you are trying to build a business on top of your
software, sticking to conservative database technology (like postgres
or mysql) might just outweigh the benefits of satisfying your inner
nerd and impressing your friends.
What is your opinion ?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
对于您的情况，GeoCouch 听起来是一个不错的解决方案。如果您想轻松安装，可以查看Couchbase Single Server，它基本上是一个包含 GeoCouch 的 CouchDB（查看 开发者预览版2.0。
GeoCouch sounds like a good solution in your case. If you want to have an easy installation, you can have a look at Couchbase Single Server, which is basically a CouchDB with GeoCouch included (check out the Developer Preview for 2.0.