I just started playing around with sqlite3 in earnest. I have a fairly large database (several hundred thousand records) on an embedded box and sqlite does an incredible job of finding what i need very fast.

My database is as simple as it gets:

CREATE VIRTUAL TABLE latlong USING rtree( id, latmin, latmax, longmin, longmax); CREATE TABLE geodata ( id INTEGER PRIMARY KEY, name TEXT, class TEXT, state TEXT, county TEXT);

The test runs I've done show that sqlite is incredibly fast pulling out the records I need.

I need to write some C code to interface with sqlite API. I"ve been through the docs, and I'm hoping someone can point me to some very basic example code that I could build on.

Thanks!

--
Honoring our vets.

http://www.bataanmarch.com/

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to