[sqlite] SQLlite with Gui4Cli

2015-10-18 Thread Gert Venter
I?m using SQLite 3.9.0 on Windows 8.1 I?m a long time database developer (mainly Oracle, MySQL) but recently started using SQLite. I?m currently trying to develop a small project using Gui4Cli (here I?m a newbie) and SQLite as database. The Gui4Cli database docs are not very helpful with this

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Ian Zimmerman
On 2015-10-17 23:57 -0700, Darren Duncan wrote: > This just happened to me as well. > > I got a direct message with return address alexa at nsadatemail.com like > Jose described and it looks like a phishing attempt; it had the email > subject "Re: Re: [sqlite] Sqlite good on Windows XP but very v

[sqlite] Problem with sqlite3_create_function

2015-10-18 Thread Bart Smissaert
> Is that binary ? Or hex ? Normal decimal, it is the result of sqlite3_extended_errcode(lDBHandle) > Just to verify, can you download the SQLite shell tool and try to execute the same sequence ? Not sure that is that simple as the code to produce the result is in an ActiveX dll, not in sqlite3

[sqlite] Problem with sqlite3_create_function

2015-10-18 Thread Simon Slavin
On 18 Oct 2015, at 8:35pm, Bart Smissaert wrote: > I get an error: unknown error, Extended error code: 100. Is that binary ? Or hex ? > I do understand that most likely the problem is somewhere in my VB6 code, > but I can't see it and maybe somebody can shed some light on this from the > SQLi

[sqlite] Problem with sqlite3_create_function

2015-10-18 Thread Bart Smissaert
Using the latest SQLite, 3.9.1, running on Windows 7. Created a simple SQLite UDF with sqlite3_create_function and that function only sets the result as a fixed integer value, 123. The function is registered fine, so no error. I call this function XXX. Have a table like this: CREATE TABLE FUNCTION

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Darren Duncan
Yes, both times I got the messages so far (and they were different messages, as if the fake Alexia was having an ongoing discussion), they were within an hour of my posting to the list. What most likely is happening is that someone subscribed to the list has been compromised or the scammer is s

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread jose isaias cabrera
No, they are not. The emails are coming straight from theAlexa person to the personal email after a reply. So, someone in the list is grabbing the emails of the responder and sending an email right away. -Original Message- From: Richard Hipp Sent: Sunday, October 18, 2015 6:30 AM To

[sqlite] Another unexpected source of SQLITE_BUSY_SNAPSHOT

2015-10-18 Thread Florian Weimer
My first surprise was SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE (see ?SQLITE_BUSY_SNAPSHOT from BEGIN IMMEDIATE?). I have found another source of such snapshot failures with WAL-mode databases. I like to pre-compile my DML statements before starting transactions, mainly for the implied syntax che

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Simon Slavin
On 18 Oct 2015, at 12:19pm, Clemens Ladisch wrote: > Stephan Beal wrote: >> It didn't appear to come directly from the list - i suspect someone is >> scraping the ML archives. > > As far as I can see, the archives do not show the senders' actual email > addresses. Nor does nabble (hawk spit).

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Clemens Ladisch
Stephan Beal wrote: > It didn't appear to come directly from the list - i suspect someone is > scraping the ML archives. As far as I can see, the archives do not show the senders' actual email addresses. I think it is more likely that someone is scraping somebody's mailbox. This would be impossib

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Stephan Beal
On Sun, Oct 18, 2015 at 12:30 PM, Richard Hipp wrote: > On 10/18/15, Stephan Beal wrote: > > It didn't appear to come directly from the list - i suspect someone is > > scraping the ML archives. > > > > Are the messages you are receiving passing through the sqlite.org > server at any point? > No

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Stephan Beal
On Sun, Oct 18, 2015 at 12:08 PM, Richard Hipp wrote: > I've gotten several. There is no such subscriber on the mailing list. > I've asked Mike to look into the matter, but he hasn't found anything > yet. > It didn't appear to come directly from the list - i suspect someone is scraping the ML a

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Stephan Beal
On Sun, Oct 18, 2015 at 8:57 AM, Darren Duncan wrote: > This just happened to me as well. > me as well, within minutes of responding to the post mentioned here: > and it looks like a phishing attempt; it had the email subject "Re: Re: > [sqlite] Sqlite good on Windows XP but very very slow on

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Richard Hipp
On 10/18/15, Stephan Beal wrote: > On Sun, Oct 18, 2015 at 12:08 PM, Richard Hipp wrote: > >> I've gotten several. There is no such subscriber on the mailing list. >> I've asked Mike to look into the matter, but he hasn't found anything >> yet. >> > > It didn't appear to come directly from the l

[sqlite] SQLite list user phishing Alexa

2015-10-18 Thread Richard Hipp
On 10/18/15, Stephan Beal wrote: > On Sun, Oct 18, 2015 at 8:57 AM, Darren Duncan > wrote: > >> This just happened to me as well. >> > > me as well, within minutes of responding to the post mentioned here: > I've gotten several. There is no such subscriber on the mailing list. I've asked Mike t

[sqlite] Compilation fails under Linux (Ubuntu) when FTS5 is enabled

2015-10-18 Thread Dan Kennedy
On 10/18/2015 02:21 AM, tonyp at acm.org wrote: > I'm trying to compile the shell using the amalgamation (three files > involved: shell.c sqlite3.c sqlite.h). > This is a process I've done a zillion times before without problems. > The only new thing I did was add the -DSQLITE_ENABLE_FTS5 to comma