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

2012-09-14 Thread Pavel Ivanov
On Thu, Sep 13, 2012 at 9:29 PM, Igor Tandetnik itandet...@mvps.org wrote: Pavel Ivanov paiva...@gmail.com wrote: On Thu, Sep 13, 2012 at 3:36 PM, Igor Tandetnik itandet...@mvps.org wrote: On 9/13/2012 4:39 PM, Petite Abeille wrote: On Sep 13, 2012, at 10:24 PM, Igor Tandetnik

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

2012-09-14 Thread Felix Obermaier
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] System.Data.SQLite: Add [app|web].config file to NuGetpackage

2012-09-14 Thread Joe Mistachkin
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] Javascript API for SQLite?

2012-09-14 Thread Jean-Denis Muys
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

[sqlite] SQLite Compile Bug for Windows 8

2012-09-14 Thread Chang Li
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

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

2012-09-14 Thread Rob Richardson
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 =

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

2012-09-14 Thread Igor Tandetnik
Pavel Ivanov paiva...@gmail.com 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 transaction can

Re: [sqlite] SQLite Compile Bug for Windows 8

2012-09-14 Thread Igor Tandetnik
Chang Li changli...@hotmail.com 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] Javascript API for SQLite?

2012-09-14 Thread Simon Slavin
On 13 Sep 2012, at 3:13pm, Jean-Denis Muys jdm...@cmd-informatique.com 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 write

Re: [sqlite] Javascript API for SQLite?

2012-09-14 Thread Clemens Ladisch
Jean-Denis Muys wrote: I am now looking for a Javascript implementation of the SQLite library. https://github.com/kripken/sql.js 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 the

Re: [sqlite] Javascript API for SQLite?

2012-09-14 Thread Eleytherios Stamatogiannakis
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?

2012-09-14 Thread Etienne
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 am

Re: [sqlite] SQLite Compile Bug for Windows 8

2012-09-14 Thread Teg
Hello Igor, Friday, September 14, 2012, 8:59:54 AM, you wrote: IT Chang Li changli...@hotmail.com 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 written in

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

2012-09-14 Thread Pavel Ivanov
On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik itandet...@mvps.org wrote: Pavel Ivanov paiva...@gmail.com 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

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

2012-09-14 Thread Igor Tandetnik
On 9/14/2012 10:36 AM, Pavel Ivanov wrote: On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik itandet...@mvps.org 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, fetch,

Re: [sqlite] Covering index scan optimization

2012-09-14 Thread Clemens Ladisch
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 BY clause:

Re: [sqlite] Covering index scan optimization

2012-09-14 Thread Roger Binns
-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 more

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

2012-09-14 Thread Pavel Ivanov
On Fri, Sep 14, 2012 at 8:57 AM, Igor Tandetnik itandet...@mvps.org wrote: On 9/14/2012 10:36 AM, Pavel Ivanov wrote: On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik itandet...@mvps.org wrote: Wait a minute. If statement-level read consistency only applies to two queries in different