3D option + integrated spatial database

We are developing an application that should request 3D forms (and a request based on other parameters) in a bounding box. The number of figures is more than I want to store in memory, so I need a database to process it.

In particular, our core operations are inserts and queries. We never modify existing data.

Since this is a desktop application, I try to avoid the different types of PostgreSQL and MySQL servers, hoping for something simpler to deploy. I found Spatialite, but it is not indexed in the third dimension, so it will not work.

I tried to find the kd-tree database but haven't found anything yet. I know that there is an implementation of kd-tree, but getting it in the form of a database will require a lot of effort to collapse our own, so I'm trying to see if there is something already there.

The application is in Haskell, but if we need to integrate with another language, we can deal with this.

+3
source share
2 answers

SQLite R * Trees

Given a query rectangle, R-Tree can quickly find all records that are contained in a query rectangle or that overlap a query rectangle. This idea easily extends to three dimensions for use in CAD systems.

+2
source

PostgreSQL/MySQL. PostgreSQL, , , . , , , PostgreSQL - ?

-1

All Articles