[sqlite] I have a database working directly from

http://www.w3.org/TR/2010/NOTE-webdatabase-20101118/ //I can open a database // write to it, read from it. // But I would like access to the hidden database it creates. // I look everywhere, cannot find it! var databaseOptions = { fileName: "file://localhost/C:/R/work/test.db", version: "1.0",

Re: [sqlite] jquery sqlite3

On 7 Mar 2011, at 2:49am, Matt Young wrote: > Trying to understand it. How do I specifically open sqlite from a jquery > widget. > Or best simple example. jquery is just a JavaScript library. JavaScript can't open a file on your hard disk. Because if JavaScript could open a file on your

[sqlite] jquery sqlite3

Trying to understand it. How do I specifically open sqlite from a jquery widget. Or best simple example. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] BUG: test script e_vacuum.test needs has_codec

According to vacuum.c /* A VACUUM cannot change the pagesize of an encrypted database. */ So the tests in e_vacuum.test which attempt to change page size need to be bracked with a test for codec something like the following # Determine if there is a codec available on this test. # if

Re: [sqlite] Attaching vfs

On Mon, Mar 7, 2011 at 2:56 AM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 03/06/2011 03:04 PM, Max Vlasov wrote: > > I don't think I need a solution that complex. > > You need to be very careful with your terminology :-) > > As for getting

Re: [sqlite] Attaching vfs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/06/2011 03:04 PM, Max Vlasov wrote: > I don't think I need a solution that complex. You need to be very careful with your terminology :-) As for getting other data into your database, just do a .dump of a different SQLite database and run it.

[sqlite] FTS3/FTS4+ICU segfault on NULLs

This code produce segfault on current trunk SQLite and some previous releases (3.7.0.1 and 3.7.3): CREATE VIRTUAL TABLE fts USING fts3(name,TOKENIZE icu ru_RU); insert into fts (name) values (NULL); insert into fts (name) values (NULL); delete from fts; Or: CREATE VIRTUAL TABLE fts USING

Re: [sqlite] FTS4 bug: last_insert_rowid() fail

This is regression from FTS3 to FTS4 and may crash some applications. 2011/3/7 Roger Binns : > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > See also http://www.sqlite.org/src/tktview?name=13137dccf3 > > Roger > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.4.10

Re: [sqlite] Attaching vfs

On Sun, Mar 6, 2011 at 9:00 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 03/06/2011 06:31 AM, Max Vlasov wrote: > > For example, currently it's not > > possible for some exotic vfs to selectively import data from a > conventional > >

Re: [sqlite] FTS4 bug: last_insert_rowid() fail

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 See also http://www.sqlite.org/src/tktview?name=13137dccf3 Roger -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

[sqlite] FTS4 bug: last_insert_rowid() fail

Test: ### #!/usr/bin/tclsh8.5 package require sqlite3 sqlite3 db :memory: db function elog elog proc elog {args} { puts [join $args] } db eval { CREATE TABLE test (id INTEGER PRIMARY KEY); CREATE VIRTUAL TABLE fts3 USING fts3(name); CREATE VIRTUAL TABLE fts4 USING fts4(name); select

Re: [sqlite] Feature request: hash function for fast indices on text and blob fields

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/06/2011 05:22 AM, Alexey Pechnikov wrote: > I think one or more hash functions may be > included into core SQLite. (Argggh. You posted the same message to multiple mailing lists. That is annoying.) Why can't you use the SQLite API in order

Re: [sqlite] Attaching vfs

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 03/06/2011 06:31 AM, Max Vlasov wrote: > For example, currently it's not > possible for some exotic vfs to selectively import data from a conventional > format db (CMIIW) A VFS is only used for reading and writing SQLite's btree pages. If you

Re: [sqlite] VB.net error on adding SQLite3.dll to ProjectReferences

Thanks everyone, this is sorted now. J Trahair - Original Message - From: jose simas To: General Discussion of SQLite Database Sent: Sunday, March 06, 2011 11:54 AM Subject: Re: [sqlite] VB.net error on adding SQLite3.dll to ProjectReferences Hi, Use System.Data.Sqlite

Re: [sqlite] Feature request: hash function for fast indices on text and blob fields

Yes, I have my extension for this http://sqlite.mobigroup.ru/dir?name=ext/murmurhash But I think the feature will be very helpful as core function. 2011/3/6 Enrico Thierbach : > > On 06.03.2011, at 14:22, Alexey Pechnikov wrote: > >> Sqlite does not has ability to compress

Re: [sqlite] Feature request: hash function for fast indices on text and blob fields

On 06.03.2011, at 14:22, Alexey Pechnikov wrote: > Sqlite does not has ability to compress indices. There is huge > performance problem with populating a database with indexed > text or blob fields. But we can emulate indices compression > by using index on hashed field (and populate the hash

[sqlite] Documentation bug?

I was trying to follow the documentation on FTS4 and found what I guess is a typo. In several places there is a reference to "document" where I believe it should be "documents" as the first term doesn't exist in any create statement. There are several of these in Appendix A

[sqlite] Attaching vfs

Hi, as long I understand for Attach command sqlite assumes the same vfs as the one used the the connection. Can this be extended to allow more communication possibilities between vfs'es? For example, currently it's not possible for some exotic vfs to selectively import data from a conventional

[sqlite] Feature request: hash function for fast indices on text and blob fields

Sqlite does not has ability to compress indices. There is huge performance problem with populating a database with indexed text or blob fields. But we can emulate indices compression by using index on hashed field (and populate the hash field by trigger as example). I think one or more hash

Re: [sqlite] VB.net error on adding SQLite3.dll to Project References

Hi, Use System.Data.Sqlite instead: http://sqlite.phxsoftware.com/ Regards, Jose On 3 March 2011 09:23, J Trahair wrote: > Hi everyone. > > VB.Net 2005, I am trying to add sqlite3.dll to the Project References. When I > try to Add the dll  I get an error