> sqlite-amalgamation-3_6_16.zip
> win32
> msvc 2008 sp1
>
> func sqlite3_open_v2() is called with 'flag' param = SQLITE_OPEN_FULLMUTEX
> | SQLITE_OPEN_READWRITE
>
> in sqlite3_initialize() func winMutexInit() is indirectly called three
> times:
> 1) in sqlite3MutexInit()
> 2) in
> This is why I generally advocate TAB delimited files over CSV
How does .mode tabs cope with quoted strings with tabs or newlines in them?
RW
Ron Wilson, Engineering Project Lead
(o) 434.455.6453, (m) 434.851.1612, www.harris.com
HARRIS CORPORATION | RF Communications Division
> I'm trying to take a CSV file and create a sqlite3 database for the
> iPhone.
> The CSV file has 33K entries and is 2 MB. The problem I am having is that
> only about 1/10 of the database file gets written into the sqlite3
> database.
The .import csv method is imperfect; if you have quoted
> Well, based on what others wrote about your initial comments, I suggest
> that you replace XP with a linux distribution. Then you can compile that
> source code all by yourself. On the other hand, if you insist on sticking
> with Microsoft, download one of the pre-built Winduhs .zip files as I
>
9 12:54 PM
To: Wilson, Ron P
Cc: General Discussion of SQLite Database
Subject: Re: [sqlite] Lemon parser : compile error when using
"%token_destructor" directive
On Mon, Jun 15, 2009 at 11:42:26AM -0400, Wilson, Ron P wrote:
|| It has been a while since I used lemon (big fan thoug
It has been a while since I used lemon (big fan though). Did you resolve this
issue or do you still need help?
RW
Ron Wilson, Engineering Project Lead, 434.455.6453
HARRIS CORPORATION | RF Communications Division
assuredcommunications(tm)
-Original Message-
From:
Cruel. Just cruel.
RW
Ron Wilson, Engineering Project Lead, Tyco Electronics, 434.455.6453
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Vinnie
Sent: Friday, April 17, 2009 8:49 AM
To: sqlite-users@sqlite.org
Subject:
OT, but related (AGAIN)
I was adding these books to my amazon wishlist (aka Ron's list of books that he
would forget about if he didn't put them on the list) and noticed that these
titles are all available on the amazon kindle, which is delivered wirelessly
via 3G network. I don't have a
To: General Discussion of SQLite Database
Subject: Re: [sqlite] minor config bug sqlite-amalgamation-3.6.11.tar.gz
On Mar 18, 2009, at 1:22 PM, Wilson, Ron P wrote:
> OT, but tangentially related...
>
> Is there any reason why all the dates are a month off in cvstrac
> remarks? See
OT, but tangentially related...
Is there any reason why all the dates are a month off in cvstrac remarks? See
for example, the link below in dr.h's reply. That is, I'm assuming that the
anonymous remark on february 18 and dr.h's followup remark 2 hours later were
really posted today, i.e.
See section 3.0 http://www.sqlite.org/datatypes.html
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Fitter Man
Sent: Friday, March 13, 2009 11:10 AM
To:
Sorry for the redundant reply. It looks like it was already answered.
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wilson, Ron P
Sent: Tuesday
You will have to do this with code.
select name from sqlite_master where name like 'x%';
that will give you a list of all tables that start with x; you can then
delete all tables with names in the result set.
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
If you click the link for 'create table' on the page below, you get
here:
http://www.sqlite.org/lang_createtable.html
Most of the constraint keywords are explained briefly there.
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From:
I think it would be cool to use System.Data.SQLite with powershell; I'm waiting
until you figure it out before I try it. I don't have a compelling reason to
try it myself yet, but the neato factor has me paying attention. Some of the
readers seem to think you should ask these questions
I love the diagrams. They are much easier to read (for me) than plain
text. To make them searchable, perhaps alt-text would suffice?
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf
You can try using the command line tool to import csv data:
sqlite> .mode csv
sqlite> .import yourdata.csv yourtablename
however, if you have quoted strings with commas embedded it won't work.
You can try using any delimiter with .separator command.
RW
sqlite>select level from sqlGuruOMeter
om: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P
Sent: Thursday, August 21, 2008 4:37 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] .import with .separator and quoted strings
Here is an easy way to reproduce the symptom. Given the following file
as i
auses the .import command to honor
quoted entries?
RW
sqlite>select level from sqlGuruOMeter where name="Ron Wilson";
2
-Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P
Sent: Tuesday, August 19, 2008 4:49 PM
To: sqlite-users@sqlite.o
I'm trying to import a table using the command line tool.
sqlite> .separator ,
sqlite> .import export.csv library
export.csv line 1: expected 53 columns of data but found 77
sqlite> .mode csv
sqlite> .import export.csv library
export.csv line 1: expected 53 columns of data but found 77
+1 for removal of quote munging.
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
sqlite>select level from sqlGuruOMeter where name="Ron Wilson";
2
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp
Sent: Thursday,
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of D. Richard Hipp
Sent: Wednesday, June 25, 2008 12:27 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] bug with NULL in NOT IN
On Jun 25, 2008, at 12:12 PM, Wilson, Ron P wrote:
> Why sho
Why should the second query return zero rows? Clearly ids 1 and 2 don't
exist in b. I'm not defending sqlite per se, just asking, logically
speaking, why would those other databases return zero rows for that
query?
On a related note, what if NULL exists in both tables? Sqlite doesn't
return
Also, don't forget trailing white space, e.g. "Hexion " != "Hexion".
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Igor Tandetnik
Sent: Saturday, June 14, 2008 10:55 AM
To:
sqlite>select level from sqlGuruOMeter where name="Ron Wilson";
2
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P
Sent: Monday, June 09, 2008 1:49 P
Wicked. Thanks David and Dennis!
And this works like a charm for all parents:
select f || ' ' || group_concat(t, ' ') from w group by f;
This pushes me up to a '2' on the SQL Guru Meter.
RW
SQLGuru-O-Meter |0-+--510|
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
, June 09, 2008 1:09 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] graph question
Wilson, Ron P
<[EMAIL PROTECTED]>
wrote:
> select t from w where f=1;
> 2
> 3
> 4
> 5
> 6
> 7
>
> I would like the output to look like this:
>
> 1 2 3 4 5 6 7
>
&
Given the following:
create table w (f, t);
begin;
insert into w (f, t) values (1, 2);
insert into w (f, t) values (1, 3);
insert into w (f, t) values (1, 4);
insert into w (f, t) values (1, 5);
insert into w (f, t) values (1, 6);
insert into w (f, t) values (1, 7);
...
commit;
select t from w
Leske
Sent: Tuesday, June 03, 2008 1:56 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] How to speed up my queries?
Wilson, Ron P schrieb:
> Hi Christophe,
>
> 1. Please give us an example query. SELECT * FROM Cities where
> LONGITUDE_DDS=? AND LATITUDE_DDS=
Discussion of SQLite Database
Subject: Re: [sqlite] How to speed up my queries?
Wilson, Ron P schrieb:
> Hi Christophe,
>
> 1. Please give us an example query. SELECT * FROM Cities where
> LONGITUDE_DDS=? AND LATITUDE_DDS=?
> 2. Paste in the EXPLAIN results from the command
Hi Christophe,
1. Please give us an example query. SELECT * FROM Cities where
LONGITUDE_DDS=? AND LATITUDE_DDS=?
2. Paste in the EXPLAIN results from the command line tool.
3. Is the database file local or are you accessing it over a network?
RW
Ron Wilson, S/W Systems Engineer III, Tyco
Welcome to the list!
First - some sample code or queries would be helpful.
Second - start a new topic
(http://en.wikipedia.org/wiki/Thread_hijacking).
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Along these lines, also note that the "quickstart" (url below) still
shows the callback method instead of the v2 methods. The last time
another programmer asked me for help, I referred him there and I was
shocked later at the code he produced. "Nice code, but you could have
done the same thing a
order by id is not guaranteed. use 'order by id' and it will.
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Neville Franks
Sent: Thursday, March 20, 2008 8:07 PM
To:
you are delimiting your dwords wrong. reverse the byte order. this
resolves your leading and trailing 00 problem.
sqlite> select imageID, hex(imageData) from Images;
1| 0300 0600 0900 0C00 0F00 1200 1500 1800 1B00
2| 0100 0200 0300 0400 0500 0600 0700 0800 0900
3| 0100 0200 0300
spaces added for clarification:
1| 0100 0200 0300 0400 0500 0600 0700 0800 0900
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of C S
Sent: Wednesday, March 12, 2008 10:48 AM
To:
void *blob = reinterpretcast(imageArray);
void *blob = reinterpretcast(imageArray);
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of C S
Sent: Wednesday, March 12, 2008 9:37 AM
To:
Heh. He implemented it with a goto statement! While I personally have no
problem with this, especially when it is the most efficient solution, we have a
client who demands all source code comply with MISRA and I don't relish the day
we have to defend SQlite and our parser (lemon generated).
38 matches
Mail list logo
