Re: [sqlite] Student's t-test table

2014-11-15 Thread Giuseppe Costanzi
Thanks Simon, I know how to perform the importation. However thanks of the idea. I start looking for it. On Sun, Nov 16, 2014 at 8:46 AM, Simon Slavin wrote: > > On 16 Nov 2014, at 7:39am, Giuseppe Costanzi > wrote: > >> do you know if a

Re: [sqlite] Student's t-test table

2014-11-15 Thread Simon Slavin
On 16 Nov 2014, at 7:39am, Giuseppe Costanzi wrote: > do you know if a database exists in sqlite with the values, degrees of > fredom vs probability (alfa) of the t Student? If you can find one in text or .csv format, we can tell you how to import it. Simon.

[sqlite] Student's t-test table

2014-11-15 Thread Giuseppe Costanzi
Hi to everybody, do you know if a database exists in sqlite with the values, degrees of fredom vs probability (alfa) of the t Student? I need it to calculate confidence intervals to compare two means regards bc1966 ___ sqlite-users mailing list

Re: [sqlite] Discrepancy with indexing and WHERE clause with AND/OR

2014-11-15 Thread RSmith
On 2014/11/14 16:32, RP McMurphy wrote: On Tue, 11/11/14, RP McMurphy wrote: > If you can provide any examples where ANALYZE makes a query slower, I suspect the developer team would like > to see them. > After we

Re: [sqlite] Discrepancy with indexing and WHERE clause with AND/OR

2014-11-15 Thread Simon Slavin
On 14 Nov 2014, at 2:32pm, RP McMurphy wrote: > After we run analyze and then > let the process run for a while the DB > contents change - and it can change quite > considerably depending > upon what is > happening > > I suspect that the analyze data gets stale, but > I

Re: [sqlite] querying with BLOB in WHERE clause, possible?

2014-11-15 Thread Stephan Beal
On Fri, Nov 14, 2014 at 3:57 PM, bjdodo wrote: > I've got it now. E.g. for delete you can do this: > A minor fix: the 'try' needs to be moved to... > > int argidx = 0; > SQLiteStatement statement = mDB.compileStatement(sql); > here. Because... >

Re: [sqlite] querying with BLOB in WHERE clause, possible?

2014-11-15 Thread bjdodo
I've got it now. E.g. for delete you can do this: String sql = "DELETE FROM " + table + (!TextUtils.isEmpty(whereClause) ? " WHERE " + whereClause : ""); int argidx = 0; SQLiteStatement statement = mDB.compileStatement(sql); if (whereArgs != null)

Re: [sqlite] Missing SQLite.Designer.SQLiteDataViewSupport?

2014-11-15 Thread echizen
I have installed the version 1.0.94.0 and I get the same problem, telling me "Could not find Any Appropriate resources for the culture or the Specified neutral culture. Make sure" SQLite.Designer.SQLiteDataViewSupport2012.xml "was embedded or linked into Correctly assembly "SQLite.Designer" at

Re: [sqlite] Discrepancy with indexing and WHERE clause with AND/OR

2014-11-15 Thread RP McMurphy
I am resending this message below from 3 days ago because it never made it to the list. RP PS: Messages seem to take a long time to go through the gmane system, at least half a day and sometimes more in my experience so far. On Tue, 11/11/14, RP