-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
> suggest API or functionality changes, now would be a good to to do so,
I have a few in no particular order, based on currently implementing vfs
in my Python SQLite wrapper.
I would like a #define of the current version
I have a question about the new PRAGMA journal_mode:
Since PERSIST is likely to be faster than DELETE on
most platforms, is there ever a reason *not* to use
it?
Put differently, is there any advantage to DELETE
over PERSIST?
- Richard Klein
___
Hi Shibu,
On Sat, 3 May 2008 00:20:35 +0530, you wrote:
>Hi,
>Is there a way to configure SQLite using a property/config file?
>Is changing the source code the only way to affect how it behaves?
There is something like that for the command line
tool. You can put a .sqliterc file in your
[EMAIL PROTECTED] wrote:
> Is there a way to configure SQLite using a property/config file?
> Is changing the source code the only way to affect how it behaves?
>
It would probably be better if you were a little more specific. What
part of its behavior do you want to change?
Dennis Cote
That's a good idea.
My solution was simply to break up the one long
continuation line into a bunch of single-line
assignments:
OPTS += -DSQLITE_DISABLE_LFS
OPTS += -DSQLITE_OMIT_ALTERTABLE
# OPTS += -DSQLITE_OMIT_ANALYZE
OPTS += -DSQLITE_OMIT_ATTACH
OPTS += -DSQLITE_OMIT_AUTHORIZATION
OPTS +=
I am stuck on a couple of concepts with TS3.
I found this write-up on TS3:
http://dotnetperls.com/Content/SQLite-FTS3.aspx
It indicates that update should be used to populate the virtual table. I
don't understand how to add data to the table via an update. Perhaps there
is a way to link the
Something you can do in such cases is instead of putting a comment at
the beginning of the line, change the define:
-DXSQLITE_OMIT_TRIGGER\
Yeah, so there's a chance that you've just randomly changed the define
to enable Scary Feature X, if that's really a concern add more
On May 2, 2008, at 8:50 PM, [EMAIL PROTECTED] wrote:
> Is there a way to configure SQLite using a property/config file?
> Is changing the source code the only way to affect how it behaves?
Have you looked at pragmas?
http://www.sqlite.org/pragma.html
--
PA.
http://alt.textdrive.com/nanoki/
Hi,
Is there a way to configure SQLite using a property/config file?
Is changing the source code the only way to affect how it behaves?
Shibu Narayanan
Consultant, PrimeSourcing Division, Investment Banking Group
Tel.Office: 91-80-2208-6270 or 91-80-6659-6270
e-mail: [EMAIL PROTECTED]
The
On May 2, 2008, at 2:07 PM, Ken wrote:
> I use the VFS to disable journal file creation and writing.
>
> Any possibility to make this part of the sqlite3_open_v2 mode
> parameter?
>
> That way I could drop my custom VFS.
>
http://www.sqlite.org/pragma.html#pragma_journal_mode
Before you rush
I use the VFS to disable journal file creation and writing.
Any possibility to make this part of the sqlite3_open_v2 mode parameter?
That way I could drop my custom VFS.
Thanks,
Ken
"D. Richard Hipp" <[EMAIL PROTECTED]> wrote: The Virtual File System (VFS)
layer for SQLite was introduced in
On Fri, May 2, 2008 at 11:56 AM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
> However, as we have gained experience with the VFS, we have come to
> realize that the original VFS design has some warts. In particular,
> not all of the methods in the VFS interface are able to return the
> errors
The Virtual File System (VFS) layer for SQLite was introduced in
version 3.5.0 on 2007-09-04. The VFS interface has made SQLite much
easier to port to unusual systems.
However, as we have gained experience with the VFS, we have come to
realize that the original VFS design has some warts.
Tom,
> I started a tabulated comparison of various SQLite GUI applications for Mac:
> http://www.tandb.com.au/sqlite/compare/
Wow! Your list is quite comprehensive. Thanks!
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
14 matches
Mail list logo