[sqlite] System.Data.SQLite, Need alternate way to get field length

William Drago wrote: > I am trying to determine the number of bytes in a blob. According to the help > file under SQLiteDataReader.GetBytes Method in the Remarks section: > > "To determine the number of bytes in the column, pass a null value for the > buffer. The total length will be returned."

[sqlite] Multiple instances of the same program accessing the same db file

On 5/2/15, Scott Doctor wrote: > > Is the PRAGMA value the retry interval, or the timeout where it > aborts and reports a failure? > The timeout. -- D. Richard Hipp drh at sqlite.org

[sqlite] Multiple instances of the same program accessing the same db file

hmm, I am using sqlite as a project file that keeps track of a variety of information (usually a couple dozen megabytes in size per project). My initial post assumed a single user with a couple windows open. The file might be accessed by another user on a local area network. Usually no more

[sqlite] Multiple instances of the same program accessing the same db file

On Sat, May 2, 2015 at 7:03 PM, Scott Doctor wrote: > > To review, after opening the database, issue the PRAGMA busy_timeout = x, > with x being however long I want to wait before aborting. I can keep both > database handles open at the same time, but need to make sure I finalize > the

[sqlite] Multiple instances of the same program accessing the same db file

To review, after opening the database, issue the PRAGMA busy_timeout = x, with x being however long I want to wait before aborting. I can keep both database handles open at the same time, but need to make sure I finalize the operation before the timeout happens (assuming the other program is

[sqlite] Possible bug with locking/retying

If you look here: http://beets.radbox.org/blog/, you can see the blog entry is dated August 24th, 2012. Peter On 5/2/2015 5:18 PM, Simon Slavin wrote: > In searching for something else I came across this: > > > > I don't like the fact that

[sqlite] Multiple instances of the same program accessing the same db file

Is the PRAGMA value the retry interval, or the timeout where it aborts and reports a failure? Scott Doctor scott at scottdoctor.com -- On 5/2/2015 5:08 PM, Simon Slavin wrote: > On 3 May 2015, at 12:55am, J Decker wrote: > >> Yes, it really requires only a little

[sqlite] SQLite using internally by Windows 10

Great! Congrats! 2015-05-01 5:24 GMT+02:00 Richard Hipp : > https://twitter.com/john_lam/status/593837681945092096 > > -- > D. Richard Hipp > drh at sqlite.org > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org >

[sqlite] Multiple instances of the same program accessing the same db file

Yes, it really requires only a little additional work on application side. The native open will open it in read/write share allow, and handle interlocking. if you get a result of SQLITE_BUSY you need to retry the operation after a short time. On Sat, May 2, 2015 at 4:52 PM, Scott Doctor wrote:

[sqlite] Multiple instances of the same program accessing the same db file

I am somewhat new to sqlite and am trying to decide an issue with the program I am writing (cross platform, written in C/C++). After reading through the sqlite documentation, I am still unsure about the issue how to implement multiple instances of the same program. Consider a program that may

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

On 2 May 2015, at 12:14pm, Jean-Marie CUAZ wrote: > Yes, a few years ago on a test db, used for developpment and testing purpose, > "PRAGMA quick_check" reported some anomalies I would not continue to use any system which occasionally caused quick_check -- or more importantly integrity-check

[sqlite] Thoughts about enhancing "PRAGMA quick_check" speed

Thank you for your answers. To reply to Mr. Hipp and Mr. Morras : Yes your are right, verifications made, the process is I/O bound. (CPU activity jumps from 1% - 2% at iddle time to 5-6 % when a "PRAGMA quick_check" is processed). Thank you for pointing to me the right track ! About

[sqlite] SQLite using internally by Windows 10

Any details on SQLite in Windows 10? Don't remember anything in MS Build video cast last week. Closest, I could find were these two old posts: 1. USING SQLITE IN WINDOWS 10 UNIVERSAL APPS http://igrali.com/2015/05/01/using-sqlite-in-windows-10-universal-apps/ 2. SQLite.Net-PCL (Portable Code

[sqlite] System.Data.SQLite, Need alternate way to get field length

All, I am trying to determine the number of bytes in a blob. According to the help file under SQLiteDataReader.GetBytes Method in the Remarks section: "To determine the number of bytes in the column, pass a null value for the buffer. The total length will be returned." I'm working in VEE and