[sqlite] 64bit DLL vs 32bit

2016-05-12 Thread dandl
> bounces at mailinglists.sqlite.org] On Behalf Of Simon Slavin > There must be a Windows element in there, though. On the Mac I can create a > create a project in Xcode which has C, C++, Objective-C, Java and Python code > in (probably other languages too) and they can all call functions in

[sqlite] sqlite3_auto_extension + custom FTS5 tokenizer

2016-05-12 Thread Dan Kennedy
On 05/11/2016 05:24 PM, Jan Berkel wrote: > I?m currently implementing a custom FTS5 tokenizer which I?d like to > automatically register for each db connection. > > So I tried to register an extension hook with sqlite3_auto_extension but when > my code is called the FTS_* modules have not been

[sqlite] Summing values by date, returning 0 for missing dates

2016-05-12 Thread Jonathan
Hi List, Let's say I have a table with a simplified structure like this: /create table my_table(// //time_date DATE,// //num INTEGER// //);/ My data has three rows and looks like this: /2016-01-01; 3// //2016-01-01; 1// //2016-01-03; 2/ I want

[sqlite] Summing values by date, returning 0 for missing dates

2016-05-12 Thread Simon Slavin
On 11 May 2016, at 11:20pm, Jonathan wrote: > //time_date DATE,// SQLite has no DATE type. Put your data in that table and try this command: SELECT time_date,typeof(time_date) FROM my_table Then try it again, this time defining that column as TEXT. Simon.

[sqlite] Summing values by date, returning 0 for missing dates

2016-05-12 Thread R Smith
On 2016/05/12 12:20 AM, Jonathan wrote: > Hi List, > Let's say I have a table with a simplified structure like this: > /create table my_table(// > //time_date DATE,// > //num INTEGER// > //);/ > > My data has three rows and looks like this: > /2016-01-01; 3//

[sqlite] Summing values by date, returning 0 for missing dates

2016-05-12 Thread R Smith
I should add... The initial CTE setting up minDT and maxDT can be ANY dates, it doesn't have to come from the MIN/MAX in my_table, for example: WITH dtRange(minDT,maxDT) AS ( SELECT '2015-12-30 00:00:00', datetime(date('now','localtime','-3 months')) -- 30 December 2015 to today 3

[sqlite] Sqlite incompatibility with Postgres

2016-05-12 Thread dandl
It's a minor point, but can someone confirm that: Postgres accepts (but Sqlite does not) LIMIT ALL LIMIT ALL OFFSET nnn OFFSET nnn Sqlite accepts (but Postgres does not): LIMIT -1 OFFSET nnn LIMIT -1 These all have the same meaning of no limit, but there is no common ground in the syntax.

[sqlite] SQLite custom function for regular expression using c/c++

2016-05-12 Thread Bhagwat Balshetwar
Hi, Can you provide me link of PCRE support for SQLite. I need to install it on Linux RHEL ES Release 4 with i686. -Bhagwat On Mon, May 9, 2016 at 6:18 PM, Chris Brody wrote: > On Mon, May 9, 2016 at 2:20 PM, Richard Hipp wrote: > > On 5/9/16, Chris Brody wrote: > >> On Wed, May 4, 2016

[sqlite] SQLite custom function for regular expression using c/c++

2016-05-12 Thread Warren Young
On May 12, 2016, at 7:36 AM, Bhagwat Balshetwar wrote: > > Can you provide me link of PCRE support for SQLite. I need to install it on > Linux RHEL ES Release 4 with i686. First Google result for ?sqlite pcre?: https://github.com/ralight/sqlite3-pcre

[sqlite] Summing values by date, returning 0 for missing dates

2016-05-12 Thread Jonathan Moules
Hi Simon, I know that the "DATE" type isn't actually a type in SQLite and that there are no date-specific constraints, but I find it a convenient indicator (to me and potentially anyone else who's going to see the code) as to the type of data that is to be held in that column. I figured

[sqlite] Sqlite incompatibility with Postgres

2016-05-12 Thread da...@dandymadeproductions.com
> It's a minor point, but can someone confirm that: > > Postgres accepts (but Sqlite does not) > LIMIT ALL > LIMIT ALL OFFSET nnn > OFFSET nnn > > Sqlite accepts (but Postgres does not): > LIMIT -1 OFFSET nnn > LIMIT -1 > > These all have the same meaning of no limit, but there is no common >

[sqlite] Sqlite incompatibility with Postgres

2016-05-12 Thread Simon Slavin
On 12 May 2016, at 11:24am, dandl wrote: > Sqlite accepts (but Postgres does not): > LIMIT -1 OFFSET nnn > LIMIT -1 > > These all have the same meaning of no limit, but there is no common ground > in the syntax. Yes and Yes. Documented behaviour. There are some strange situations if the

[sqlite] Summing values by date, returning 0 for missing dates

2016-05-12 Thread Simon Slavin
On 12 May 2016, at 3:55pm, Jonathan Moules wrote: > I know that the "DATE" type isn't actually a type in SQLite and that there > are no date-specific constraints, but I find it a convenient indicator (to me > and potentially anyone else who's going to see the code) as to the type of >

[sqlite] sqlite3_auto_extension + custom FTS5 tokenizer

2016-05-12 Thread Jan Berkel
> I?m currently implementing a custom FTS5 tokenizer which I?d like to > automatically register for each db connection. > > So I tried to register an extension hook with sqlite3_auto_extension but when > my code is called the FTS_* modules have not been initialized, because >

[sqlite] Sqlite incompatibility with Postgres

2016-05-12 Thread Scott Robison
On Thu, May 12, 2016 at 6:07 PM, dandl wrote: > > > Sqlite accepts (but Postgres does not): > > > LIMIT -1 OFFSET nnn > > > LIMIT -1 > > > > > > These all have the same meaning of no limit, but there is no common > > > ground in the syntax. > > > > Yes and Yes. Documented behaviour. There are