[sqlite] Manual call to sqlite3_wal_checkpoint

I have turned off using PRAGMA wal_autocheckpoint = 0. There is a background thread which would call sqlite3_wal_checkpoint at some interval of time to ensue that WAL size does not grow big. I dont see any error returned by API sqlite3_wal_checkpoint. Also I dont see WAL size being reduced

Re: [sqlite] Manual

On 03 Mar 2012 at 15:57, Mark Schonewille wrote: > Could you just tell me where I find a good on-line manual? Thanks. I'm not aware of any similar to the mysql one - but perhaps I haven't looked particularly. But you didn't answer my question about the

Re: [sqlite] Manual

On Mar 3, 2012, at 4:57 PM, Mark Schonewille wrote: > Could you just tell me where I find a good on-line manual? As this is a pro bono project, you are not entitled to anything aside from the kindness of strangers. Don't waste it. ___ sqlite-users

Re: [sqlite] Manual

On Mar 3, 2012, at 4:15 PM, Mark Schonewille wrote: > How do I read diagrammes like http://sqlite.org/images/syntax/sql-stmt.gif ? It's a called a syntax diagram: http://en.wikipedia.org/wiki/Syntax_diagram > Where can I find a good reference manual? http://www.sqlite.org/lang.html

Re: [sqlite] Manual

On 03-03-2012 17:12, Luuk wrote: > On 03-03-2012 17:08, Mark Schonewille wrote: >> Luuk, >> >> You're invited to write a good, simple explanation as to how to read those >> diagrams. >> >> -- > > Can you explain which part it is, you don't understand? or take a look at:

Re: [sqlite] Manual

Follow the arrow... Noël Le 3/03/2012 17:08, Mark Schonewille a écrit : Luuk, You're invited to write a good, simple explanation as to how to read those diagrams. -- Best regards, Mark Schonewille ___ sqlite-users mailing list

Re: [sqlite] Manual

On 03-03-2012 17:08, Mark Schonewille wrote: > Luuk, > > You're invited to write a good, simple explanation as to how to read those > diagrams. > > -- Can you explain which part it is, you don't understand? ___ sqlite-users mailing list

Re: [sqlite] Manual

Luuk, You're invited to write a good, simple explanation as to how to read those diagrams. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer

Re: [sqlite] Manual

Tim, Could you just tell me where I find a good on-line manual? Thanks. -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage: http://economy-x-talk.com Twitter: http://twitter.com/xtalkprogrammer KvK: 50277553 Download the Installer Maker Plugin 1.7

Re: [sqlite] Manual

On 03-03-2012 16:43, Tim Streater wrote: > On 03 Mar 2012 at 15:15, Mark Schonewille > wrote: > >> MySQL has a really great manual with extensive explanations and dozens of >> examples for each command. SQLite is none of all this. It just has a limited >>

Re: [sqlite] Manual

On 03 Mar 2012 at 15:15, Mark Schonewille wrote: > MySQL has a really great manual with extensive explanations and dozens of > examples for each command. SQLite is none of all this. It just has a limited > number of pages listing a small number of commands and

Re: [sqlite] Manual

John, Every diagram needs instructions about how to read it. There are no such instructions on the SQLite site. So, my question remains, where do I find a good reference manual like that of MySQL? -- Best regards, Mark Schonewille Economy-x-Talk Consulting and Software Engineering Homepage:

Re: [sqlite] Manual

On 03-03-2012 16:39, John Drescher wrote: > On Sat, Mar 3, 2012 at 10:15 AM, Mark Schonewille > wrote: >> Hi, >> >> MySQL has a really great manual with extensive explanations and dozens of >> examples for each command. SQLite is none of all this. It just has a

Re: [sqlite] Manual

On 03-03-2012 16:15, Mark Schonewille wrote: > Hi, > > MySQL has a really great manual with extensive explanations and dozens of > examples for each command. SQLite is none of all this. It just has a limited > number of pages listing a small number of commands and some special features. > It

Re: [sqlite] Manual

On Sat, Mar 3, 2012 at 10:15 AM, Mark Schonewille wrote: > Hi, > > MySQL has a really great manual with extensive explanations and dozens of > examples for each command. SQLite is none of all this. It just has a limited > number of pages listing a small number

[sqlite] Manual

Hi, MySQL has a really great manual with extensive explanations and dozens of examples for each command. SQLite is none of all this. It just has a limited number of pages listing a small number of commands and some special features. It also has a number of really weird diagrammes. How do I

Re: [sqlite] Manual flush before commit

On 14 Feb 2010, at 6:49am, Michael Tharp wrote: > On 02/14/2010 01:09 AM, Simon Slavin wrote: >> read the distinctions between the different types of 'BEGIN'. > > I don't see any mention of flushing behaviour, just earlier locks. I > guess what I'm asking for is a lightweight two-phase commit,

Re: [sqlite] Manual flush before commit

On 02/14/2010 01:09 AM, Simon Slavin wrote: > read the distinctions between the different types of 'BEGIN'. I don't see any mention of flushing behaviour, just earlier locks. I guess what I'm asking for is a lightweight two-phase commit, which seems easy enough to do given the current

Re: [sqlite] Manual flush before commit

On 14 Feb 2010, at 5:32am, Michael Tharp wrote: > I see that a sqlite commit is split into two distinct phases, the first > being acquiring an exclusive lock and flushing dirty pages and the > second being the unlinking of the journal which constitutes the actual > commit. I would like to

[sqlite] Manual flush before commit

Hullo, I have a package manager that consists of a sqlite database combined with a filesystem journal that is created during system updates. The journal contains enough information to clean up the filesystem if an update is interrupted by e.g. a power failure. Naturally, these two journals

Re: [sqlite] manual with sample C programs

there are many errors in the codes. but still worthwhile to go through them carefully. liubin liu wrote: > > This's very good! > > I just download the codes from here: > http://www.apress.com/book/downloadfile/2847 > > > dcharno wrote: >> >>> Could you tell me where can I find such

Re: [sqlite] manual with sample C programs

This's very good! I just download the codes from here: http://www.apress.com/book/downloadfile/2847 dcharno wrote: > >> Could you tell me where can I find such documentation, or can you >> recommend some books. > > "The Definitive Guide to SQLite" by Michael Owens explains the SQLite > API

Re: [sqlite] manual with sample C programs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 P Kishor wrote: > hmmm... my amalgamation tarball does have shell.c separately from > sqlite3.c. You sure you got the right source? The .zip amalgamation only includes sqlite3.c, sqlite3ext.h and sqlite3.h. The .tar.gz amalgamation also includes the

Re: [sqlite] manual with sample C programs

-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor Sent: Thursday, February 26, 2009 2:15 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] manual with sample C programs On Thu, Feb 26, 2009 at 3:06 PM, J. R

Re: [sqlite] manual with sample C programs

--- > J. R. Westmoreland > E-mail: j...@jrw.org > > > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of P Kishor > Sent: Thursday, February 26, 2009 1:58 PM > To: General Discussion of SQLi

Re: [sqlite] manual with sample C programs

, 2009 1:58 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] manual with sample C programs On Thu, Feb 26, 2009 at 2:50 PM, J. R. Westmoreland <j...@jrw.org> wrote: > Where do I find the source to the command-line tool. I looked but didn't see > it. > Sorry if this sh

Re: [sqlite] manual with sample C programs

nal Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Kees Nuyt > Sent: Thursday, February 26, 2009 12:05 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] manual with sample C programs > > > On Wed, 25 Feb 2009 19:5

Re: [sqlite] manual with sample C programs

] On Behalf Of Kees Nuyt Sent: Thursday, February 26, 2009 12:05 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] manual with sample C programs On Wed, 25 Feb 2009 19:51:07 -0500 (EST), Michael (mrobi...@cs.fiu.edu) wrote: >Hello users group, > >I have been looking in the documentation f

Re: [sqlite] manual with sample C programs

On Wed, 25 Feb 2009 19:51:07 -0500 (EST), Michael (mrobi...@cs.fiu.edu) wrote: >Hello users group, > >I have been looking in the documentation for sample programs >in C, but no luck yet. The source of the sqlite3 commandline tool may serve as an example. Alternatively, you could take a look at

Re: [sqlite] manual with sample C programs

> Could you tell me where can I find such documentation, or can you > recommend some books. "The Definitive Guide to SQLite" by Michael Owens explains the SQLite API in detail and provides a number of samples in C. ___ sqlite-users mailing list

[sqlite] manual with sample C programs

Hello users group, I have been looking in the documentation for sample programs in C, but no luck yet. Could you tell me where can I find such documentation, or can you recommend some books. Thanks very much Michael R ___ sqlite-users mailing list

Re: [sqlite] manual? documentation?

See: http://sqlzoo.net/ A Gentle Introduction to SQL e Wednesday, January 14, 2004, 2:22:23 PM, you wrote: > Been all through the wiki and didn't find any > first-time-get-you-started-basic-how-to. Thanks though. - To

Re: [sqlite] manual? documentation?

Are there any manuals or further documentation for SQLite than what is found on sqlite.org? I assume that most the database interaction stuff is pretty straight forward for individuals with database administration experience, but SQLite is my first database. Most of the documentation is for

Re: [sqlite] manual? documentation?

> Are there any manuals or further documentation for SQLite than > what is found on sqlite.org? > > I assume that most the database interaction stuff is pretty > straight forward for individuals with database administration > experience, but SQLite is my first database. Most of the >

Re: [sqlite] manual? documentation?

If you haven't already, go to the bottom of the main page at sqlite.org and click on the link to the wiki; then click on contents. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]