at 11:35 PM, Pavel Ivanov paiva...@gmail.com wrote:
If you have one reader and many writers, consider PRAGMA
journal_mode=WAL;
Richard meant one writer and many readers of course.
If the other process opens the db connection as read_only, will the hot
journal check be still done (during
Journal mode is WAL
I believe in-memory database can't have journal mode WAL. So you
compare completely different settings.
Pavel
On Tue, Aug 9, 2011 at 5:15 AM, sreekumar...@gmail.com wrote:
Journal mode is WAL
--Original Message--
From: Roger Binns
Sender:
What could be a possible explanation for this behaviour?
One difference int configurations is that the sqlite lib is built for
multithreading in the tmpfs scenario.
Could it be an overhead of mutexes?
Make tests with the same SQLite library. Run test with tmpfs using
strace to see if
Am I missing something here or if I want to prevent this, is my only option
to modify our build of SQLite to open the file for exclusive access?
Yes, opening with exclusive access is the only option for you. But
with latest SQLite version you don't have to modify SQLite sources for
that. You
If you configure and compile sqlite3 command line yourself and your
system have readline installed then yes.
Pavel
On Thu, Jul 28, 2011 at 4:08 PM, km...@netscape.net wrote:
Is it possible to edit commands entered on the sqlite3 command line?
is there a way to create more then one sqlite connection hadles for the
same in-memory database?
No.
There was a proposal:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg35438.html
from Markus Lehmann.
Is this a safe sollution?
I guess if it's not in the mainline SQLite it's not
as part of an embedded system build, i'm building a number of tools
for the *host* system, including sqlite-3.6.7 from the tarball (along
with a few patches which i will be examining shortly).
Apparently you are building from canonical sources. Why don't you use
amalgamation? It's much easier
I'm starting to get the impression that the only way for me to do this
is to make my own vfs layer...
http://stackoverflow.com/questions/3839158/using-sqlite-with-stdiostream
Yes, this is the best way you can do it. Other option is to take that
data, save it to some temporary file and then
So you can copy any block of memory you have a handle for into that, use
SQLite to manipulate the data while it's in memory
Simon, could you elaborate what you meant by that. To my knowledge you
can't just copy any block of memory into SQLite and make it treat this
memory block as database.
I can only control the databases and the libsqlite.so.
Is everything clear?
How do you do that, I wonder? Why do you think that applications you
don't control will always use your libsqlite.so? They may not use
libsqlite.so at all (compile SQLite sources into application) or use
whatever
could the next query use the tsamov_code index ??:
select * from tsamov where tsamov_code like 'AFG%'
Only after
pragma case_sensitive_like = true;
Read more about it here: http://www.sqlite.org/optoverview.html#like_opt.
Pavel
On Thu, Jul 14, 2011 at 11:56 AM, Sebastian Bermudez
Is anyone aware of another technique for preventing interactive mode from
running? I've seen this method:
Sqlite3 -init new.sql new.db .exit
How about
sqlite3 new.db .read new.sql
Pavel
On Thu, Jul 14, 2011 at 5:20 PM, Marvin Bellamy
marvin.bell...@innovision.com wrote:
I want to run
If I was to attach a database located in a file on disk to a database located
in memory, would the file DB be loaded in memory too, or would its usage
remain disk-based?
Its usage would be the same as if you open a new connection to that
database file, i.e. disk-based (barring the page caching
http://www.sqlite.org/compile.html#omitfeatures
Make sure you read all important notes and tested your app thoroughly.
Pavel
On Tue, Jul 12, 2011 at 9:10 AM, Baruch Burstein bmburst...@gmail.com wrote:
I assume this is the same for sqlite3.dll or sqlite3.lib, but if not, I am
interested in
Now what surprises me is that this optimization is not done
automatically by SQLite.
I suppose I just over estimate the capabilities of the SQLite plan generator.
Or, would this be something that could be improved?
It's very non-obvious optimization and I think other type of
optimization will
Is there something special one needs to do in order to drop a table from
inside a user-defined function?
To test, I call it simply like so:
SELECT my_function();
It shouldn't be ever possible to change the database from within a
function called from SELECT statement. SELECT query doesn't
assuming this is not a regular pattern that has an idiomatic workaround?
Ben
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Pavel Ivanov
Sent: 07 July 2011 05:18 PM
To: General Discussion of SQLite Database
Subject: Re
Any idea? Please, anyone can help me?
How did you put your data into database? I guess you did that with
command line utility. And as your console wasn't set to have UTF-8
charset then contents of pais now is not in UTF-8. But jdbc driver
tries to treat it as UTF-8 and so you don't see what you
Putting the 'ORDER BY' clause in view won't work?
It will work just fine, in that the results you see will appear in the ORDER
you asked for.
I believe that's not always true and is not required by SQL standard.
Most probably 'select * from view_name' will return rows in the order
written in
To put it another way, if I call sqlite3_create_function to install a
custom function, is that function now available to all threads using
SQLite or is it available only to the thread that made the
sqlite3_create_function call?
Yes, it's available to all threads using the same connection.
to your thoughts.
On 1 July 2011 15:30, Pavel Ivanov paiva...@gmail.com wrote:
Putting the 'ORDER BY' clause in view won't work?
It will work just fine, in that the results you see will appear in the
ORDER you asked for.
I believe that's not always true and is not required by SQL
Yes. What's wrong with that?
Nothing at all - I just needed to know whether that was the case so I
could design certain sections of my code accordingly.
Three question marks of yours suggested me that you think it's awfully wrong.
Note that although your function and application pointer
t_x WHERE txt BETWEEN 'x1' AND 'x2'
needs to be operating on the results returned by
SELECT * FROM t_x BY ORDER BY pos
ie another level of query is required but I'm not sure of how you insert it.
I'll have a play.
On 1 July 2011 16:12, Pavel Ivanov paiva...@gmail.com wrote:
What I want
order.
I am concerned about having to specify both xpos and pos and am not sure how
these two get reconciled.
I am getting results but want to add more data to the tables to see whats
going on.
Thank you for your assistance though.
On 1 July 2011 17:07, Pavel Ivanov paiva...@gmail.com wrote
be useless from the rowid
perspective/order.
I'll write a better description of what I'm trying to do and come back.
On 1 July 2011 17:48, Pavel Ivanov paiva...@gmail.com wrote:
I'll certainly try
SELECT pos FROM t_x WHERE txt BETWEEN 'x1' AND 'x2' ORDER BY pos;
but I need x1 and x2
This has to run as fast as possible. A left join between these tables is too
slow, for 10.000 entries it takes around 15 seconds just to navigate through
the cursor, if I add a where clause selecting only one kind of data then it
reduces to less than 5 seconds which is acceptable.
What kind
Just thought I should add that the problem seems to be gone with the
just released version 3.7.7, but it's not mentioned in the release notes.
It's not in release notes but it's in the timeline. See
http://www.sqlite.org/src/info/91e2e8ba6f and
http://www.sqlite.org/src/info/0b3174e0b1.
Pavel
Do you check result code of connection closing? Is it successful?
If it's not successful then some statements are still active and
reading transaction is still open. That could be the reason of error
in write process.
Pavel
On Wed, Jun 22, 2011 at 10:58 AM, Thorsten Kersting
.
On 06/22/2011 05:29 PM, Pavel Ivanov wrote:
Do you check result code of connection closing? Is it successful?
If it's not successful then some statements are still active and
reading transaction is still open. That could be the reason of error
in write process.
Pavel
On Wed, Jun 22
Can some one help me why the disk I/O error occured during the
sqlite3_prepare() statement ?
Because while preparing the statement SQLite must read schema from the
database. And although in case of integrity check it's not really
necessary I think it's still the general rule and is done before
, 2011 at 1:18 AM, Florian Weimer f...@deneb.enyo.de wrote:
* Pavel Ivanov:
To answer your original question: if you disable shared cache, start
reading transaction on one connection and start writing transaction on
the other connection then you'll be able to read on the first
connection
strcpy(DBEnginePath, Macintosh HD:Applications:Adobe InDesign
CS5:Plug-Ins:WPC_ID:IndexData.db);
Try to change path here to /Applications/Adobe InDesign
CS5/Plug-Ins/WPC_ID/IndexData.db.
Pavel
On Fri, Jun 17, 2011 at 3:08 PM, john darnell
john.darn...@walsworth.com wrote:
Sorry to send
Hmm... unless read_uncommited is persistant somehow; looks like if I
just don't try to use shared cache it works... I thought I had
disabled cache before alone and still got the same results...
read_uncommitted works only when shared_cache is on.
To answer your original question: if you
IIRC, there was a bug in enforcement compound foreign keys where one
of columns is primary key and it was fixed. So if you take the latest
SQLite version I guess you won't see this problem.
Pavel
On Fri, Jun 10, 2011 at 11:12 AM, Max B m...@alleged.net wrote:
Hello,
Please consider this
I know that I should avoid such things, but just curious, is it something
inside sqlite that probably makes one dynanmically linked and other
dynamically loaded library share global data and can this be avoidable?
No, it's Linux linker who works like that. If you have several
libraries loaded
So my next question is then, given that I have some data coming in, in
a random order, and I want an index. What can I do in order for the
performance to be better?
Create index only after all data is populated.
BTW, this kind of questions will be answered best on a sqlite-users
list.
framework than the one used for
my application?
Thanks for your support
Cyrille
Le 31/05/2011 15:57, Pavel Ivanov a écrit :
I would ask one more question: do they have the same Windows and .NET
Framework version as you have? AFAIK, Windows and .NET specifically
are very picky on all dlls
The main issue for me here is that the +1 is inside the string '+1 month'
and i thus cant use a subquerry of the type SELECT date('now','+(SELECT id
FROM table) month');
You can do like this:
SELECT date('now','+' || (SELECT id FROM table) || ' month');
Pavel
On Wed, Jun 8, 2011 at 1:42
Is there any way to do something along the lines of PRAGMA
some_command(SELECT * FROM table1 JOIN table2) and have it return A, B, C,
a, b, c as the headers?
If you insist on getting results as resultset then there's no way to
do that. But you can do the similar thing by using API like
DB file in WAL mode, checkpointing done every 5 seconds by separate
thread in program
Depending on the mode of checkpointing you use it can fail if there
are some other reading or writing transactions in progress. And at the
time you observe very long rollback actual checkpointing happens
the WAL size and see if it changes dramatically.
(Actually, that was another general question we had, should that WAL
file ever shrink during use? Why would it grow to that size at all?)
-Eric
On Tue, Jun 7, 2011 at 6:44 PM, Pavel Ivanov paiva...@gmail.com wrote:
DB file in WAL mode
file shrink back to 0 then? We're issuing PRAGMA
wal_checkpoint to the open DB handle.
-Eric
On Tue, Jun 7, 2011 at 7:06 PM, Pavel Ivanov paiva...@gmail.com wrote:
(Actually, that was another general question we had, should that WAL
file ever shrink during use? Why would it grow to that size
I did try sending a mail over the dev-list, but got no reply. Could
someone tell me how it should be done?
You should send it here with the exact steps of reproducing the bug.
Hopefully your tool is not code analyzer because potential bugs
without any real life steps to catch it won't be paid
but is returning the value stored in the database when executed
as a part of a java program. Can anyone help me if I am missing
something here ?
Looks like your java program runs with a different locale than SQLite
Manager. I'm not sure why it thinks that you are in a UTC timezone.
Maybe
wrote:
The returned value is displayed to the user. We are not storing back the
returned column.
Sridhar
On 02-06-2011 19:28, Pavel Ivanov wrote:
but is returning the value stored in the database when executed
as a part of a java program. Can anyone help me if I am missing
something here
, Pavel Ivanov wrote:
I have verified my locale and default time zone in the same program.The
values are correct and it is not UTC timezone. Any help appreciated.
How did you do that? What OS are you running it on?
Can you extract the code accessing SQLite database from your program
From within a BEGIN TRANSACTION and END TRANSACTION block, should I not
update the same row in a table more than once?
You can update it as many times as you need.
What are the exact limitations on what I can do during a Transaction?
Do not update a table if there is some select statement
some spare time).
Pavel
On Wed, Jun 1, 2011 at 2:41 PM, Robert Myers rob.my...@ziften.com wrote:
On 6/1/2011 1:23 PM, Simon Slavin wrote:
On 1 Jun 2011, at 7:12pm, Jan Hudec wrote:
On Wed, Jun 01, 2011 at 10:17:02 -0400, Pavel Ivanov wrote:
From within a BEGIN TRANSACTION and END TRANSACTION
uncommitted data in the same transaction.
Pavel
On Wed, Jun 1, 2011 at 2:57 PM, Robert Myers rob.my...@ziften.com wrote:
On 6/1/2011 1:47 PM, Pavel Ivanov wrote:
Actually, you do know what SQLite does without knowing the internals. It
claims to be serializable and ACID
(http://www.sqlite.org
CREATE TRIGGER ts_update after update on ip_timestamps when
This means that your trigger fires after each UPDATE statement. But
I'm adding/updating records with statements like:
INSERT OR REPLACE into ip_timestamps VALUES ( 182.71.33.222 , 1306932777 );
you do INSERT statements, so your
2.) I moved SQLite3.c and SQLite3.h into my source folder and added them
to the project. I made no changes to the code nor did I do anything special
when I added them to my project (i.e. I did not set any special compile
flags-I simply added the two files to the project).
3.) I
Here are two errors out of the 1200+ errors generated (I tried to include as
much information as possible to help identify the problem. Please forgive if
I am overdoing it...):
Compiling /.../sqlite3.c
Error:invalid conversion from void * to char *
This error was
I can use two left joins. While writing the first left join, I discovered
that it is behaving like an inner join.
select *
from test a
left join test b on a.component = b.component
where a.machine = 'machine1'
and b.machine = 'machine2';
By the WHERE condition you limit results of
I have all writes in transactions. If I deactivate my pthread_rwlock() that
enforce the above, several writes fail with a database locked error (I
assume it is returning SQLITE_BUSY).
So how do I implement the equivalent of a pthread_rwlock() using SQLite
mechinisms?
When SQLITE_BUSY in
mechanisms to achieve the same
results. I am just trying to understand how to do that. Pthread_rwlock()
works fine.
Thanks,
John
--- On Tue, 5/24/11, Pavel Ivanov paiva...@gmail.com wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Multi-threading Common Problem
If I try to query database existence using Linq's DatabaseExists I get
a NotImplemented exception in the sqlite ChangeDatabase function - which
doesn't make sense to me.
SQLite doesn't have a notion of server containing several databases.
That's why it makes perfect sense that SQLite doesn't
then it can't be used with SQLite.
Pavel
On Tue, May 24, 2011 at 11:05 AM, Ruth Ivimey-Cook r...@ivimey.org wrote:
Pavel Ivanov wrote:
If I try to query database existence using Linq's DatabaseExists I get
a NotImplemented exception in the sqlite ChangeDatabase function - which
doesn't make sense
sqlite select * from aa where a_id1 in (select distinct a_id1 from ab
where ab.a_id2 = 1 and ab.b_id = 1) and a_id2 in (select distinct a_id1
from ab where ab.a_id2 = 1 and ab.b_id = 1) ;
With your schema this can be transformed the same way:
select aa.*
from aa, ab ab1, ab ab2
where aa.a_id1
Is there a rationale for allowing such statements or is that an effect
of the 'Lite' nature? (Note: I'm not complaining, just asking.)
I believe that's an effect of the typeless design. As SQLite doesn't
have strict type names for columns it accepts pretty much anything for
that. So in your
I need help to build a statement in order to select all days free from
events in a specific time range.
This kind of task should be implemented in your application. SQL
wasn't intended for and can't solve such tasks.
Pavel
On Wed, May 18, 2011 at 4:06 PM, Danilo Cicerone cyds...@gmail.com
That is, is leaving it to the
query optimiser to figure out that I only need the sub select once the
best thing to do?
AFAIK, SQLite's optimizer is not that smart to collapse two identical
sub-queries and reuse once generated result.
Is the select I'm doing where both a_id1 2 are in the
I'm still not 100% sure if there's a problem sharing connections across
threads with SQLITE_OPEN_NOMUTEX as long as I guarantee that they aren't
concurrent. I suspect there aren't, but I'm not 100% sure. Any case where
sqlite3 would be less than happy that pthread_self wasn't always the
for taking up so much list
bandwidth. I hope others can benefit.
John
--- On Thu, 5/12/11, Pavel Ivanov paiva...@gmail.com wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Date
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
After a BEGIN EXCLUSIVE, no other database connection except for
read_uncommitted connections will be able to read the database and no other
connection without exception will be able to write the database until the
transaction is complete.
This tells me that reads outside of a transaction
Interesting is the impression I had with prepared statements was the reset
was only necessary if you wanted to reuse that statement. Since each each DB
connection is in its own instance of a class (with it own set of prepared
statements) I would not think there would be any dependency on
from other threads
(or is it DB connections?) but not the current thread (or is it DB
connection).
Thanks for the help!
John
--- On Thu, 5/12/11, Pavel Ivanov paiva...@gmail.com wrote:
From: Pavel Ivanov paiva...@gmail.com
Subject: Re: [sqlite] Common Multi-treaded Problem
To: General
-0400
Pavel Ivanov paiva...@gmail.com wrote:
There's no dependency between different prepared statements, but there
is dependency between transactions as they use the same database. And
transaction cannot be finished (implicitly or explicitly) until all
statements in this transaction
00:01 Transaction A: BEGIN
00:02 Transaction B: BEGIN
00:03 Transaction A: INSERT INTO test VALUES (1) // works okay
00:04 Transaction B: INSERT INTO test VALUES (1) // aborts with 'duplicate
key' error! why???
I get SQLITE_BUSY database is locked at this point, as I would expect.
MySQL
Therefore, the second insert fails on every database system i ever
encountered.
Apparently you didn't encounter Oracle. In such situation Oracle
freezes transaction B until transaction A is committed or rollbacked.
After that it knows what to return to transaction B - error or success
I can't trully construct sql statement piece by piece with SQL
db as I did with Oracle. Just wanted to confirm.
Why do you need to construct SQL specifically with db's tools? Why
can't you do that in your host language?
Oracle needs dynamic SQL feature because it will work much faster than
the
Is this true, or is the memory usage pretty much similar?
Until you reach limit set by 'pragma cache_size' memory usage would be
the same for in-memory database and on-disk database. When the size of
your database grows beyond 'pragma cache_size' in-memory database
starts to consume more memory
Any other chance to speed this up (apart from the obvious optimize the
query, do not use distinct on large tables)=
Without seeing the query or database schema? Not really... Depending
on the exact query an index on xyz might help.
Another suggestion could be to turn off shared cache
sqlite select * from a where a=10 group by b;
10|1
10|2
sqlite select * from a where a=11 group by b;
11|2
11|3
How can I do count equivalent of such a query to find out how many
distinct values of b there are for a given a? (That is get an answer of
2 in the above)
select
My understanding of the shared cache model was that it just ist intended
for solving our problem by relaxing the locking a little and that there
should not be any mutexes at all when using the uncomitted read mode.
Have I missed anything?
Yes, you are involved in a magical thinking. All that
The problem is that I would like to avoid splitting the query into two parts.
I would expect SQLite to do the same thing for me automatically (at least in
the second scenario), but it does not seem to happen... Why is that?
In short, because SQLite cannot read your mind.
To understand the
I believe any compilation options that require changes in SQL parser
require compiling from original sources as well. They cannot be used
with amalgamation file which has already generated SQL parser's code.
Pavel
On Tue, May 3, 2011 at 3:05 PM, jeff archer jarch...@yahoo.com wrote:
I am
After more poking, it appears that rowids might not be changed by a vacuum if
I have an index on the table. Is this true? If so, is it something I can rely
on going forward?
No, it's not true. The only way to keep your rowids intact is to
declare an INTEGER PRIMARY KEY alias for it. And you
which suggests that referring to rowids is fine.
It does not suggest referring to ROWIDs is fine, it only says that it
can be done. I think Pavel's point is that referencing ROWIDs is bad
practice, so that is why he says you shouldn't do it.
Yes, that's right. You can refer to rowid, but
REQ3 is a problem because you have mixed signs in INV and only one record in
REP
How would I craft a query to return REQ3?
Could be something like this:
select INV.REQ,
count(case when INV.AMT 0 then 1 else null end) positive,
count(case when INV.AMT 0 then 1 else null end) negative,
and/or time.
It won't be your local time.
Pavel
On Fri, Apr 22, 2011 at 5:46 AM, Fabio Spadaro fabiolinos...@gmail.com wrote:
Hi.
2011/4/22 Fabio Spadaro fabiolinos...@gmail.com
Hi
2011/4/22 Fabio Spadaro fabiolinos...@gmail.com
Hi.
2011/4/22 Pavel Ivanov paiva...@gmail.com
What does
It's not related to the list but still...
Technically, the data referred to is as follows. An iPhone logs details of
which phone base stations it connects to, and the 'status' data obtained from
the base station when it was connected. The location (long lat) of the
base station is part
Does not work on python with sqlite3 module
What does SELECT sqlite_version() gives you in python with sqlite3 module?
Pavel
On Thu, Apr 21, 2011 at 9:17 AM, Fabio Spadaro fabiolinos...@gmail.com wrote:
Hi.
2011/4/21 Black, Michael (IS) michael.bla...@ngc.com
create table t (d default
, Fabio Spadaro fabiolinos...@gmail.com wrote:
Hi.
2011/4/21 Pavel Ivanov paiva...@gmail.com
Does not work on python with sqlite3 module
What does SELECT sqlite_version() gives you in python with sqlite3
module?
Pavel
On Thu, Apr 21, 2011 at 9:17 AM, Fabio Spadaro fabiolinos...@gmail.com
Whenever you have doubt like that just go to
http://www.sqlite.org/lang.html and see if the statement you are
trying to execute exists there and what its correct syntax is.
Pavel
On Wed, Apr 20, 2011 at 10:40 AM, as...@comcast.net wrote:
Is LOCK TABLE statement supported by by SQLite? I am
Does anyone one know how to build sqlite to get the same binary as on
download page ?
Did you try to remove all those defines that you add at build time and
leave only default values set inside sqlite3.c file?
Pavel
On Mon, Apr 18, 2011 at 8:42 AM, Kuba Nowak kubano...@gmail.com wrote:
You won't be able to insert. The statement will fail.
Pavel
On Mon, Apr 18, 2011 at 9:44 AM, Adam DeVita adev...@verifeye.com wrote:
Good day,
What happens if you insert more than your RAM size into an in memory
database?
(I'm particularly interested in the Windows context).
regards,
Depending on the database size, it sometimes takes minutes to get a result.
But when using the Firefox plugin SQLite Manager, it only takes 1-2
seconds.
I use SQLITE Version 3.6.22.
Maybe SQLite Manager uses newer version of SQLite? Try to execute in
it SELECT sqlite_version().
Pavel
...@spoerr.org wrote:
Hello Pavel,
thank you for your answer. SQLite Manager uses version 3.7.4, but I checked
the SQLite release notes and I could not find changes for sqlite3_step.
Should I upgrade anyway?
Thanks,
Mathias
On Mon 18/04/11 15:49 , Pavel Ivanov paiva...@gmail.com sent
/changes.html
Thanks,
Mathias
On Mon 18/04/11 16:05 , Pavel Ivanov paiva...@gmail.com sent:
I checked
the SQLite release notes and I could not find changes for sqlite3_step.
Should I upgrade anyway?
Did you notice in release notes something like optimizer
improvements? That's what impacts
Stefan,
SQLite should'nt be called a SQL database (as e.g. touted on its homepage).
Instead it should clearly declare itself as an In-memory SQL
Datastore or a Data container with SQL capabilities.
This is quite serious allegations. Making them you should explain what
they are based on.
Keep in mind that sqlite has a limit of 32 open databases.
32 _attached_ databases, not opened. With different sqlite3* handlers
you can open as many databases as you want (and your memory permits).
Pavel
On Thu, Apr 7, 2011 at 6:05 AM, Eduardo nec...@retena.com wrote:
At 18:11 06/04/2011,
The fact that one engineer installed a site, began operating the app,
then saw it become corrupt minutes later rules out power loss or hard
resets in at least that case. An operating system level problem should
have been noticed by now given it's Windows XP... And the file is
locally held
.
Pavel
On Wed, Apr 13, 2011 at 10:25 AM, Richard Hipp d...@sqlite.org wrote:
On Wed, Apr 13, 2011 at 9:53 AM, Pavel Ivanov paiva...@gmail.com wrote:
The fact that one engineer installed a site, began operating the app,
then saw it become corrupt minutes later rules out power loss or hard
If the 'COMMIT' reports that no transaction is active, why is the
JOURNAL_MODE pragma still complaining about it being within a transaction?
Am I missing something here?
Probably you have some not finalized SELECT statements still active.
To check that you can call sqlite3_close - it will fail
Probably this could work:
SELECT c1,c2,sum(t2.c3) / count(distinct t3.rowid),count(distinct t3.rowid)
FROM t1 LEFT JOIN t2 on t2.key2=t1.key1
LEFT JOIN t3 on t3.key3=t1.key1
GROUP BY t1.key1
And btw, you didn't say where your c1 and c2 come from but if they are
from t1 and t1 has several rows
There is a way to insert null values from a file without specifying it
in?
It's impossible when you use standard sqlite3 command line utility. In
your particular case you have 2 options: either write your own
application that will recognize some kind of value as null and insert
it instead of
* Which version of the source should I use? The amalgamized source
isn't really useful
Why it's not useful for you if it contains all the functionality SQLite have?
* Where are pages read and written? I found the page-cache, but not
the functions that read/write those pages to disk.
You are
Furthermore, if I turn off auto checkpointing, the WAL file grows to
more than 5 GB without transactions, but only to about 922 MB with a
transaction. Are the commit markers really taking that much space?
WAL-journal is not some kind of change log with commit markers. It's a
sequence of
...@bigfraud.org wrote:
On 6 Apr 2011, at 3:15pm, Pavel Ivanov wrote:
For each transaction SQLite must
write all changed pages into WAL-journal. It would be at least one
page per transaction.
Two ? One for the page holding the table, another for the page holding the
primary key ?
Simon
301 - 400 of 1164 matches
Mail list logo