Re: [sqlite] Getting query results as new records are added

On Fri, Sep 14, 2012 at 8:57 AM, Igor Tandetnik wrote: > On 9/14/2012 10:36 AM, Pavel Ivanov wrote: >> >> On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik >> wrote: >>> >>> Wait a minute. If "statement-level read consistency" only applies to two >>>

Re: [sqlite] Covering index scan optimization

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 >> Is there a chance that the change will go into SQLite mainline? > > Not without a copyright release. And it may require more especially if you are an employee. See the bottom section of http://www.sqlite.org/copyright.html And of course it is

Re: [sqlite] Covering index scan optimization

Elefterios Stamatogiannakis wrote: > On 13/09/12 23:02, Clemens Ladisch wrote: >> Eleytherios Stamatogiannakis wrote: >>> Is there a reason for SQLite to not use a covering index for scans? >> >> The query optimizer does not allow indexes that are not needed for some >> DISTINCT, WHERE, or ORDER

Re: [sqlite] Getting query results as new records are added

On 9/14/2012 10:36 AM, Pavel Ivanov wrote: On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik wrote: Wait a minute. If "statement-level read consistency" only applies to two queries in different transactions, what bearing, if any, does it have on your example of "open,

Re: [sqlite] Getting query results as new records are added

On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik wrote: > Pavel Ivanov wrote: >> There's another way how it could make sense - if you read that excerpt >> in context. ;-) The "statement-level read consistency" definition >> cited by Petite is the

Re: [sqlite] SQLite Compile Bug for Windows 8

Hello Igor, Friday, September 14, 2012, 8:59:54 AM, you wrote: IT> Chang Li wrote: >> At line 14573 require add (char *) for convert from (void *) >> >> z = (char *)sqlite3DbMallocRaw(db, (int)n); IT> Are you, by any chance, trying to compile in C++ mode? SQLite is IT>

Re: [sqlite] Javascript API for SQLite?

> I work on an application that uses an SQLite database as it's binary document > format (with a custom extension). Now we want to develop a Web App variation > of that application, that should be able to read and write those > documents/databases. Since the Web App is written in Javascript, I

Re: [sqlite] Javascript API for SQLite?

There is a version of SQLite compiled in Javascript: http://www.syntensity.com/static/sqlite_wip.html But as others said, it is not possible to do block access on files from inside a Web browser's contained Javascript VM. Nevertheless, theoretically you could load the full DB file in memory

Re: [sqlite] Javascript API for SQLite?

Jean-Denis Muys wrote: > I am now looking for a Javascript implementation of the SQLite library. says: | sql.js is a port of SQLite to JavaScript, by compiling the SQLite | C code with Emscripten. It's completely in-memory, but: | Database objects ... have

Re: [sqlite] Javascript API for SQLite?

On 13 Sep 2012, at 3:13pm, Jean-Denis Muys wrote: > I work on an application that uses an SQLite database as it's binary document > format (with a custom extension). Now we want to develop a Web App variation > of that application, that should be able to read and

Re: [sqlite] SQLite Compile Bug for Windows 8

Chang Li wrote: > At line 14573 require add (char *) for convert from (void *) > > z = (char *)sqlite3DbMallocRaw(db, (int)n); Are you, by any chance, trying to compile in C++ mode? SQLite is written in C, where such a cast is not required. -- Igor Tandetnik

Re: [sqlite] Getting query results as new records are added

Pavel Ivanov wrote: > There's another way how it could make sense - if you read that excerpt > in context. ;-) The "statement-level read consistency" definition > cited by Petite is the transaction isolation level. I.e. it defines > what each statement executed in one

Re: [sqlite] c++ - Tell SQLite3, read the subsequent rows

Igor, you didn't read ArbolOne's incomprehensible code correctly. Here it is with reasonable formatting: void mySQLite3::setStmt(const Glib::ustring& s) { SQLStatement = s; if (mystmt == NULL) { rc =

[sqlite] SQLite Compile Bug for Windows 8

At line 14573 require add (char *) for convert from (void *) z = (char *)sqlite3DbMallocRaw(db, (int)n); Sent from my Windows 8 PC ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Javascript API for SQLite?

Hello, I work on an application that uses an SQLite database as it's binary document format (with a custom extension). Now we want to develop a Web App variation of that application, that should be able to read and write those documents/databases. Since the Web App is written in Javascript, I

Re: [sqlite] System.Data.SQLite: Add [app|web].config file to NuGetpackage

Felix Obermaier wrote: > > Doesn't it make sense to add such a config file to the NuGet package? > I'm somewhat hesitant to add more complexity to the NuGet packages, especially since not every project requires this database provider block in their configuration file. The additional complexity

[sqlite] System.Data.SQLite: Add [app|web].config file to NuGet package

Hello, I want to use System.Data.SQLite by invoking it via DbProviderFactories.GetFactory(providerName). If I have an old version installed on my machine I always get that instead of the one inside the referenced NuGet package. If uninstall it, the call fails because it cannot be found. I

Re: [sqlite] Getting query results as new records are added

On Thu, Sep 13, 2012 at 9:29 PM, Igor Tandetnik wrote: > Pavel Ivanov wrote: >> On Thu, Sep 13, 2012 at 3:36 PM, Igor Tandetnik wrote: >>> On 9/13/2012 4:39 PM, Petite Abeille wrote: On Sep 13, 2012, at 10:24 PM, Igor