-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 07:12 PM, Dan Bishop wrote:
> Newlines, backslashes, and double quotes can be included literally. The
> only other character you need to worry about is NUL.
Funnily enough I'm busy writing my own quoting routine right now (the source
On Sat, Apr 17, 2010 at 05:27:35PM -0700, andrew fabbro scratched on the wall:
> If a DB is entirely in-memory (i.e., opened with :memory:), which pragmas
> can be used to improve performance?
>
> (1) I assume synchronous = OFF is desirable
N/A. There is no such thing as synchronizing memory
Simon Slavin wrote:
> I am using a particular program which needs to be able to mess with an
> already-established database. It has to issue UPDATE and INSERT commands
> using one string for the entire command: no opportunity for binding. So it
> has to assemble commands by concatenation. In
If a DB is entirely in-memory (i.e., opened with :memory:), which pragmas
can be used to improve performance?
(1) I assume synchronous = OFF is desirable
(2) I'm guessing journal_mode = MEMORY is already set. Is journal_mode =
OFF another possible speed gain? Of course, then one loses the
On Apr 17, 2010, at 2:57 PM, slowpoison wrote:
>
> I want to know whether a TEXT field, when stored, will always take the
> exact amount of space allocated for it in the schema definition. So,
> when I say TEXT(1024), is the field guaranteed to take 1024 bytes on
> disk per record or is there a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 11:57 AM, slowpoison wrote:
> I was unable to find a reference to how TEXT data types are stored in
> the db files.
2.3.1 and 2.3.2 answer that:
http://www.sqlite.org/fileformat.html#varint_format
> I want to know whether a TEXT
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 10:33 AM, Feng Tony wrote:
> It's possible to create temporary tables by running sql scripts in my
> application?
What makes you think it wouldn't work, and what failed when you tried it?
Roger
-BEGIN PGP SIGNATURE-
Version:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 01:26 PM, Simon Slavin wrote:
> Is there a simple, low-cost way I can use the QUOTE() function,
http://www.sqlite.org/c3ref/mprintf.html
Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with
Hi,
I was unable to find a reference to how TEXT data types are stored in
the db files. The file format comment in btreeInt.h is too complex (or
may be the wrong place) for me to deduce what I'm looking for.
I want to know whether a TEXT field, when stored, will always take the
exact amount of
Hi All,
It's possible to create temporary tables by running sql scripts in my
application?
Thanks!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I am using a particular program which needs to be able to mess with an
already-established database. It has to issue UPDATE and INSERT commands using
one string for the entire command: no opportunity for binding. So it has to
assemble commands by concatenation. In order to do this properly I
I was using it to get the rowid of a given cursor in a SQLite statement.
Given a table schema like CREATE TABLE foo (A,B)
And an arbitrary select such as SELECT * FROM foo
I was able to return the rowid as a hidden column for the statement. This
included statements with multiple cursors (as a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 04/17/2010 11:08 AM, andrew fabbro wrote:
> I realize that's at the DBI layer and part of the DBI spec, but...is anyone
> aware of something similar in the C environment for SQLite? There does not
> appear to be any sort of debug logging, etc.
On Sat, Apr 17, 2010 at 11:08:49AM -0700, andrew fabbro scratched on the wall:
> I've been totally spoiled by Perl's DBI->trace functionality, which allows
> one to toggle SQL tracing on and off, and at various depths, so you can see
> what the engine is doing, what bind variables are being sent
Yes, it's for System.Data.SQLite. I'm trying to build it with the latest
engine code. I've commented out that one else-if that won't compile and so
far no errors, but that's a really bad way to proceed. The SQLiteKeyReader
c# class is trying to get a row id for a cursor.
declspec(dllexport) int
I think, without to be 100% sure, that it is for the wrapper .NET
System.Data.SQLite.
I was myself in front of this code (to have this wrapper using the latest
sqlite version).
I ended up by removing all this code, meaning that if you don't call
dispose() in your code, it will not be garbage
I've been totally spoiled by Perl's DBI->trace functionality, which allows
one to toggle SQL tracing on and off, and at various depths, so you can see
what the engine is doing, what bind variables are being sent to it, etc.
I realize that's at the DBI layer and part of the DBI spec, but...is
On Apr 17, 2010, at 1:02 PM, Paul Shaffer wrote:
> Due to changes in VdbeCursor structure, this code for 3.6.16 won't
> compile
> anymore:
>
> else if(pC->pseudoTable)
> {
> *prowid = pC->iKey;
> }
>
Your application should not be messing with internal data structures
of SQLite, all of
Due to changes in VdbeCursor structure, this code for 3.6.16 won't compile
anymore:
else if(pC->pseudoTable)
{
*prowid = pC->iKey;
}
and for 3.6.23 would have to be replaced by something like this:
else if(pC->pseudoTableReg>0)
{
//*prowid =
}
My problem is that after about an hour of
Just guessing, but column 'path' probably has greater cardinality than
column 'extension'. What happens if you reverse the order of these columns
in the index?
i.e. (basename, path, extension, deleted)
Also, I don't recall your saying whether a single composite index was faster
than separate
20 matches
Mail list logo