Re: [sqlite] Problem with incremental_vacuum and WAL

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

Re: [sqlite] No journal vs WAL journal

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

Re: [sqlite] No journal vs WAL journal

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

[sqlite] Fwd: Content filtered message notification

-- 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

Re: [sqlite] Access violation at address 6090B662 in module 'sqlite3.dll'. Read of address DE8D6B84

> 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

[sqlite] Access violation at address 6090B662 in module 'sqlite3.dll'. Read of address DE8D6B84

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

Re: [sqlite] substr fails in a query: looks like a bug

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

Re: [sqlite] No journal vs WAL journal

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

Re: [sqlite] Balance between keeping DBs open vs repeated open/close

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

[sqlite] Balance between keeping DBs open vs repeated open/close

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

Re: [sqlite] read full txt file in one record

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

Re: [sqlite] No journal vs WAL journal

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? > >

Re: [sqlite] No journal vs WAL journal

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

Re: [sqlite] Increment a row value...

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

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

[sqlite] Increment a row value...

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

Re: [sqlite] No journal vs WAL journal

> 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

Re: [sqlite] No journal vs WAL journal

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.

Re: [sqlite] No journal vs WAL journal

> 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

Re: [sqlite] read full txt file in one record

>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

Re: [sqlite] Sqlite and Create_collation

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

[sqlite] Bug: SQLite Encryption Extension And Backup API

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

Re: [sqlite] read full txt file in one record

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

[sqlite] Sqlite and Create_collation

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

[sqlite] [ANN] ODB C++ ORM 1.3.0 released, adds support for SQLite

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.

Re: [sqlite] Problem with incremental_vacuum and WAL

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