On Wed, Apr 6, 2011 at 9:27 AM, Filip Navara wrote:
> On Wed, Apr 6, 2011 at 6:36 AM, Dan Kennedy wrote:
>> On 04/05/2011 04:49 PM, Filip Navara wrote:
>>> Hello,
>>>
>>> we are having problem with database that originated on computer of one
>>> of our customers.
>>>
>>> The database is used in W
On 6 Apr 2011, at 8:14pm, Nikolaus Rath wrote:
> Simon Slavin writes:
>> On 6 Apr 2011, at 5:06pm, Nikolaus Rath wrote:
>>
>>> Another question though: what is the recommended way to insert lots
>>> of data with WAL enabled? Without a transaction, the WAL file stays
>>> small but the insertions
Simon Slavin writes:
> On 6 Apr 2011, at 5:06pm, Nikolaus Rath wrote:
>
>> Another question though: what is the recommended way to insert lots
>> of data with WAL enabled? Without a transaction, the WAL file stays
>> small but the insertions take very long time. With a transaction,
>> things are f
-- Forwarded message --
From:
Date: Wed, Apr 6, 2011 at 2:48 PM
Subject: Content filtered message notification
To: sqlite-users-ow...@sqlite.org
The attached message matched the sqlite-users mailing list's content
filtering rules and was prevented from being forwarded on to the l
> any idea ?
Your application have race conditions and corrupts memory.
Pavel
On Wed, Apr 6, 2011 at 2:36 PM, Vander Clock Stephane
wrote:
> hello,
>
> in heavy multithread environnmeent we receive (one time a month, so not
> very often), this error :
> Access violation at address 6090B662 in
hello,
in heavy multithread environnmeent we receive (one time a month, so not
very often), this error :
Access violation at address 6090B662 in module 'sqlite3.dll'. Read of
address DE8D6B84
any idea ?
___
sqlite-users mailing list
sqlite-users@sqlit
Thanks for the interest, but I now can't repro the bug using pure sqlite3,
and only trigger it using Python (2.6) with its sqlite3 module.
- Eric
On Tue, Apr 5, 2011 at 5:21 PM, Eric Promislow wrote:
> This won't be a trivial case to reproduce -- I need to create two tables,
> with several rows,
On 6 Apr 2011, at 5:06pm, Nikolaus Rath wrote:
> Another question though: what is the recommended way to insert lots of
> data with WAL enabled? Without a transaction, the WAL file stays small
> but the insertions take very long time. With a transaction, things are
> faster but the WAL file grows
On Wed, Apr 6, 2011 at 6:11 PM, Technology Lighthouse wrote:
> Thanks Stephan and Simon - I kind of figured it was one of those "how
> long is a ball of string" questions, but I just wanted to check there
> weren't any particular gotchas to watch out for.
>
LOL, i'll have to remember the ball of
Thanks Stephan and Simon - I kind of figured it was one of those "how
long is a ball of string" questions, but I just wanted to check there
weren't any particular gotchas to watch out for.
Regarding the separate files, it seems the best way to go. Each
individual table could get pretty large (p
On Wed, 6 Apr 2011 00:08:47 +0300, Gert Van Assche
wrote:
>Dear all,
>
>what would be the best way to read a full txt file into one record?
>Now, when I use
> .import FILE TABLE
>I have every line on a record.
>
>I need all lines of one file on one record.
>The next record I need to fill with
Pavel Ivanov writes:
>> 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 mark
Igor Tandetnik writes:
> On 4/5/2011 10:01 PM, Nikolaus Rath wrote:
>> I'm experimenting with creation of a 156 MB database from scratch. I've
>> set synchronous = NORMAL and locking_mode = exlusive.
>>
>> With journal_mode = off and without wrapping the INSERTs into a
>> transaction, creating the
Awesome! Thank you.
> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Enrico Thierbach
> Sent: Wednesday, April 06, 2011 11:16 AM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Increment a row value..
On 06.04.2011, at 17:13, John D. Marinuzzi wrote:
> Hello,
>
>
>
> Perhaps this is more of a SQL question, but I am curious if SQLite has some
> kind of implementation for incrementing an integer within a row without
> actually reading the value and then updating the record. Is that possible?
Hello,
Perhaps this is more of a SQL question, but I am curious if SQLite has some
kind of implementation for incrementing an integer within a row without
actually reading the value and then updating the record. Is that possible?
Thanks,
John
__
> Two ? One for the page holding the table, another for the page holding the
> primary key ?
If table has INTEGER PRIMARY KEY then it is the same page I believe.
:) I.e. table storage is in fact an index on rowid (or its alias).
Pavel
On Wed, Apr 6, 2011 at 10:50 AM, Simon Slavin 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.
___
> 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 chan
>3. edit the database file with a hex editor, replacing "~~" with "0D 0A".
That seems pretty dangerous! Rather update the table using the
standard replace() function.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-
jarno.lavikonm...@nokia.com wrote:
> So I defined
>
> #define SQLITE_ENABLE_ICU
>
> Then I try call to create collation:
>
>int iRetVal =
> sqlite3_create_collation(m_sqliteDb,pstrDbName,SQLITE_UTF8,NULL,sqliteLocaleAwareCompare);
You are implementing your own custom collation. What do
Hi,
I think I found a bug creating an encrypted backup.
The source database is encrypted using key:
aes256:A94A8FE5CCB19BA61C4C0873D391E987982FBBD3
The source database is readable, I can run select queries and insert data
with no problem.
When I use the following function to create a
From: Gert Van Assche
To: sqlite-users@sqlite.org
Sent: Wed, April 6, 2011 12:08:47 AM
Subject: [sqlite] read full txt file in one record
>Dear all,
>what would be the best way to read a full txt file into one record?
Until the experts reply to this, I'll try
Hi ,
We are facing some issues now, when we need to make SQL queries and in our
databases there are non ASCII characters, and SQL queries should be case
insensitive ..
Then I read from the documentationn about enable ICU for sqlite
So I defined
#define SQLITE_ENABLE_ICU
Then I try call to
Hi,
I am pleased to announce the release of ODB 1.3.0.
ODB is an open-source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.
Thi
On Wed, Apr 6, 2011 at 6:36 AM, Dan Kennedy wrote:
> On 04/05/2011 04:49 PM, Filip Navara wrote:
>> Hello,
>>
>> we are having problem with database that originated on computer of one
>> of our customers.
>>
>> The database is used in WAL mode with auto_vacuum=1 and page_size=1024.
>>
>> When runn
26 matches
Mail list logo