On Sun, Jun 22, 2008 at 10:46:28AM +0900, Joel VanderWerf wrote: > Jeremy Hinegardner wrote: >> Also, eventually I'm going to expose two SQLite extensions, full text >> search and R-trees. I'm sure everyone knows what full text search is >> for, and the R-tree extension allows for extremely fast spatial >> searching, i.e. latitude, longitude. > > You mean like postgis, but in a sqlite sized package? That would be very, > very cool. I didn't know sqlite even had such an extension. Yup, its in the source tree but not part of the released version of SQLite yet. http://www.sqlite.org/cvstrac/dir?d=sqlite%2Fext%2Frtree I'm guessing it'll be in the next official release. enjoy, -jeremy -- ======================================================================== Jeremy Hinegardner jeremy / hinegardner.org