Re: [sqlite] A read right after a write does not read changes

On 2013.12.10 6:59 PM, Paul Bainter wrote: I'm using Entity Framework to access my SQLite database and I wrote a routine today that edits an existing table record. Then in the same program (step 2), I use the key that I just used to modify the record and I create a new instance of the same

[sqlite] SQLITE_ENABLE_STAT3/4 causing expensive statement recompilation

Hi, I'm finding that if I compile with either SQLITE_ENABLE_STAT3 or SQLITE_ENABLE_STAT4, repeatedly executing a prepared SELECT statement is substantially slower. I have a silly benchmark app that populates a database with test data, creates some pertinent indexes, runs ANALYZE, then executes a

Re: [sqlite] Concrete example of corruption

At 08:45 11/12/2013, you wrote: My case wasn't about messing anything up, but simply moving a document. Just like moving the canvas while the artist is painting? Or is it moving the notebook while the schoolkid writes on it? This is prone to produce dribbles or worse, in my view. I fail to

Re: [sqlite] sqlite3 shell .import bug (edge case)

Thanks for the test case. Fixed at http://www.sqlite.org/src/info/5e239ecda0 On Wed, Dec 11, 2013 at 6:37 AM, Lindsay Lawrence wrote: > Hi, > > I am currently using sqlite3 version: > > 3.8.1 2013-10-17 12:57:35 c78be6d786c19073b3a6730dfe3fb1be54f5657a > > I found an edge

Re: [sqlite] Support for read-only DB on Windows Phone SD Card

Gavin Harriss wrote: > I'm wondering if there's plans for the Windows Phone implementation to > support read-only databases on the SD card? > > > I expect that the SQLite implementation for the phone tries to open the > > database using standard C file API rather than using the Storage > > objects

Re: [sqlite] Support for read-only DB on Windows Phone SD Card

On 10 Dec 2013, at 9:34pm, Gavin Harriss wrote: > In theory it would be possible to update SQLite to use Storage objects, but > I suspect it would be a significant project to do so. I /think/ it would be possible to do this using just a custom VFS, leaving the rest of

Re: [sqlite] Can FTS snippet function return multiple fragments from one column in one row?

Lubos Staracek wrote: > From what I've seen here: > http://www.mail-archive.com/sqlite-users@sqlite.org/msg57661.html I assume > that snippet would return one text fragment for each column that have > matched searched phrase. Snippet is called once for each matching record. So it returns at most

[sqlite] sqlite3 shell .import bug (edge case)

Hi, I am currently using sqlite3 version: 3.8.1 2013-10-17 12:57:35 c78be6d786c19073b3a6730dfe3fb1be54f5657a I found an edge case bug in the sqlite3 shell when importing csv data with fields containing embedded quotes, CRs and LFs: When a field contains an embedded quote, and that embedded

[sqlite] Support for read-only DB on Windows Phone SD Card

Hi, Thanks for making your useful SQLite libraries freely available - much appreciated! I'm wondering if there's plans for the Windows Phone implementation to support read-only databases on the SD card? Here's some feedback from a Microsoft employee I had while trying to work with SQLite DB's on