Re: [sqlite] cross compiling sqlite

I use openwrt and build sqlite for arm and mips, no propblems. Just pick the right target in the build system. On Wed, March 6, 2013 10:00 pm, bkk wrote: > How to create testfixture that could run on arm ? > ___ sqlite-users mailing list

Re: [sqlite] SQLite and integer division 1/2=0

Simon Slavin wrote: On 12 May 2013, at 11:07am, Paul van Helden wrote: SELECT 1/2 returns 0 which to me is a little odd, but I see from this page: http://www.sqlite.org/sqllogictest/wiki?name=Differences+Between+Engines that most other engines do the same. A

Re: [sqlite] R*Tree constraint error when inserting valid data

Tobias Kolb wrote: Hi, I'm currently experimenting with the R*Tree support in SQLite. I have to collect some log data over a timespan and save it linked to the area (not the exact path, just a minimum bounding rect around) it was collected (min/max latitude and min/max longitude). Based on this

[sqlite] Newbie Sqlite questions

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,

Re: [sqlite] Newbie Sqlite questions

Igor Tandetnik wrote: On 3/21/2012 9:33 PM, Yan Seiner wrote: 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. http://www.sqlite.org/quickstart.html T

[sqlite] Geolocation database

I've been playing around with a geo-location database. I have a camera mounted on our travel van. Periodically, it takes pictures of where we are. I've written (OK, mostly re-written) various code I've found to tag the pics with location, lat/lon, date, time, direction, speed, and outside