On 2013-07-24 11:39, Nicolas Fortin (OrbisGIS) wrote:
I'm using the H2 Api in order to add a TableEngine linked with .dbf files and .shp files <http://fr.wikipedia.org/wiki/Shapefile> .

The dbf TableEngine is here
https://github.com/nicolas-f/H2GIS/tree/shapeDriver/h2drivers/src/main/java/org/h2gis/drivers/dbf

Currently it is a read only table engine. It uses the table engine parameters written by Noel. It is able to read several dbf encoding, I wrote a unit test with Chinese DBF.

Very very nice. Good work!


I am currently looking for index creation. May be there is a way to use the PageBtreeIndex, but I not overload RegularTable.


I don't think that's going to work very well, PageBtreeIndex is very much designed to index things that are contained inside our own files. You could, on the other hand, probably use TreeIndex, because that is purely an in-memory index.

Otherwise I suggest that you build an importer i.e. something that can read DBF files into H2, like:
http://h2database.com/html/functions.html#csvread

Which you could build using user-defined functions e.g. see the section called "Functions Returning a Result Set"
http://h2database.com/html/features.html#user_defined_functions

Regards, Noel

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to