Hello all,
I was wondering if it would be possible to include fts2 in the
amalgamated version of the source code. It looks like all that needs
to be done is add
tclsh $(TOP)/ext/fts2/mkfts2amal.tcl
to the end of the target_source target in Makefile.in and then add
fts2amal.c
to the
While using SQLite as FastCGI module from within PHP-scripts, sometimes I'm
getting error messages, like:
(mod_fastcgi.c.2551) FastCGI-stderr: PHP Warning:
sqlite_open() [function.sqlite-open
malformed database schema - unable to open a temporary database file
for storing temporary tables in
Richard Klein wrote:
Joe Wilson wrote:
You've probably read this. It's useful information for any performance
minded developer using SQLite:
http://developer.mozilla.org/en/docs/Storage:Performance
I read it, and I'm now weeping! Below I've reproduced the paragraphs that
cause me some
--- Rohit Mordani <[EMAIL PROTECTED]> wrote:
> I wanted to know if I can reuse the parser from sqlite. I want the
> different sections of the query (like the SELECT part, the FROM part etc.) I
> wanted to know if there is a parsed tree of some sorts that is the end
> result of parsing (in
On Thu, Jul 26, 2007 at 04:26:41PM -0700, [EMAIL PROTECTED] wrote:
> If it works and then later stops working, it's much more likely that
> you're having a problem with some file descriptor that is not closed
> properly (on the temp db most likely).
> If it dies after let's say a week, you can
-- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> The problem is, that the error message actually gives not any clue. It just
> tells, that "there was problem while truing to open temporary database file"
> - but there (considering the above) shouldn't be any problem. /var/tmp has
> rwxrwxrwx
Hi,
I wanted to know if I can reuse the parser from sqlite. I want the
different sections of the query (like the SELECT part, the FROM part etc.) I
wanted to know if there is a parsed tree of some sorts that is the end
result of parsing (in sqlite) and if I can use this tree to retrieve the
On Thu, Jul 26, 2007 at 12:59:45PM -0700, Joe Wilson wrote:
> /var on my machine is drwxr-xr-x, and I don't have any issues with sqlite
> reading and writing temp files to /var/tmp/. Even if the permissions of /var
> were d--x--x--x, it would also be fine. As long as /var/tmp is rwx for
> the
Hi
I seem to have resolved the problem below linking to the static library by
removing the STRIP command for the static library from the makefile.
The problem I now have is that the library is 1.1 MB which is approximately
twice the size of what the library was before. This is an embedded
On Thu, Jul 26, 2007 at 08:11:22AM -0700, Joe Wilson wrote:
> Try
>
> PRAGMA temp_store_directory = 'directory-name';
>
> Otherwise, the temp file location order for UNIX is:
>
> "/var/tmp",
> "/usr/tmp",
> "/tmp",
> ".",
Thanks, I'll try to. Although is rather temporar
Unless something changed recently that I missed, fts2 is not a standard part
of sqlite so including it in the standard amalgamation would be a big
change. Having two distributions, one with and one without, might make
sense though.
Or including it with an OMIT flag would work too (default to
Joe Wilson wrote:
You've probably read this. It's useful information for any performance
minded developer using SQLite:
http://developer.mozilla.org/en/docs/Storage:Performance
I read it, and I'm now weeping! Below I've reproduced the paragraphs that
cause me some consternation:
On 7/26/07, JJ <[EMAIL PROTECTED]> wrote:
Hi, I've solved the problem at last. One thing I didn't know that creating
DirectX device will lower float point precision, it is written in their
documentation... So creating DX app and running float calculations is no, no...
:)
Ah, interesting.
On Thu, Jul 26, 2007 at 05:29:15PM -0700, Joe Wilson wrote:
> What happens on the 102nd time?
Starting from 101st it just keeps reporting "malformed..." error everytime,
when one tries to access the database using any of PHP-scripts. Until I
"manually" restart lighttpd server.
> If it fails,
I read that. The Mozilla people point out that their advantage was with
a large volume of small transactions. They benefit from not destroying
the cache between transactions and by conserving memory with large
numbers of users. They point out that relaxing the ACID requirements
also aids
First, I have to say that it is likely another "memory leak" (mine) type
unobvious bug, it happens only once specific place in my program calls SQLite
with date/time function. I can't imagine how memory leak would cause
arithmetics to go bizzare, only perhaps something with floating point flags
"David Crawshaw" <[EMAIL PROTECTED]> wrote:
> Hello all,
>
> I was wondering if it would be possible to include fts2 in the
> amalgamated version of the source code. It looks like all that needs
> to be done is add
>
> tclsh $(TOP)/ext/fts2/mkfts2amal.tcl
>
> to the end of the target_source
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
>
> While using SQLite as FastCGI module from within PHP-scripts, sometimes I'm
> getting error messages, like:
>
> (mod_fastcgi.c.2551) FastCGI-stderr: PHP Warning:
> sqlite_open() [function.sqlite-open
> malformed database schema - unable to
I guess that the sqlite authors only want to include the core library
in the amalgamation and rely on loadable extension modules for the rest.
Perhaps fts1 and fts2 could be statically added to the amalgomation, but
ifdef'd out by default.
--- David Crawshaw <[EMAIL PROTECTED]> wrote:
> I was
> Shared cache mode would be better named "persistent cache mode" because
> its main effect is to permit one thread to not flush the cache after
> each transaction. The people at Mozilla report that they use it and get
> better throughput on small transactions.
You've probably read this. It's
John Stanton wrote:
Richard Klein wrote:
Joe Wilson wrote:
You've probably read this. It's useful information for any performance
minded developer using SQLite:
http://developer.mozilla.org/en/docs/Storage:Performance
>> [snip]
If the above is correct, it is not enough for the
>
> - Original Message
> From: Zbigniew Baniewski <[EMAIL PROTECTED]>
> To: sqlite-users@sqlite.org
> Sent: Thursday, July 26, 2007 4:12:00 PM
> Subject: Re: [sqlite] Problem with SQLite FastCGI module "malformed database
> schema"
>
>
> On Thu, Jul 26, 2007 at 12:59:45PM -0700, Joe
Hi, I've solved the problem at last. One thing I didn't know that creating
DirectX device will lower float point precision, it is written in their
documentation... So creating DX app and running float calculations is no, no...
:)
On the other hand one might use D3DCREATE_FPU_PRESERVE flag, to
On 7/26/07, Richard Klein <[EMAIL PROTECTED]> wrote:
> According to the Mozilla article referenced above, it's even worse than
> that: *All* cache pages, dirty or not, are freed at the end of *every*
> transaction, even if the transaction consisted of only read operations.
I believe this is no
Try using "strip -g" instead of "strip".
Alternatively, you could try --strip-unneeded
--- Chris Brown <[EMAIL PROTECTED]> wrote:
> I seem to have resolved the problem below linking to the static library by
> removing the STRIP command for the static library from the makefile.
>
> The problem I
--- Zbigniew Baniewski <[EMAIL PROTECTED]> wrote:
> Starting from 101st it just keeps reporting "malformed..." error everytime,
> when one tries to access the database using any of PHP-scripts. Until I
> "manually" restart lighttpd server.
I have no idea about the architecture of lighttpd and its
26 matches
Mail list logo