[sqlite] Filling struct Select in sqlite

Hi, Instead of generating an sql query for a select statement, I would like to bypass the parser and fill in struct Select by myself based on the data I have and Pass it to sqlite3Select() function. Can you please give me some pointers in this direction ? I think eliminating parsing would be an o

Re: [sqlite] Curious datetime/strftime BUG?

Sorry Clemens, but you have missed the point, the point being that the year component of the date string returned by strftime for -ve (or BCE) years are truncated to the -ve sign + the first three digits of the year. This is not the case for the result returned by date or datetime, which retu

Re: [sqlite] Vdbe Program Generation

Thanks a lot Clemens Regards Prakash On Sun, Oct 5, 2014 at 2:56 PM, Clemens Ladisch wrote: > Prakash Premkumar wrote: > > On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt wrote: > >> On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar > >> wrote: > >> > >>> Can you please tell me which function is

Re: [sqlite] Behavior change: INTEGER PRIMARY KEY and PRAGMA index_list

Paul Quinn wrote: > In 3.7, issuing "PRAGMA index_list(tablename)" to retrieve the details > of an index, sqlite3_column_count() would return 0 for automatic > integer primary key indexes, basically indicating there was no > explicit index created for that tablename. But in 3.8, > sqlite3_column_co

Re: [sqlite] Memory Usage

David Muchene wrote: > I was wondering what options I can tune to make sqlite use more memory. You did not mention PRAGMA cache_size, so I guess you are not using it? Regards, Clemens ___ sqlite-use

Re: [sqlite] Curious datetime/strftime BUG?

John wrote: > -4713-11-25 12:00:00<-- 4 digit year > -471-11-25 12:00:00 <-- 3 digit year > -001-12-31 <-- 3 digit year > -001-12-31 <-- 3 digit year > -1975-10-21<-- 4 digit year > -197-10-21 <-- 3 digit year The documentation say

Re: [sqlite] Vdbe Program Generation

Prakash Premkumar wrote: > On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt wrote: >> On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar >> wrote: >> >>> Can you please tell me which function is >>> sqlite actually generates the Vdbe >>> program for a give sql string ? >> >> http://www.sqlite.org/c3re

Re: [sqlite] libsqlfs - a file system in a SQLite database

Looks interesting. I have just cloned it locally. On Sat, Oct 4, 2014 at 12:49 PM, Simon Slavin wrote: > > > "The libsqlfs library implements a POSIX style file system on top of an > SQLite database. It allows applications to have access to a full >

Re: [sqlite] Vdbe Program Generation

Thanks a lot for your reply Kees, sqlite3_prepare calls other functions, can you kindly tell me which is the exact function that does the conversion ? Thanks Prakash On Fri, Oct 3, 2014 at 7:37 PM, Kees Nuyt wrote: > On Fri, 3 Oct 2014 18:39:29 +0530, Prakash Premkumar > wrote: > > > Can you p

[sqlite] Curious datetime/strftime BUG?

A week or so ago, someone posted about datetime(1) results not being the same as strftime("%Y-%m-%d %H:%M:%S",1) (sorry I have deleted OP msg) as per documentation. With: sqlite> .ver SQLite 3.7.13 2012-07-17 17:46:21 Of coarse, this may not apply to later versions. sqlite> select datetime