On Wed, Sep 19, 2012 at 12:51 PM, joe.fis...@tanguaylab.com <joe.fis...@tanguaylab.com> wrote: > Too bad SQLite doesn't yet support SQL Window Functions. > > Are there any SQLite Extension Libraries that support "SQL:2003 type Window > Functions"? > I specifically need LEAD and LAG to calculate an event integer timestamp > delta between consecutive rows. > I've played with some self-join code but that's proving to be complicated. >
SQL Window Functions is the number one feature that I could use as well. In R, sqlite can be used for manipulating R data frames via the sqldf package and this sort of functionality would be very useful. (sqldf also handles PostgreSQL which does have windowing functions but PostgreSQL requires more set up than sqlite so its not as accessible to users.) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users