[sqlite] CVE-2019-5018, Resolved Which Version?

ch on 2019-03-28, but there's no SQLite release on that date. My theory is that it is resolved in the 3.28 SQLite release (rather than on that date), but I'd like confirmation as the release notes for 3.27 and 3.28 don't reference it. Thanks, Mike Nicolino

[sqlite] Virtual Table BestIndex Being Passed LIKE constraints in SQLite 3.13.0?

thing changed that now makes it possible for the LIKE constraint to be sent to virtual tables? Thanks, Mike Nicolino On 3/5/15, Mike Nicolino wrote: > I'm using System.Data.SQLite version 1.0.95.0 and have what appears to > be a bug with Virtual Tables. Queries using 'like'

[sqlite] Accessing an encyrpted Sqlite Database

requirement, I expect it would be easier/safer to make use of SEE in both System.Data.SQLite and your C++ implementation to ensure the encryption modules are compatible. Thanks, Mike Nicolino -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun

[sqlite] SQLite SEE with FIPS compliant Encryption?

e that the enterprise version of SQLCipher lists a FIPS version; I was hoping we could keep our current implementation which uses SEE however). I'm considering a local modification to SEE to have it call the Windows APIs rather that doing its own encryption; has anyone tried such a thing before

[sqlite] What's the best way to pass function information to virtual table?

faster than SQLite, after I get the average value, how can I return the result immediately without SQLite going through the aggregator avg()? What are your queries like when you "pass arbitrary specialized queries directly to my virtual table"? Thanks, -C.Lin 2015-06-17 8:48 GMT-07:0

[sqlite] What's the best way to pass function information to virtual table?

The override of match() trick works pretty well for cases like this. I've overridden match in my virtual table implementation to allow me to pass arbitrary specialized queries directly to my virtual table modules for cases that I know the virtual table can do a better job that SQLite on that qu

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

es at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe Mistachkin Sent: Tuesday, May 12, 2015 8:43 PM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues Mike Nicolino

[sqlite] System.Data.SQLite, Virtual Tables, and ThreadAbortException Issues

Hey Everyone, For reference I'm using version 1.0.95.0 of System.Data.SQLite. I've got System.Data.SQLite embedded in our cloud web service using virtual table modules to access our various data sources. Our IIS is configured to abort requests that exceed a maximum time threshold (required for

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

dex Bug in system.data.sqlite/sqlite with 'like' On Mar 5, 2015, at 12:30 PM, Mike Nicolino wrote: > I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a > bug with Virtual Tables. Queries using 'like' in the where clause are not > gett

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

ite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, March 05, 2015 10:46 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 

[sqlite] Next version of System.Data.Sqlite bug fixes only or new features?

1.0.96.0 is already released and its bug fix only per the release notes: System.Data.SQLite version 1.0.96.0 (with SQLite 3.8.8.3) is now available on the System.Data.SQLite website: https://system.data.sqlite.org/ Further information about this release can be seen at https://system.

[sqlite] Virtual Table BestIndex Bug in system.data.sqlite/sqlite with 'like'

I'm using System.Data.SQLite version 1.0.95.0 and have what appears to be a bug with Virtual Tables. Queries using 'like' in the where clause are not getting the like clause passed to BestIndex as a query constraint. Specifically: - Simple query: select * from foo where name like 'a%

Re: [sqlite] Having problems with Entity Framework code first db creation

This sounds like a problem with the connection string being passed to SQLiteConnection. Your attached package didn't come through, so could you send the connection string you're using? -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

gt;SQLiteModule.DeclareTable > > > >I have always wondered why people will insist on using human readable > >column names (with embedded spaces and special characters) in the > >implementation layer (SQL code) instead of the presentation layer > >(user interface)

Re: [sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

Figured this one out. DeclareTable doesn't like any 'quoting' around the column names in the sql. It works fine with just straight column names. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Mike Nicolino

[sqlite] System.Data.SQLite - Exception Calling SQLiteModule.DeclareTable

I'm getting an exception calling SQLiteModule.DeclareTable that seems to imply the 'create table' sql being passed is invalid: "SQL logic error or missing database". Yet using that same sql on the same connection as a create table call succeeds. Reviewing the virtual table docs don't imply the

[sqlite] System.Data.Sqlite Virtual Table Example?

Does anyone by chance know of an example of implementing virtual tables with System.Data.Sqlite? The help docs are decent, but seeing an example implementation would be quite helpful to tie it all together. Thanks! ___ sqlite-users mailing list sqlit