Hi, Very cool!
I would like to know a bit more about the use case. How large are those files? Do they need to be updated or are they just read-only? If the files could be imported, I would probably try to go in this direction (possibly combined with export). Regards, Thomas On Wed, Jul 24, 2013 at 12:02 PM, Noel Grandin <[email protected]<javascript:_e({}, 'cvml', '[email protected]');> > wrote: > > 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] <javascript:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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.
