[sqlite] Backup API and WAL

If I use the backup API to create a copy of an SQLite database that uses Write-Ahead Logging, will the resulting copy reflect the contents of both the base database file and the -wal file? Regards, Donald Shepherd.

[sqlite] sqlite vfs and wal mode

I see; the first part... " result of the pragma or the error message if the pragma fails" I missed the or part... or rather missed the part before the or. On Sun, Feb 22, 2015 at 8:13 PM, J Decker wrote: > So now that I have the added complexity of my own vfs in which to make a > sqlite

[sqlite] (no subject)

Please dnt spam my email

[sqlite] sqlite vfs and wal mode

So now that I have the added complexity of my own vfs in which to make a sqlite vfs... I'm having some issues. Hmm... One of the first things I do is 'pragma journal_mode=WAL' I return sqlite_ok; but the result has 0 columns, whereas my command line tool returns a column 'journal_mode' and a row

[sqlite] Sqlite3 tutorial and reference manuals?

On Sun, 22 Feb 2015 13:10:25 -0500 russ lyttle wrote: > Contiki-os sounds interesting, especially if it can be adapted to run > sqlite3 on an Arduino UNO or MEGA (with attached SD card). Has anyone > attempted such a thing? > > The "natural" language for the Raspberry PI is Python. For Arduino

[sqlite] Sqlite3 tutorial and reference manuals?

On 22 Feb 2015, at 6:10pm, russ lyttle wrote: > The "natural" language for the Raspberry PI is Python. For Arduino it is > C++. Arduinos are programmed in 'Wiring' which is descended from 'Processing', which is a very small subset of C++ with a few library functions added. It's so small

[sqlite] Sqlite3 tutorial and reference manuals?

I like the internet capabilities of the contiki-os. -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150222/a621e190/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

didn't come close to meeting time constraints or being maintainable. -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150222/20fa2dc5/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

lt;http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150222/0f38c46d/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- next part -- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 473 bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150222/0fc65907/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

On Sat, 21 Feb 2015 23:04:53 -0500 russ lyttle wrote: > Thanks. > I doing building automation using Raspberry Pi, Arduino, and zigbee > devices. I started with Python, but that is too slow, so I would like > to move to C++. Dropped messages are not acceptable, and response to > user actions

[sqlite] Sqlite3 tutorial and reference manuals?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/22/2015 10:10 AM, russ lyttle wrote: > The "natural" language for the Raspberry PI is Python. For Arduino > it is C++. I've confirmed that both PERL and Python drop too many > messages when using my naif DB with sqlite3, R-PI model A, and Digi >