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 u
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 k
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 whi
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 that Android N w
bsqlite
part of the NDK?
--
E
On Mon, Jun 6, 2016 at 12:26 PM, Eric Sink 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).
>
> This is
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 wrote:
> On 6/13/16, Eric Sink wrote:
> > "Richard (et al), you no doubt have some contact with the
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 sqlite3_prepare_v2(),
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 wrote:
> On 9/12/16, Eric Sink wrote:
> > OK, this seems
Sep 13, 2016 at 9:27 AM, Eric Sink wrote:
>
> 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,
Excellent. Thanks.
--
E
On Tue, Sep 13, 2016 at 3:05 PM, Richard Hipp wrote:
> On 9/13/16, Eric Sink wrote:
> >
> > I can fit this into your explanation:
> >
> > "Another process might have opened the same database with
> > locking_mode=EXCLUSIVE"
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, M
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], [t0].[Id],
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 MyConfigurat
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 Slavin wrote:
>
> >
> > On
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 longer used where it was
> > used before
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:
https://github.com/aspnet
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
fr
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
sqlite-
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 an
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 (a
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.
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) s
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 mailin
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
sqlit
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo
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
http://sqlite.org:8080/cgi-bin/mailman/lis
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 descri
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 way for programmers from EU to contri
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 not available, I have to
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 max(x), y FROM table" returns the
>>> value of
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:sqlite3_free(p
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 wrote:
> On 05/11/2012 11:28 PM, Eric Sink wrote:
>>
>> In sqlite3Fts3Matchinfo():
>>
>> Near the end of
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
33 matches
Mail list logo