[sqlite] SQLite in Android N

It is my understanding that Android N will no longer allow apps to use the system-installed SQLite library (unless they go through the Android Java API, android.database.sqlite). This is unfortunate, as many existing Android apps do access libsqlite3 directly and will crash on Android N. Apps

Re: [sqlite] SQLite in Android N

Official, but slightly vague: https://developer.android.com/preview/behavior-changes.html#ndk >From Xamarin: https://developer.xamarin.com/releases/android/xamarin.android_6/xamarin.android_6.0/ -- E On Mon, Jun 6, 2016 at 12:40 PM, Jason H wrote: > > It is my understanding

[sqlite] SQLite database becomes corrupt on iOS

https://www.sqlite.org/howtocorrupt.html I know you said you already checked this, so just ignore the following remark: iOS is one of the easiest platforms to accidentally end up with "Multiple copies of SQLite linked into the same application". Just sayin'. -- E On Thu, Aug 13, 2015 at 2:04

[sqlite] What software is deployed more than SQLite?

Last time I asked myself this question, I ended up in the same place you did: zlib, libpng and libjpeg may be the only candidates in the same ballpark as SQLite. See also: https://news.ycombinator.com/item?id=4616740 -- E On Sun, May 3, 2015 at 1:18 PM, Richard Hipp wrote: > I'm trying to

[sqlite] Should System.Data.SQLite.EF6.SQLiteProviderServices be public?

After reading this: http://msdn.microsoft.com/en-us/data/jj680699.aspx about Code-based Configuration in EF6, I wonder if System.Data.SQLite.EF6.SQLiteProviderServices needs to be public (instead of internal), so that people could do something like this: public class

Re: [sqlite] SQLite3_create_collation

Does this mean all your interaction with SQLite is happening through Core Data? E On Apr 2, 2014 1:05 PM, "Donald Steele" wrote: > I am working in iOS (aka ObjC) so I am using it's built in framework for > all my SQLite calls. > > > On Apr 2, 2014, at 10:58 AM, Simon

Re: [sqlite] SQLite version 3.8.6 coming soon

FWIW, the Zumero test suite is fairly abusive and it passes all test cases with 3.8.6 beta. -- E On Thu, Aug 7, 2014 at 11:59 AM, Richard Hipp wrote: > On Thu, Aug 7, 2014 at 10:01 AM, E.Pasma wrote: > > > I have a case where a primary key index is no

Re: [sqlite] Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1?

Short answer: no. Longer answer: Microsoft does not (yet?) support ADO on WinRT or WP8, much less on Xamarin platforms. But it looks like the future holds a glimmer of hope. Their vNext project seems to be heading toward portable ADO, and also includes SQLite support:

Re: [sqlite] MS open source Portable Class Library for SQLite

I would describe the msopentech PCL wrapper as "slightly thick" (because it's trying to be higher level than the sqlite3 API itself), and "quite narrow" (because it covers only a small part of the underlying sqlite3 API). Related and possibly of interest: My own C# wrapper is a fork of the one

[sqlite] Performance comparison between SQLite and SQL Server?

Just for fun: I know a friend who has a Ferrari. It is faster than my Ford F-150. Unless we are racing with both vehicles pulling a 7,000 pound trailer uphill. Then I would probably win. Thousand-mile trip? Take a sports car. Moving a couch a thousand miles? Use a pickup truck. SQLite is

Re: [sqlite] SQLite in Android N

rt of the NDK? -- E On Mon, Jun 6, 2016 at 12:26 PM, Eric Sink <e...@sourcegear.com> wrote: > > It is my understanding that Android N will no longer allow apps to use the > system-installed SQLite library (unless they go through the Android Java > API, android.database.sqlite). >

[sqlite] sqlite3_initialize() before sqlite3_randomness()

So it appears that if the very first SQLite function you call is sqlite3_randomness(), it crashes. And if you call sqlite3_initialize() first, it does not crash. Just thought I should let somebody know... -- E ___ sqlite-users mailing list

Re: [sqlite] sqlite3_initialize() before sqlite3_randomness()

Yeah, I did read that page, but not well enough. I saw this: "Workstation applications using SQLite normally do not need to invoke either of these routines." And this (all-caps emphasis mine): "The sqlite3_initialize() routine is called internally by MANY other SQLite interfaces so that

[sqlite] From SQLITE_CONSTRAINT to something more specific

I'm trying to use information from sqlite3_errmsg() to figure out what *kind* of SQLITE_CONSTRAINT happened. Cruising the archives of this mailing list, I see past discussions about the desire for really complete error information, including the name of the specific constraint that failed

Re: [sqlite] Return Value from sqlite3_exec()

In your example, the only way SQLite can do what you expect is to notice that your UPDATE didn't modify any rows. But you don't want an UPDATE statement throwing errors simply because it didn't modify any rows. There are many situations where that happens and is considered normal behavior.

[sqlite] Maybe bug with vtab xDestroy

In xRename, if I set zErrMsg and return SQLITE_ERROR, the error message gets through. In xDestroy, using the same code, the error message seems to get eaten. Bug? My code: static int my_Destroy(sqlite3_vtab *tab) { struct my_vtab* pvtab = (struct my_vtab*) tab; if (pvtab->zErrMsg)

Re: [sqlite] SQLite 3.7.16 beta

FWIW: I am working on a project which uses SQLite extensively. We generally use 3.7.11 on our client side and 3.7.15.2 on our server. I just switched both to this 3.7.16 beta, and all our automated tests still pass. -- E ___ sqlite-users

[sqlite] Announcing Zumero (commercial venture, built on SQLite)

I'll keep this short and low-key: Zumero is a sync solution for SQLite, designed for mobile devices. http://zumero.com/ Here's my blog post on it: http://ericsink.com/entries/announcing_zumero.html -- E ___ sqlite-users mailing list

[sqlite] System.Data.SQLite and sqlite3_prepare()

It looks like System.Data.SQLite uses sqlite3_prepare() instead of sqlite3_prepare_v2(). Is there a technical reason for this? Just curious. -- E ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] BEGIN IMMEDIATE and the busy handler

From reading sqlite3.c and the comments therein, it would appear that BEGIN IMMEDIATE TRANSACTION never invokes the busy handler. Is that correct? -- E ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] SQLite database on Dropbox, Google Drive, MS SkyDrive, Ubuntu One or SAMBA share

FYI: For a different approach, check out Zumero (http://zumero.com) which synchronizes SQLite changes within the db rather than the whole db as a file. Disclosure: I am a co-founder of Zumero, which is commercial, proprietary, non-open-source, etc. I mention this only because we often

Re: [sqlite] SQLite patch contribution

You could include us as another group who would like to see this functionality added to virtual tables. -- E On Jul 22, 2013, at 8:46 AM, Richard Hipp wrote: > On Mon, Jul 22, 2013 at 10:27 AM, Dušan Paulovič wrote: > >> So, in other words, there is no

Re: [sqlite] to encrypt sqlite db

SQLCipher is free. But it's not compatible with WinRT. I'm pretty sure that right now there is nothing that meets both of your requirements. -- E On Aug 31, 2013, at 8:52 AM, dd wrote: > Thank you for your quick response. > > I am looking for freeware. If freeware

Re: [sqlite] Details on New Features

Is this new syntax likely to perform any better than the traditional way of writing the query? -- E On May 4, 2012, at 11:42 AM, Nico Williams wrote: > On Fri, May 4, 2012 at 9:20 AM, Richard Hipp wrote: >>> Queries of the form: "SELECT

[sqlite] Two-line patch to fix memory leak

In sqlite3Fts3Matchinfo(): Near the end of the function, I added two lines: if( rc!=SQLITE_OK ){ sqlite3_result_error_code(pContext, rc); }else{ int n = pCsr->nMatchinfo * sizeof(u32); sqlite3_result_blob(pContext, pCsr->aMatchinfo, n, SQLITE_TRANSIENT); ADDED:

Re: [sqlite] Two-line patch to fix memory leak

to a small test case. For now, I can confirm that we have made no other changes to our copy of 3.7.11. Thanks, -- E On May 11, 2012, at 12:50 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 05/11/2012 11:28 PM, Eric Sink wrote: >> >> In sqlite3Fts3Matchinfo()

Re: [sqlite] SQLite in Android N

FWIW, I wrote a blog entry about this issue to shine a bit more light on it: http://ericsink.com/entries/sqlite_android_n.html -- E On Mon, Jun 13, 2016 at 3:51 PM, Richard Hipp <d...@sqlite.org> wrote: > On 6/13/16, Eric Sink <e...@sourcegear.com> wrote: > > "Ric

Re: [sqlite] Result code 5 from sqlite3_prepare_v2() in WAL mode?

t; On Mon, Sep 12, 2016 at 7:52 PM, Richard Hipp <d...@sqlite.org> wrote: > >> On 9/12/16, Eric Sink <e...@sourcegear.com> wrote: >> > OK, this seems like a simple thing, but I'm stuck and looking for >> > inspiration or clues. >> > >> >

Re: [sqlite] Result code 5 from sqlite3_prepare_v2() in WAL mode?

Excellent. Thanks. -- E On Tue, Sep 13, 2016 at 3:05 PM, Richard Hipp <d...@sqlite.org> wrote: > On 9/13/16, Eric Sink <e...@sourcegear.com> wrote: > > > > I can fit this into your explanation: > > > > "Another process might have opened the s

Re: [sqlite] Result code 5 from sqlite3_prepare_v2() in WAL mode?

This is happening in an Android app. No other process is involved, but the filesystem there is weird, so I'm focusing on the third possibility you mentioned. Thanks, -- E On Mon, Sep 12, 2016 at 7:52 PM, Richard Hipp <d...@sqlite.org> wrote: > On 9/12/16, Eric Sink <e...@so

[sqlite] Result code 5 from sqlite3_prepare_v2() in WAL mode?

OK, this seems like a simple thing, but I'm stuck and looking for inspiration or clues. How can sqlite3_prepare_v2() return SQLITE_BUSY for a simple SELECT statement when in WAL mode? Immediately prior, a sqlite3_exec("BEGIN TRANSACTION") succeeded. The failing call is just

Re: [sqlite] SQLite does not support ARM platform?

You are encountering a limitation of the compiler you are using, not a limitation of SQLite (which compiles for ARM just fine). The error message is telling you that Microsoft does not support desktop applications compiled for ARM. What environment are you trying to compile for? -- E On Mon,

[sqlite] Possible issue with 3.19.3

Greetings, Version 3.19.3 is yielding different results than previous releases for a query in the Entity Framework Core test suite. The query looks like this: SELECT [e].[Id], [e].[Discriminator], [e].[Name], [e].[BaseId], [t].[Id], [t].[BaseParentId], [t].[Discriminator], [t].[Name],