[sqlite] XML import/export t/from sqlite

Does anybody know of additions to SQLITE (.NET) to provide for XML import/export. TIA Christoph ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] XML import/export t/from sqlite

On 30 Nov 2011, at 8:33am, Christoph P.U. Kukulies wrote: > Does anybody know of additions to SQLITE (.NET) to provide for XML > import/export. SQLITE is just the bit that talks to SQLite databases. You can find some other .NET library which does XML import/export and write some programming

[sqlite] WAL file size

Hello, I have sqlite configure to do manual checkpoint. I do checkpoint every few hundred records. I expect the WAL to reduce in size and become zero when there are no more inserts done. However, I see that the WAL file size is static and does not reduce in size. Why isnt manual checkpoint

[sqlite] fsync of directories on AIX

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello there! In os_unix.c, the following logic appears in unixSync: /* Also fsync the directory containing the file if the DIRSYNC flag ** is set. This is a one-time occurrance. Many systems (examples: AIX) ** are unable to fsync a

[sqlite] Error when compiling with the SQLITE_OMIT_WALL directive

Hi all: Using MS VC++ 98, I try to compile the 3.7.9 amalgamation, using the SQLITE_OMIT_WAL directive, but then I get an error: sqlite3.c(131886) : error C2129: static function 'void sqlite3PagerClearCache(Pager *)' declared but not defined. I've used some other directives, but all of them

Re: [sqlite] Error when compiling with the SQLITE_OMIT_WALL directive

Sorry I mean MS V.Studio C++ 2008 (not 98) -- A.J.Millán ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Looping select

There is too much ambiguity with regards to needid; poor coding|edit checking on my part. When I label everything properly, then the query runs successfully (darn fast, too). I also changed the replacement tag @depth to @dpth. When I was examining everything with notepad++, it highlighted

[sqlite] Using VACUUM on an empty file will create a default database

I'm using sqlite3 3.7.9 on Ubuntu 12.04 dev. If the VACUUM command is used on empty files it will create a default database (for example "touch /tmp/test.txt && sqlite3 /tmp/test.txt VACUUM"). If this behaviour is wanted there should be an option to disable this because it could destroy

[sqlite] mandatory locks versus advisory locks

I have seen documentation that SQLite uses POSIX advisory locks to implement locking on Unix. I have an issue in that attempts to operate on a sqlite database on a Linux file system that has setgid bit (set group ID on execution) set on the database file (e.g. chmod g+s) causes database

Re: [sqlite] Using VACUUM on an empty file will create a defaultdatabase

sworddrag...@aol.com wrote: > I'm using sqlite3 3.7.9 on Ubuntu 12.04 dev. If the VACUUM command is used on > empty files it will create a default database (for > example "touch /tmp/test.txt && sqlite3 /tmp/test.txt VACUUM"). > > If this behaviour is wanted there should be an option to disable

Re: [sqlite] mandatory locks versus advisory locks

On 11/30/2011 06:55 AM, Andy Spencer wrote: I have seen documentation that SQLite uses POSIX advisory locks to implement locking on Unix. I have an issue in that attempts to operate on a sqlite database on a Linux file system that has setgid bit (set group ID on execution) set on the database

Re: [sqlite] WAL file size

On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP wrote: > Hello, > > I have sqlite configure to do manual checkpoint. I do checkpoint every few > hundred records. I expect the WAL to reduce in size and become zero when > there are no more inserts done. > However, I see that

Re: [sqlite] WAL file size

On Wed, Nov 30, 2011 at 4:02 PM, Richard Hipp wrote: > On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP >wrote: > > > Hello, > > > > I have sqlite configure to do manual checkpoint. I do checkpoint every > few > > hundred records. I expect the WAL to

Re: [sqlite] Error when compiling with the SQLITE_OMIT_WALL directive

This will be fixed in next version. See http://www.sqlite.org/src/info/5dbfaed8c3. Pavel On Wed, Nov 30, 2011 at 6:29 AM, Adolfo Jiménez Millán wrote: > Hi all: > > Using MS VC++ 98, I try to compile the 3.7.9 amalgamation, using the > SQLITE_OMIT_WAL directive, but then I get

Re: [sqlite] Inserting Multiple Rows in a single statement

> I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at > possibilities of making the insertions faster. Prepare your statement in the form INSERT INTO table_name (val1, val2, ...) VALUES (?1, ?2, ...) Then for each row you want to insert you will bind necessary values,

Re: [sqlite] Inserting Multiple Rows in a single statement

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 11/30/2011 03:41 PM, Pavel Ivanov wrote: >> I do have multiple insertions bounded by BEGIN-COMMIT . I am looking at >> possibilities of making the insertions faster. > > Prepare your statement in the form > > INSERT INTO table_name (val1, val2,

Re: [sqlite] WAL file size

Hello Richard, When does the WAL get trimmed down? If my transaction completes, does the WAL file get deleted? I've seen the WAL grow to 4 times my actual DB size so, I don't really want 160 Gigs of WAL hanging out when the process that generated it is only run once a month. Wednesday,

Re: [sqlite] WAL file size

Hi Richard, How does sqlite determine the right size for the WAL file? Application can ofcourse indicate the maximum size. -Sreekumar On Wed, Nov 30, 2011 at 4:02 PM, Richard Hipp wrote: > On Wed, Nov 30, 2011 at 4:41 AM, Sreekumar TP >wrote: > > >

Re: [sqlite] WAL file size

On Wed, Nov 30, 2011 at 1:04 PM, Teg wrote: > Hello Richard, > > When does the WAL get trimmed down? If my transaction completes, does > the WAL file get deleted? I've seen the WAL grow to 4 times my actual > DB size so, I don't really want 160 Gigs of WAL hanging out when the

Re: [sqlite] WAL file size

Maybe we need a "pragma wal_trim" ?? This would automatically trim it after a checkpoint? Or make it an explicit action? Waiting for another write before truncating it seems too late and not a logical thing to expect. Michael D. Black Senior Scientist Advanced Analytics Directorate

Re: [sqlite] Error when compiling with the SQLITE_OMIT_WALL directive

Pavel: Thanks for your answer. By the way, there are a similar error when using the directive SQLITE_OMIT_ANALYZE =0A-- Adolfo. > > Mensaje original > De: Pavel Ivanov > Para: a...@zator.com, General Discussion of SQLite Database > >

Re: [sqlite] WAL file size

Hello Richard, Appreciate the reply but, it doesn't address my question (unless I'm missing something). I get that checkpointing doesn't reduce the size of the WAL. Assuming a single writer and no readers, If I perform a transaction that generates a WAL file. Does it eventually get deleted when I

Re: [sqlite] Error when compiling with the SQLITE_OMIT_WALL directive

On Wed, Nov 30, 2011 at 1:30 PM, Adolfo Jiménez Millán wrote: > Pavel: > > Thanks for your answer. > > By the way, there are a similar error when using the directive > SQLITE_OMIT_ANALYZE > SQLITE_OMIT_ANALYZE won't work with the amalgamation because the amalgamation is generated

Re: [sqlite] WAL file size

On Wed, Nov 30, 2011 at 1:21 PM, Black, Michael (IS) wrote: > Maybe we need a "pragma wal_trim" ?? This would automatically trim it > after a checkpoint? Or make it an explicit action? > checkpoint cannot trim. This is because of the rule that checkpoints will never

Re: [sqlite] WAL file size

On Wed, Nov 30, 2011 at 1:39 PM, Teg wrote: > Hello Richard, > > Appreciate the reply but, it doesn't address my question (unless I'm > missing something). I get that checkpointing doesn't reduce the size > of the WAL. Assuming a single writer and no readers, If I perform a >

Re: [sqlite] WAL file size

Hello Richard, That's what I was hoping to hear. Thanks, Wednesday, November 30, 2011, 2:01:46 PM, you wrote: RH> On Wed, Nov 30, 2011 at 1:39 PM, Teg wrote: >> Hello Richard, >> >> Appreciate the reply but, it doesn't address my question (unless I'm >> missing something). I

Re: [sqlite] EXT :Re: WAL file size

So how about the "pragma wal_trim" that does a checkpoint, grabs the lock, trims, and drops the lock? Or some other new keyword? The WAL file never gets trimmed (just reused apparently) so having an explicit way to trim it without having to close and reopen the database would seem quite

Re: [sqlite] WAL file size

On 30 Nov 2011, at 7:01pm, Richard Hipp wrote: > The wal file persists until the last connection to the database closes, > then the wal file is deleted. Actually this is the key to a lot of questions about this. If your WAL file is taking up too much space, quit and restart your app. Or have

Re: [sqlite] WAL file size

Since we're on this topic If I open a 30 GB DB file, then attach a new empty DB and then select/insert all the data from the full DB to the empty one, the WAL file grows to 4 times the size of the source file. Why is that? I don't believe I use any manual checkpointing. Just let

Re: [sqlite] WAL file size

On Wed, Nov 30, 2011 at 5:31 PM, Teg wrote: > Since we're on this topic > > If I open a 30 GB DB file, then attach a new empty DB and then > select/insert all the data from the full DB to the empty one, the WAL > file grows to 4 times the size of the source file. Why

Re: [sqlite] WAL file size

Hello Richard, Thanks again. Wednesday, November 30, 2011, 5:37:32 PM, you wrote: RH> On Wed, Nov 30, 2011 at 5:31 PM, Teg wrote: >> Since we're on this topic >> >> If I open a 30 GB DB file, then attach a new empty DB and then >> select/insert all the data from

[sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

Hello, I'm using a recompiled version of SQLite in one project (I need FTS3 and now FTS4 support, which is not avaiable in the sqlite included in iOS). So I just include "sqlite3.c" and "sqlite3.h" in my XCode projet. I've discovered that using LLVM compiler of Xcode 4.2.1 on Mac OS Lion

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

Gilles, This is due to bugs in llvm when compiling for arm6 with thumb mode enabled. Passing -mno-thumb to the compiler will solve the problem. James On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote: > Hello, > > I'm using a recompiled version of SQLite in one project (I need FTS3 and now >

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

(you only need to turn off thumb mode for the arm6 architecture) -jdb On Nov 30, 2011, at 8:02 PM, James Berry wrote: > Gilles, > > This is due to bugs in llvm when compiling for arm6 with thumb mode enabled. > Passing -mno-thumb to the compiler will solve the problem. > > James > > On Nov

Re: [sqlite] sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

Le jeudi 1 décembre 2011, James Berry a écrit : > Gilles, > > This is due to bugs in llvm when compiling for arm6 with thumb mode enabled. Passing -mno-thumb to the compiler will solve the problem. > > James > > On Nov 30, 2011, at 4:31 PM, Gilles Vollant wrote: > >> Hello, >> >>

[sqlite] TR: sqlite 3.7.8 and sqlite 3.7.9 crash with Apple Xcode 4.2.1 on armv6 ios device

Thank you a lot for your answer. Do you known more about this bug? Is there any other documentation? Does it affect other code? Will apple fix it soon? My currenct solution was using sqlite 3.7.1 Regards Gilles Vollant Le jeudi 1 décembre 2011, James Berry a écrit : > Gilles,