> 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 sqlite3Pcach
> 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
assured
> 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 stri
> 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
>
2: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: sqlite-user
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: Re
Cool! I didn't think of doing that. I presume this would incur a performance
hit on insert/update to check the constraint and sqlite3_prepare* would return
SQLITE_CONSTRAINT if the check failed. Right?
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
If you wa
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 kindl
32 PM
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?
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. mar
I added TWS to the wikipedia article:
http://en.wikipedia.org/wiki/Comparison_of_lightweight_web_servers
The only info I couldn't provide was the size of the server in kB.
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
From: sqlite-users-boun...
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: sq
The documentation doesn't say what the return value means for
sqlite3_extended_result_codes(). My first guess is that it returns SQLITE_OK,
or one of the other non-extended result codes. If nobody knows off the top of
their head, I'll do some code spelunking.
http://sqlite.org/c3ref/extended_
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
-Origin
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: sqlite-use
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 elsewhe
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 O
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 whe
your real table.
-Original Message-
From: [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 rep
Here is an easy way to reproduce the symptom. Given the following file
as input for the .import command:
---csvtest.csv---
"1","wilson, ron"
"2","momma, your"
-
Here is the sqlite output:
SQLite version 3.5.9
Enter ".help" for i
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, Au
ronics, 434.455.6453
-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 wrot
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 tha
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-
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 wh
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=?
>
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=?
> 2. Paste in the EXPLAIN results from the
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 Electr
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 PROTEC
ert
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Wilson, Ron P
Sent: Tuesday, May 27, 2008 6:36 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] .net wrappers - mono vs. phxsoftware
Denis pointed another poster to the url below, which I was unaware of:
h
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: sqlite-users@sqli
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 0400
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: Gen
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: General
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).
R
Never forget Hanlon's Razor:
"Never attribute to malice that which can be adequately explained by
stupidity."
as flame-war retardant, this can be translated as:
"Never attribute to malice what can be easily explained by difference of
opinion."
-or-
"Don't hate the person, hate their opinion."
Ro
hehe - check it out.
first comment: why no mention sqlite?
second comment: because its a trade magazine; consider their income
source.
third comment: thanks for name dropping SQL Anywhere in your article;
it beats sliced bread on mondays.
it couldn't be more perfect.
Ron Wilson, Senior Engine
> I could accept 28 Feb or 1 Mar as a
> reasonable answer and I can make that point to my users.
365/12 = 30.4
2006/03/31 - 30 days = 2006/03/01
just subtract 30 days and be done with it. i think you can justify that
to your customers.
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] a few lemon questions
--- "Wilson, Ron" <[EMAIL PROTECTED]> wrote:
> 1. My non-terminal token destructors are not getting called. The
> terminal destructors work fine, but none of my terminal tokens need
> destruction
Ok I've come a long way and have a functional parser using lemon and
flex. However, there are a few unresolved items that I need help with.
1. My non-terminal token destructors are not getting called. The
terminal destructors work fine, but none of my terminal tokens need
destruction. Two of my
more work for myself.
Wish me luck!
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 18, 2007 3:45 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] a few lemon questions
"Wilso
ginal Message-
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 18, 2007 3:36 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] a few lemon questions
--- "Wilson, Ron" <[EMAIL PROTECTED]> wrote:
> %type multiselect_op {int}
> multiselect_op(A) ::= U
I'm bringing myself up to speed on lemon. I have a few questions. Take
this example code:
%type multiselect_op {int}
multiselect_op(A) ::= UNION(OP). {A = @OP;}
multiselect_op(A) ::= UNION ALL. {A = TK_ALL;}
multiselect_op(A) ::= EXCEPT|INTERSECT(OP). {A = @OP;}
1. What
It has been a very long time since I have tinkered with lex/yacc but my current
project requires a parser. I'm thinking of learning lemon. Frankly, the
sqlite code base is far more complex than what I will implement. Is anyone
willing to share a lemon parse.y code example for something less c
, 2007 12:03 PM, Wilson, Ron <[EMAIL PROTECTED]> wrote:
>
> http://www.sqlite.org/quickstart.html
>
> This page still shows the old callback method for usign
sqlite3_exec().
> I actually haven't used SQlite in quite a long time, but judging from
> recent list topics, th
So a friend of mine was asking me how to get started using SQlite, so I
pointed him here:
http://www.sqlite.org/quickstart.html
This page still shows the old callback method for usign sqlite3_exec().
I actually haven't used SQlite in quite a long time, but judging from
recent list topics, this i
And now for something completely different:
Bud Lite - Tastes great, less filling
SQLite - Works great, less bloat
/bow
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: Michael Scharf [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 14, 2007 11:
After some googling, Gunter has this domain: http://greschenz.de but it merely
redirects to the dyndns url. It was active as late as 10/13/07 though. Maybe
he shuts down his server at night?
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: A.J.Millan
That sounds great and all, but lucky you that you get to work in an
office that actually lets you install firefox. Many corporations
severely limit user freedom on company hardware. I'm not one of them,
but I have many friends that work in these environments where only
'authorized' tools are inst
(4) is my choice. I'm not fond of the drop down menu scripts on
webpages anyway... but that's just me.
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 09, 2007 1:45 PM
To: sqlite-us
That looks fantastic (in firefox).
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, November 09, 2007 1:11 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Suggests for improving the SQLite we
Just put the font-family in your .css file and all the pages that refer
to your .css will conform. You already said that the demo site was .css
driven...
RW
Ron Wilson, Senior Engineer, MPR Associates, 518.831.7546
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Se
IMO, the http://www.postgresql.org/ site is the most appealing site of
the competing products. I would be happy if SQLite followed a similar
look.
I would try to keep the top-right menu links from SQLite.org, but I like
someone's earlier suggestion that they be grouped in categories. I'm
also fo
QFT
I agree with both Stephan *and* Rich. It would be great if the site
stayed clean, white, and straightforward. I don't personally have
difficulty selling SQLite to my boss because we've used it in many
successful projects, but I can see how the current site may not measure
up to so-called 'we
61 matches
Mail list logo