3D+嵌入式空间数据库选项
我们正在开发一个必须在边界框中查询 3D 形状（以及基于其他参数的查询）的应用程序。形状的数量超出了我想要保留在内存中的数量，因此我需要一个数据库来处理它。
具体来说，我们的主要操作是插入和查询。我们从不修改现有数据。
因为它是一个桌面应用程序，所以我试图避免 PostgreSQL 和 MySQL 单独的服务器类型，希望部署更简单。我找到了 Spatialite，但它没有在第三维上建立索引，所以它不起作用。
我尝试搜索 kd-tree 数据库，但尚未找到任何内容。我知道有 kd-tree 实现，但是以数据库形式获取它需要花费很多精力来推出我们自己的，所以我试图看看是否已经有一些东西。
该应用程序是用 Haskell 编写的，但如果我们必须与其他语言集成，我们可能会处理这个问题。
We're developing an application that has to query 3D shapes (and query based on other parameters as well) within a bounding box. The number of shapes is more than I want to keep in memory, so I need a database to handle it.
Specifically, our primary operations are inserts and queries. We never modify existing data.
Because it's a desktop application, I'm trying to avoid the PostgreSQL and MySQL separate server types of things, hoping for something more simple for deployment. I found Spatialite but it does not index on the 3rd dimension, so it won't work.
I tried searching for kd-tree database but haven't found anything yet. I know there are kd-tree implementations, but getting it in database form would take a lot of effort to roll our own, so I'm trying to see if there is something already out there.
The application is in Haskell, but if we have to integrate with some other language, we might deal with that.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
SQLite R*Tree
SQLite R*Trees
我会恭敬地挑战您避免使用 PostgreSQL/MySQL 的尝试。我在 PostgreSQL 方面经验丰富，它可以完成您想要的工作，而且管理起来并不困难。当然，您发现的其他任何东西都不会达到 PostgreSQL 的开发和测试水平 - 那么为什么还要麻烦呢？
I would respectfully challenge your attempt to avoid PostgreSQL/MySQL. I'm experienced in PostgreSQL and it does the job you want and it is not difficult to administer. Certainly, anything else you find is not going to have the level of development and testing PostgreSQL does - so why bother?