[sqlite] read uncommitted data consistency

2015-02-21 Thread Simon Slavin
On 21 Feb 2015, at 9:01pm, Yuriy Stelmakh wrote: > When using read uncommitted pragma, is it possible to get a row of data > where some columns reflect state of that row at one point, while others at > another? For example when you are reading in one thread while writing in > another. No.

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread russ lyttle
--- 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/20150221/752f584b/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread russ lyttle
e.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/20150221/5963113a/attachment.pgp>

[sqlite] read uncommitted data consistency

2015-02-21 Thread Yuriy Stelmakh
When using read uncommitted pragma, is it possible to get a row of data where some columns reflect state of that row at one point, while others at another? For example when you are reading in one thread while writing in another. Thank you!

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread Paolo Bolzoni
About SQL I like the w3c schools[1]; about sqlite how do you want to use it? Via C interface? If so, check the website "sqlite in 5 minutes or less"[2]. [1]http://www.w3schools.com/sql/ [2]https://www.sqlite.org/quickstart.html On Sat, Feb 21, 2015 at 7:33 PM, russ lyttle wrote: > I'm new to

[sqlite] read uncommitted data consistency

2015-02-21 Thread Jay Kreibich
On Feb 21, 2015, at 5:36 PM, Simon Slavin wrote: > > On 21 Feb 2015, at 9:01pm, Yuriy Stelmakh wrote: > >> When using read uncommitted pragma, is it possible to get a row of data >> where some columns reflect state of that row at one point, while others at >> another? For example when you

[sqlite] Reference material for SQLITE3

2015-02-21 Thread Igor Tandetnik
On 2/21/2015 1:43 PM, russ lyttle wrote: > I'm new to sqlite and would like some intermediate to advanced tutorial > and reference material. http://sqlite.org/docs.html -- Igor Tandetnik

[sqlite] Reference material for SQLITE3

2015-02-21 Thread russ lyttle
bytes Desc: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150221/33762c89/attachment.pgp>

[sqlite] Email Removal

2015-02-21 Thread Mike Brittain
Please remove me from all of your email lists. Thanks

[sqlite] sqlite tutorials and reference manuals?

2015-02-21 Thread russ lyttle
: OpenPGP digital signature URL: <http://mailinglists.sqlite.org/cgi-bin/mailman/private/sqlite-users/attachments/20150221/ec3c1906/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread russ lyttle
... 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/20150221/9356a802/attachment.pgp>

[sqlite] Sqlite3 tutorial and reference manuals?

2015-02-21 Thread Conery John
I really like Using SQLite, by Jay Kreibich (O?Reilly and Associates). Comprehensive coverage of SQLite plus useful information on database design. John Conery > On Feb 21, 2015, at 10:36 AM, Paolo Bolzoni gmail.com> wrote: > > About SQL I like the w3c schools[1]; about sqlite how do you