Re: [sqlite] The next release of SQLite....

Gidday Tim, >I will look further into this approach: > > select sqlite3_load_extension('mylibrary', 'entrypoint'); > >to see if Adobe's security permits it. However, the Adobe FlashBuilder >database application developer must confront this uncertainty: Adobe has >been unresponsive to questions

Re: [sqlite] The next release of SQLite....

Adobe has security "sandbox" requirements, so I would not want to disparage them for their decisions, though I do wish they would be more forthcoming with information. Regards Tim Romano Jean-Christophe Deschamps wrote: >>> Does Adobe actually filter out statements similar to: >>> >>>select

Re: [sqlite] The next release of SQLite....

Thanks very much for pointing this out, Jean-Christophe. Yes, glob is exactly what I wanted. I will look further into this approach: select sqlite3_load_extension('mylibrary', 'entrypoint'); to see if Adobe's security permits it. However, the Adobe FlashBuilder database application

Re: [sqlite] The next release of SQLite....

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Artur Reilin wrote: > Is somewhere a list of which sites of the documentation has changed? It > would be a little difficult to search for differences. Documentation is kept in a separate fossil repository than the SQLite source. You can see the

Re: [sqlite] The next release of SQLite....

On Dec 4, 2009, at 7:28 AM, John Brooks wrote: > In the new fts3.html, the statement: > > "each FTS3 table has a 'rowid' column that behaves like an INTEGER > PRIMARY KEY, except that values remain unchanged if the database is > rebuilt using the VACUUM command." > > is incorrect; an INTEGER

Re: [sqlite] The next release of SQLite....

Is somewhere a list of which sites of the documentation has changed? It would be a little difficult to search for differences. with best wishes - Artur - > BTW, this is why I added docid as an alias for rowid for fts3 > (rowid-versus-VACUUM was the initial reason for revving

Re: [sqlite] The next release of SQLite....

In the new fts3.html, the statement: "each FTS3 table has a 'rowid' column that behaves like an INTEGER PRIMARY KEY, except that values remain unchanged if the database is rebuilt using the VACUUM command." is incorrect; an INTEGER PRIMARY KEY column *does* remain unchanged during VACUUM, in

Re: [sqlite] The next release of SQLite....

Use the glob operator. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] The next release of SQLite....

Jay, That's a reasonable perspective, and indeed I have asked Adobe for the feature. But another not unreasonable position is this: to prevent fragmentation, enhancements that have general applicability are made to the core rather than to individual implementations. The more implementations

Re: [sqlite] The next release of SQLite....

On Thu, Dec 03, 2009 at 11:16:43PM +0100, Jean-Christophe Deschamps scratched on the wall: > >> > Does Adobe actually filter out statements similar to: >> > >> >select sqlite3_load_extension('mylibrary', 'entrypoint'); >> >> >> It is much more likely they simply do not call the C function

Re: [sqlite] The next release of SQLite....

On Thu, Dec 03, 2009 at 10:07:07PM +0100, Jean-Christophe Deschamps scratched on the wall: > Does Adobe actually filter out statements similar to: > >select sqlite3_load_extension('mylibrary', 'entrypoint'); It is much more likely they simply do not call the C function

Re: [sqlite] The next release of SQLite....

On Thu, Dec 3, 2009 at 10:26 AM, Tim Romano wrote: > The alternative, NOCASE collation, also does not get me out of the > woods. For some reason in Adobe (and in Mozilla) the index is not used > on LIKE clauses when the column in question has NOCASE collation, though >

Re: [sqlite] The next release of SQLite....

Hi Tim, > ... where myTextColumnUsingDefaultBinaryCollation like 'foo%' Did you try ... where myTextColumnUsingDefaultBinaryCollation glob 'foo*' GLOB is hardcoded as case-sensitive and more likely a candidate to using index. Just check it. >2. In Adobe, one is not able to load a

Re: [sqlite] The next release of SQLite....

>Last minute comments on the pending release of SQLite 3.6.21 are >welcomed. Thank you for your continued efforts. Can you consider making sqlite3_auto_extension and sqlite3_reset_auto_extension available into the API structure so that they can both be invoked from within an extension without

Re: [sqlite] The next release of SQLite....

On Thu, Dec 03, 2009 at 01:26:40PM -0500, Tim Romano scratched on the wall: > I have some ideas on how these two limiting features of Adobe's > implementation of SQLite might be addressed. I don't know how feasible > they might be given the existing codebase because I am not a C coder. If

Re: [sqlite] The next release of SQLite....

Since the consortium members are prominently listed on those pages, I hope it is not inappropriate if my comments refer to a couple of them. Nothing disparaging. As I am in the process of discovering (and so subject to revision/correction), there are a number of capabilities in SQLite that

Re: [sqlite] The next release of SQLite....

On Thu, Dec 3, 2009 at 12:01 PM, D. Richard Hipp wrote: > Last minute comments on the pending release of SQLite 3.6.21 are > welcomed.  Visit > >     http://www.sqlite.org/draft/index.html >     http://www.sqlite.org/draft/releaselog/3_6_21.html > with regards to the newly

[sqlite] The next release of SQLite....

Last minute comments on the pending release of SQLite 3.6.21 are welcomed. Visit http://www.sqlite.org/draft/index.html http://www.sqlite.org/draft/releaselog/3_6_21.html D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list