[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 C

[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 replace.

[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 c

[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 lis

[sqlite] Index Selection

ect C1 from T1 indexed by IndxT1C3 where C3='2016-01-02' > no query solution Why can this 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 locked?

[sqlite] File Locking Status

). Thanks, Denis Burke

[sqlite] Behavior When Comparing NULL Values

' end; This gives "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 GR

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

ave a 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 > >

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

elpful. Thanks again 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

[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 is

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

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 1.0.85.

[sqlite] First Day of Week Inconsistency

Sunday: e.g. strftime ('%W','2013-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 fi

[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, OS=Win