Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

2017-12-05 Thread Scott Robison
They'll be able to renew the certificate after some payments are made after the free 6 month trial had lapsed. :) On Dec 5, 2017 5:15 PM, "Keith Medcalf" wrote: > > Uses an expired SSL certificate ... > > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot

Re: [sqlite] Cross-compiling fails.

2017-12-05 Thread Joe Mistachkin
Alastair Growcott wrote: > > Cross-compiling sqlite3 fails due to the use of binaries in the > build process that are generated during the build process. > Specifically: > You'll need to use the NMAKE macro XCOMPILE. Also, depending on target platform you may need to use the other NMAKE macros l

Re: [sqlite] Cross-compiling fails.

2017-12-05 Thread Richard Hipp
On 12/4/17, Alastair Growcott wrote: > Cross-compiling sqlite3 fails due to the use of binaries in the build > process that are generated during the build process. I recommend that you do ./configure; make sqlite3.c or nmake /f makefile.msc sqlite3.c depending on whether your host sys

[sqlite] Cross-compiling fails.

2017-12-05 Thread Alastair Growcott
Cross-compiling sqlite3 fails due to the use of binaries in the build process that are generated during the build process. Specifically:     mksourceid     lemon The configure script explicitly offers the "--host=" option to allow cross-compiling. If cross-compiling is not supported then this

Re: [sqlite] Emulate right-join

2017-12-05 Thread Keith Medcalf
You want a LEFT JOIN not a RIGHT JOIN (these are of course just lazy spellings for LEFT OUTER JOIN and RIGHT OUTER JOIN respectively), assuming that you want all selected rows from the table of the LEFT and only the matching values (else NULL) for the table(s) on the right, which is how you des

Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

2017-12-05 Thread sub sk79
Thanks for bringing that to my attention. The website is under renovation as well. Hope to have it fixed soon. Regards, SKashikar On Tue, Dec 5, 2017 at 7:15 PM, Keith Medcalf wrote: > > Uses an expired SSL certificate ... > > > --- > The fact that there's a Highway to Hell but only a Stairway

Re: [sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

2017-12-05 Thread Keith Medcalf
Uses an expired SSL certificate ... --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-Original Message- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of sub sk79 >Sent: Tuesda

Re: [sqlite] Emulate right-join

2017-12-05 Thread John McKown
On Tue, Dec 5, 2017 at 3:44 PM, Stephen Chrzanowski wrote: > I'm working on a pretty simplified event tracking system (So I stay out of > trouble of not updating time spent throughout the day), and each item that > I need to track has an associated priority with it, which ranges for any > positiv

[sqlite] StepSqlite: SuperPowers for SQLite and BerkeleyDB

2017-12-05 Thread sub sk79
Hi All: The next version of StepSqlite - enhanced-PL/SQL compiler for SQLite and Oracle-TM BerkeleyDB (https://www.metatranz.com/stepsqlite) is due soon and is packed with Super Powers which will blow your mind! For a start, how about powerful Analytic Window Functions, Collections, Bulk-Ops? Now

[sqlite] Emulate right-join

2017-12-05 Thread Stephen Chrzanowski
I'm working on a pretty simplified event tracking system (So I stay out of trouble of not updating time spent throughout the day), and each item that I need to track has an associated priority with it, which ranges for any positive integer value. This priority can be user defined as a positive int

Re: [sqlite] [EXTERNAL] Re: Possible User Defined Function (UDF) Bug?

2017-12-05 Thread Richard Hipp
On 12/5/17, no...@null.net wrote: > On Tue Nov 28, 2017 at 03:30:54PM +, David Raymond wrote: > > SQLite developers, do you recognise this thread as an issue? Not a serious issue, no. I might look into it when I have time, but I'm neck-deep in other issues at the moment. -- D. Richard Hipp

Re: [sqlite] [EXTERNAL] Re: Possible User Defined Function (UDF) Bug?

2017-12-05 Thread nomad
On Tue Nov 28, 2017 at 03:30:54PM +, David Raymond wrote: > With an integer primary key, not just any primary key. Probably > something to do with the deterministic flag as well. Looks like in > checking if it's gonna be a good integer for a rowid it calls it > twice. Below you can see where ra

Re: [sqlite] Compile Error: SQLITE_ENABLE_MULTITHREADED_CHECKS and SQLITE_ENABLE_API_ARMOR defined concurrently

2017-12-05 Thread Dan Kennedy
On 12/02/2017 11:59 PM, Keith Medcalf wrote: Both are fine when either is defined independently (or neither is defined) but when both are defined concurrently there are compiler errors in function checkMutexFree: sqlite3x.c: In function 'checkMutexFree': sqlite3x.c:23521:8: error: dereferencin

Re: [sqlite] Cannot initialize statically linked extension

2017-12-05 Thread Steve Harrill
Get me off of this list Sent from my iPhone On Dec 5, 2017, at 04:48, Lifepillar wrote: On 05/12/2017 09:24, Guy Harris wrote: > On Dec 4, 2017, at 3:42 PM, Keith Medcalf wrote: > >> On Monday, 4 December, 2017 15:44, Jens Alfke wrote: >> If one object is using, for example, the multith

Re: [sqlite] Cannot initialize statically linked extension

2017-12-05 Thread Lifepillar
> Which it is, in this case. The OP said that both sqlite and th > extension are static libraries, so they’re both being linked directly > into the executable. > > I’m not sure what’s going on. Life, can you post a backtrace of the > crash? I'll try to make a minimal reproducible example. F

Re: [sqlite] Cannot initialize statically linked extension

2017-12-05 Thread Lifepillar
On 05/12/2017 09:24, Guy Harris wrote: > On Dec 4, 2017, at 3:42 PM, Keith Medcalf wrote: > >> On Monday, 4 December, 2017 15:44, Jens Alfke wrote: >> If one object is using, for example, the multithreaded runtime and the others are using the single threaded runtime (for example), an

Re: [sqlite] Cannot initialize statically linked extension

2017-12-05 Thread Guy Harris
On Dec 4, 2017, at 3:42 PM, Keith Medcalf wrote: > On Monday, 4 December, 2017 15:44, Jens Alfke wrote: > >>> If one object is using, for example, the multithreaded runtime and >>> the others are using the single threaded runtime (for example), and >>> the third perhaps the subsystem runtime >