Rajan, Vivek K wrote:
I have a need to store spatial and connectivity data (think verilog
netlist with x, y coordinate information) in a persistence on-disk file.
I am looking at different SQL-based databases and am wondering if anyone
has recommendations/opinions on how good SQLite is for:
- Storing spatial data. An examples, documentation and support links
- Performing spatial queries and indexing for very large hierarchical
data set
Please advice.
Rajan
------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.18/91 - Release Date: 6/09/2005
Hello,
I do it. I have a collection of graphical classes (line, polylines,
....) than can be saved and retrieved from sqlite. I use the 2.8. The
shape are saved as blob encoded in text. When drawing or selecting,
shapes are pulled from the Geometry column via sqlite call-back mechanism.
Shape class have a static factory method that takes the blob pulled from
db as parameter and return a well formed object.
The table schema is made from a primary key , 4 int for a bounding box,
a the geometry blob.
I try now to make a spatial index (quadtree or rtree) but I already have
good performance by selecting bounding box.
Best wishes
--
Noël Frankinet
Gistek Software SA
http://www.gistek.net