-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/12/2011 01:26 PM, John Deal wrote:
Good question. Very possible my understanding is not complete.
This document has the full details:
http://www.sqlite.org/lockingv3.html
I have basically read and write transactions, each potentially with
The downloads at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki appear
broken in various ways:
The precompiled binaries fail to work on desktop from Mono on OS X or on
Microsoft's CLR from Windows (even with the included test.exe) because they
attempt to load
On Fri, May 13, 2011 at 3:24 PM, Clay Fowler paul.clay.fow...@gmail.comwrote:
The downloads at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wikiappear
broken in various ways:
The precompiled binaries fail to work on desktop from Mono on OS X or on
Microsoft's CLR from
On 13 May 2011, at 8:24am, Clay Fowler wrote:
The precompiled binaries fail to work on desktop from Mono on OS X
.NET and Mono on OS X are extremely sensitive to version numbers. So check
you're using a long-issued up-to-date installation of Mono, but not one of the
bleeding-edge versions
On Fri, May 13, 2011 at 3:24 AM, Clay Fowler paul.clay.fow...@gmail.comwrote:
The downloads at
http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wikiappear
broken in various ways:
The precompiled binaries fail to work on desktop from Mono on OS X or on
Microsoft's CLR from
On Fri, May 13, 2011 at 7:51 AM, Shane Harrelson
shane.harrel...@gmail.com wrote:
The bundled readme, as well as the features page, have an update in red,
describing
the decision we made to ship the SDS DLL and the Interop DLL separately for
all platforms:
Currently all versions provided as
I gather sqlite3_last_insert_rowid doesn't play well with FTS? I don't see an
exception noted in the docs but neither are there non-manually managed examples.
I'd prefer not to manually mange them but ...
___
sqlite-users mailing list
Dear list,
Is there a way to make SQLite accept this kind of constraint:
CREATE TABLE tab (
id INTEGER NOT NULL,
data INTEGER,
CHECK(data = 0 or not exists (select 1 from tab where id = data)));
This toy exemple doesn't mean much as it is and the actual situation is
a bit more
It compiles fine, but I get a runtime error:
An unhandled exception of type 'System.DllNotFoundException' occured in
System.Data.SQLite.dll
Additional information: Unable to load DLL 'SQLite.Interop.DLL': The
specified module could not be found. (Exception from HRESULT: 0x8007007E)
Don
I'm getting conditional branch warnings from valgrind that all percolate up via
a WAL path. Anybody know if these are known benign?
This is, admittedly, off a sqlcipher-patched version of 3.7.6.2. I don't think
that should relate but I'll check if they shouldn't be occurring.
On Fri, May 13, 2011 at 2:42 PM, Steven Parkes smpar...@smparkes.netwrote:
I'm getting conditional branch warnings from valgrind that all percolate up
via a WAL path. Anybody know if these are known benign?
I noticed this myself just yesterday.
On our pre-release checklist, we have a bullet
I have not yet figured out why valgrind warns on linux-64 but not on
linux-32 and whether or not this is anything to be concerned about.
Thanks for letting me know. This is x86_64 for me as well, though on OS X.
___
sqlite-users mailing list
On Fri, May 13, 2011 at 2:49 PM, Richard Hipp d...@sqlite.org wrote:
On Fri, May 13, 2011 at 2:42 PM, Steven Parkes smpar...@smparkes.netwrote:
I'm getting conditional branch warnings from valgrind that all percolate
up via a WAL path. Anybody know if these are known benign?
I noticed
I have a database where a field's value is a comma separated list
indicating the basic categories the item belongs to.
so if the categories field has a value of 1,8,15
I want to do a query like this:
SELECT categories FROM myTable WHERE 8 IN (categories);
but it only finds records where 8 is
On May 13, 2011, at 9:15 PM, Trevor Borgmeier wrote:
so if the categories field has a value of 1,8,15
Yep, it's a text column. Nothing relational about it.
Any advise would be appreciated.
Normalize your design.
___
sqlite-users mailing list
SELECT categories FROM myTable WHERE (,||categories||,) LIKE %,7,%;
but I'm guessing LIKE isn't as efficient, and the query is more
awkward. Any advise would be appreciated. Thanks!
This LIKE is the only way to get information from your table. But you
can do it more efficiently by changing
Hi,
FTS and sqlite3_last_insert_rowid do not work together. This is a known
shortcoming. Basically this also means that you can't use any triggers
involving FTS.
Regards,
Hartwig
Am 13.05.2011 um 17:38 schrieb Steven Parkes:
I gather sqlite3_last_insert_rowid doesn't play well with FTS? I
On Fri, May 13, 2011 at 11:38 AM, Steven Parkes smpar...@smparkes.netwrote:
I gather sqlite3_last_insert_rowid doesn't play well with FTS? I don't see
an exception noted in the docs but neither are there non-manually managed
examples.
Please try the latest code checkin (
Upgrading zlib to the latest release (1.2.5) fixed all of my valgrind
warnings in Fossil, including those that appeared to have been coming from
SQLite WAL.
On Fri, May 13, 2011 at 3:11 PM, Richard Hipp d...@sqlite.org wrote:
On Fri, May 13, 2011 at 2:49 PM, Richard Hipp d...@sqlite.org
Anybody have any ideas? This is really odd.
And it's annoying to have to send from my droid--especially when I need to
copy/paste an error msg that's on my pc because I have to email it to myself
and then send that message on to the list.
Don Ireland
-Original Message-
From: Don
On May 14, 2011 12:31 AM, Don Ireland sql...@donireland.com wrote:
It compiles fine, but I get a runtime error:
An unhandled exception of type 'System.DllNotFoundException' occured in
System.Data.SQLite.dll
Additional information: Unable to load DLL 'SQLite.Interop.DLL': The
specified
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 05/13/2011 02:35 PM, Don Ireland wrote:
Anybody have any ideas? This is really odd.
Two possibilities:
- - You have different from addresses configured on the phone and desktop.
There is no way for the mailing list to know they are the same
Hello Simon,
I actually never finalize prepared statements until the DB is closed and not
being used anymore. I reset the prepared statements. For writes (inserts,
updates, etc.) I use explicit transactions with commits (or rollbacks if
errors). I reuse the prepared statements by rebinding
Hello Pavel,
Many thanks on the extensive information. I think I understand what you are
saying. I do have a couple of questions.
If on thread #1 using connection #1 does a step on a prepared select statement
and then is blocked before the sqlite3_column() statements and tailing reset
On 14/05/2011, at 5:15 AM, Trevor Borgmeier wrote:
I have a database where a field's value is a comma separated list
indicating the basic categories the item belongs to.
so if the categories field has a value of 1,8,15
I want to do a query like this:
SELECT categories FROM myTable
On May 13, 2011 8:17 PM, BareFeetWare list@barefeetware.com wrote:
There is no function built into SQLite to convert a text string into a set
(eg convert 1,8,15 into (1, 8, 15)), but such a function is not needed in
this case. You need a better design of your database. SQLite is relational
On Fri, 13 May 2011 17:14:32 -0700 (PDT)
John Deal bassd...@yahoo.com wrote:
Again thanks for the information and I apologize for taking up so much list
bandwidth. I hope others can benefit.
Watching this thread was useful to me and I'd like to use this reply to *thank*
Pavel and the
other
On 14 May 2011, at 12:29am, John Deal wrote:
I actually never finalize prepared statements until the DB is closed and not
being used anymore. I reset the prepared statements. For writes (inserts,
updates, etc.) I use explicit transactions with commits (or rollbacks if
errors). I reuse
TB giving any errors?
Do they show up in the Sent folder?
The Outbox folder?
Are you sending in HTML instead of text?
Have you confirmed one more time that you are sending it to the correct
address?
Can't think of any other questions.
--- On Fri, 5/13/11, Don Ireland
Hello Simon,
Yes I am following that sequence. However I do my sqlite3_column(...) calls to
extract data from selects between the step() and reset() calls.
My concern is the time between the step() and reset() calls if another select
step() is attempted from another thread with a separate DB
On Fri, 13 May 2011 12:06:23 -0400, Jean-Christophe Deschamps
j...@antichoc.net wrote:
Dear list,
Is there a way to make SQLite accept this kind of constraint:
CREATE TABLE tab (
id INTEGER NOT NULL,
data INTEGER,
CHECK(data = 0 or not exists (select 1 from tab where id =
i've seen .db and .sqlite and both work.
however, is there a rational for one or the other (eg firefox sqlite
plugin looks for .sqlite)?
--
in friendship,
prad
___
sqlite-users mailing list
sqlite-users@sqlite.org
prad p...@towardsfreedom.com wrote:
i've seen .db and .sqlite and both work.
however, is there a rational for one or the other (eg firefox sqlite
plugin looks for .sqlite)?
SQLite itself doesn't care. Each application is free to choose its own
convention.
--
Igor Tandetnik
1) if I were sending from an address other than the subscribed one, I'd get
those bounce messages telling me that. But I get NO message at all.
I'll check the message headers over the weekend though.
2) both the DROID and pc send out via the same mail server. Isn't it the server
that would be
Yes, I think TB is configured to send HTML. I take it that mucks things up?
I see the messages in sent items. And as far as confirming that I'm sending to
the right address--I even REPLIED to a message that came through the list.
Don Ireland
-Original Message-
From: Danny
35 matches
Mail list logo