[sqlite] Yes - Getting SPAM from Using Mailing List

I know steps were taken to reduce it, but just confirming it is still going on today. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] File Locking

9. Insert finishes**UNLOCKED 10. Destroy command object**UNLOCKED 11. Close Connection **UNLOCKED 12. Destroy connection object **UNLOCKED Your insights are appreciated, Denis Burke

[sqlite] Group by Literals

The SQLite documentation (http://www.sqlite.org/lang_select.html) says the GROUP BY clause accepts [expr]. And [expr] can be composed of a literal. What I cannot find is what SQLite does (or should do) with a literal in the GROUP BY clause. In the simple case of table T1 with two columns C1,C2

[sqlite] Encryption

I am not sure about sqlite2009, but you edit DBs that are encrypted using the encryption in system.data.sqlite. I use SQLITE Expert. It allows you to replace the standard library which does not support encryption to one from the system.data.sqlite that does. It is the interop dll that you

[sqlite] Does Reindex Change Stats Tables?

> REINDEX does *not* update the stats. You must run ANALYZE separately. > May I ask why you are running REINDEX? Sure. We issue new releases of our application about every 3 months. With some of these, we update the schema of the underlying DB. And with some of these schema updates, we have

[sqlite] Does Reindex Change Stats Tables?

I am wondering if I run reindex than should I always run analyze afterward? If the reindex command though also updates the stats in addition to recreating the actual indexes, then of course i would not need it. Thanks, Denis ___ sqlite-users mailing

[sqlite] Index Selection

index not be used? Thank you, Denis Burke

[sqlite] File Locking Status

Thank you Simon - that is helpful. I would still be interested if anyone can provide any further info regarding locking as seen through System.Data.SQlite. -Denis -- On 8 Mar 2016, at 6:50pm, Denis Burke wrote: > Is it possible to tell if SQLite has a database file loc

[sqlite] File Locking Status

). Thanks, Denis Burke

[sqlite] Behavior When Comparing NULL Values

"is in list". But since null is clearly not in the list of one member ('a'), I would expect this to generate "not in the list". Is this expected behavior, or a bug? Thank you, Denis Burke

[sqlite] Suggesting an Index to Use Can Improve Performance Even When Planner was Already Going to Use It

I was analyzing hundreds of queries in our system and a few stood out (average query time is subsecond, but these few that stood out were 10+ seconds). Here is the basic query for these problem few: SELECT T1.A from T1 INNER JOIN T2 on T1.B=T2.B and T1.C=T2.C where T1.D='2015-12-31' and T2.E=2

[sqlite] Wrong Index Select with Large Table Joined to Small Table

lot of queries that either use partial indexes or could benefit from them. -Denis On Fri, Jan 22, 2016 at 7:29 AM, Richard Hipp wrote: > On 1/21/16, Denis Burke wrote: > > When > > would you NOT want to add the "where [indexedColumn] IS NOT NULL"? Seems > > l

[sqlite] Wrong Index Select with Large Table Joined to Small Table

in for the excellent insight. -Denis Burke On Thu, Jan 21, 2016 at 4:43 PM, Richard Hipp wrote: > On 1/21/16, Richard Hipp wrote: > > On 1/21/16, Denis Burke wrote: > >> > >> That query takes 4 minutes to run... > > > > Can you please run ".fullsche

[sqlite] Wrong Index Select with Large Table Joined to Small Table

I have a DB with a large table (1M records) and several small tables (~100 records). I am running queries like this: select F1 from BigTable inner join SmallTable on BigTable.F2=SmallTable.F2 where SmallTable.F3=1 and BigTable.F4=2 That query takes 4 minutes to run and the query plan shows it

Re: [sqlite] Errors Compiling Extension percentile.c

08-1.0.90.0.exe Both with the same result. Thanks, Denis Burke ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Errors Compiling Extension percentile.c

or LNK2001: unresolved external symbol _DllMainCRTStartup percentile2.dll : fatal error LNK1120: 6 unresolved externals --END OUTPUT Any insight would be appreciated. -Denis Burke ___ sqlite-users mailing list sqlite-users@sqlit

[sqlite] System.Data.SQLite and UNC Paths

of System.Data.SQLite open C:\Mydb.db. I have to use v1.0.85 or earlier in order to open \\mypc\db\Mydb.db Let me know if more data is useful but from my testing, I see 100% failure rate with UNC paths, so I think recreating the issue should not be difficult. Thanks, Denis Burke

[sqlite] System.Data.SQLite v1.0.89 Breaks My App (SQLite.interop.dll)

Apps works fine on 1.0.85, but with v1.0.89 I get the error noted at the bottom. Switching back to 1.0.85 works fine again. Further investigation finds that v1.0.85 does not have a separate SQLite.Interop.dll. These functions were apparently separated from the main DLL in a release after

[sqlite] First Day of Week Inconsistency

013-06-19') -> 24 strftime ('%W','2013-06-17') -> 24 strftime ('%W','2013-06-16') -> 23 It seems to me these useful functions are inconsistent. Is it possible to modify %W to treat Sunday as the first day of the week? Thanks, Denis Burke ___

[sqlite] SQLiteConnection.State Property w/ v1.0.83.0 Changed

Moving from v1.0.81.0 to v1.0.83.0 (no code changes on my part), results in a change in reported state from the SQLiteConnection.State property. I could not find any documentation/bug fixes which indicates that this is an expected change. Background info: Vb.net app, .NET 3.5SP1, VS 2010,