LacaK wrote:
> some month ago I wrote question about possibility to add support of %y
> (2 digit year) to strftime() function.
> Patch is very simple (only few lines of code) and I hope, that will be
> useful for many users.
Two-digit years happend about two thousand years ago, and at that time,
n
Yes I know, that there is workaround using:
substr(strftime('%Y',d),3)
But why not add %y, when it is only 5 lines of source code, take into account
that %y is supported also by
C strftime() or PHP etc. and it is really useful.
-Laco.
Seriously, what your patch is actually about is to extra
LacaK wrote:
> But why not add %y, when it is only 5 lines of source code,
Plus documentation, test cases, etc.
> take into account that %y is supported also by C strftime()
> or PHP etc.
Those languages are not called Clite or PHPlite.
> and it is really useful.
You still haven't mentioned a
You might be interested in this thread:
http://www.theusenetarchive.com/usenet-message-sqlite-does-disabling-synchronous-and-shared-cache-cause-%22error-database-disk-image-is-malformed%22-20780199.htm
No conclusion was ever obtained, but the discussion was good.
-david
On Mon, Sep 24, 2012 at
If my database is X GB, and the WAL file is Y GB, how much total disk space
is required to:
1) Checkpoint the database
2) Vacuum the database
Additionally, if there are any temporary files created, where do they
exist? We've done some poking around and are having some crazy theory
about a tempo
On 25 Sep 2012, at 10:54pm, David Barrett wrote:
> If my database is X GB, and the WAL file is Y GB, how much total disk space
> is required to:
>
> 1) Checkpoint the database
I think it's a maximum of X+Y+Y (including the existing X+Y) plus or minus a
page or two.
> 2) Vacuum the database
David,
Thanks. Do you still have the problem ? Did you find a workaround to
avoid the problem - appreciate your response.
regards,
Rittick
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqli
Yes, still having that problem. We've moved to new servers with SSD's and a
ton of RAM, and that seems to have helped matters -- not sure why, though I
don't know why it was happening in the first place. (I'm *guessing* the
issue is due to two conflicting queries happening at the same time, so if
Do you think a retry of the query would help resolve this issue ? Do I have to
close & reopen the database.
Thanks for your help.
regards,
Rittick
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/s
On 09/26/2012 05:48 AM, Simon Slavin wrote:
On 25 Sep 2012, at 10:54pm, David Barrett
wrote:
If my database is X GB, and the WAL file is Y GB, how much total
disk space is required to:
1) Checkpoint the database
I think it's a maximum of X+Y+Y (including the existing X+Y) plus or
minus a pa
Hi all,
I wrote a simple C++ program that spawns 10 threads, each thread
- creates an SQLite handle (threads don't share connections)
- opens a database (common to all the threads), or creates it
(with "Write-Ahead Log" option) if open fails
- creates a table on th
11 matches
Mail list logo