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

if it serves to someone I have attached it regards 1966bc On Sun, Nov 16, 2014 at 8:56 AM, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: 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

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

November 2014 00:28, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: if it serves to someone I have attached it Attachments don't come through, post a link to the file. regards 1966bc Best, jb -- --- inum: 883510009027723 sip: jungleboo...@sip2sip.info xmpp: jungle-boo

[sqlite] Student's t-test table

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] Student's t-test table

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 slav...@bigfraud.org wrote: On 16 Nov 2014, at 7:39am, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: do you know if a database exists

[sqlite] -init file

HI all, I am trying to open an sqlite3 shell session passing a configuration file with the option -init but the console it doesn't shape my file, setconsole headers = ON mode= COLUMN timer = ON pep@hal9000:~/test/server$ sqlite3 -init setconsole test.db SQLite version 3.7.13 Enter .help

Re: [sqlite] -init file

= LIST separator = | main prompt = sqlite continue prompt =... found on http://www.linuxcommand.org/man_pages/sqlite31.html regards beppe On Sat, Aug 23, 2014 at 6:35 PM, Simon Slavin slav...@bigfraud.org wrote: On 23 Aug 2014, at 5:28pm, Giuseppe Costanzi

Re: [sqlite] After ANALYZE all has become slow

On 7 Aug 2014, at 3:24pm, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: I have finished running ANALYZE and SQLite commands are taking longer only when I use python db api such as [...] however I have done what you have pointed out me and in effects the speed of execution from the shell

Re: [sqlite] After ANALYZE all has become slow

executed in C code, not in python code, so it should be relatively the same efficiency as the sqlite3 shell tool is). -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- boun...@sqlite.org] On Behalf Of Giuseppe Costanzi Sent: Friday, 8 August, 2014 03:14

[sqlite] After ANALYZE all has become slow

Hi to everybody, I have the following problem, on a database, 20M on a server linux, when I make ANALYZE all the interrogations become slow. The database is constituted by 37 tables, 56 views and varied indexes. I use python database API 2.0 to talking with clients. Considering that the data base

Re: [sqlite] After ANALYZE all has become slow

On Thu, Aug 7, 2014 at 2:50 PM, Simon Slavin slav...@bigfraud.org wrote: On 7 Aug 2014, at 10:56am, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: Hi to everybody, I have the following problem, on a database, 20M on a server linux, when I make ANALYZE all the interrogations become

Re: [sqlite] Date in gridview visualized in YYYY-MM-DD format:

as others have suggested you strftime('%d-%m-%Y', mytalbe.myfield) regards beppe On Wed, Mar 19, 2014 at 10:39 PM, Stefano Ravagni stefanorava...@gmail.comwrote: Hello, i'm new in SQLite develop... i'n a gridview (.NET) i visualize the data type in -MM-DD format Using others

[sqlite] explain me EXPLAIN and EXPLAIN QUERY PLAN

hi, where I can find a good documentation, of keywords in object? I would want to learn well meaning and use of opcode, p1, p2, pn ,comment and order,from,detail... I don't succeed in understanding the output of these two keywordses. wishes and good year to everybody. beppe

[sqlite] GROUP BY months and years using integer data

HI all, I've a table such CREATE TABLE 'stats' ( 'stat_id' INTEGER PRIMARY KEY, 'test_id' INTEGER, 'quantity' INTEGER, 'which_month' INTEGER, 'which_year' INTEGER, ) and I need to extract data with somenthing like SELECT stats.which_year AS year, CASE WHEN

Re: [sqlite] GROUP BY months and years using integer data

thanks to all for the solutions. I am not sure to have understood the Igor's solution ...SUM(stats.quantity * (stats.which_month = 1)) AS gen which is the meaning of the operator * in the statement? regards and still thanks beppe On Sat, Dec 21, 2013 at 8:21 PM, James K. Lowden

Re: [sqlite] GROUP BY months and years using integer data

...but stats.which_month is not a boolean, it represent a month... On Sat, Dec 21, 2013 at 9:11 PM, Simon Slavin slav...@bigfraud.org wrote: On 21 Dec 2013, at 7:45pm, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: I am not sure to have understood the Igor's solution ...SUM

Re: [sqlite] GROUP BY months and years using integer data

35 which is about 10 times more likely than women and the odds increase with age[1]. Hope this makes clear how Booleans are used mathematically in high-level code. Have a great day! Ryan [1] - http://www.statisticbrain.com/hair-loss-statistics/ On 2013/12/21 22:24, Giuseppe Costanzi

Re: [sqlite] GROUP BY

On Thu, Nov 14, 2013 at 11:04 AM, Clemens Ladisch clem...@ladisch.dewrote: Giuseppe Costanzi wrote: order_idissuedcompany dep_id qty,dispatch surplus 112-11-2013 Siemens 1 642 112-11-2013 Siemens 1 220 213

Re: [sqlite] GROUP BY

. Hope I haven't missed your point and this helps. Jim On Thu, Nov 14, 2013 at 2:48 AM, Giuseppe Costanzi giuseppecosta...@gmail.com wrote: hi to everybody, you excuse for the preceding mails but I have had problems with this and I have had to change provider. However I propose my

[sqlite] GROUP BY

hi to everybody, you excuse for the preceding mails but I have had problems with this and I have had to change provider. However I propose my question. I have this query, that you also see in attachment file. SELECT orders.order_id AS order_id, strftime('%d-%m-%Y', orders.issued) AS issued,

[sqlite] Syntax control

hi all, could you check me the syntax of this statment? UPDATE batchs SET batchs.department_id = (SELECT products.department_id FROM products WHERE products.product_id = batchs.product_id)

Re: [sqlite] Syntax control

On Fri, 2012-09-21 at 08:33 +0200, Giuseppe Costanzi wrote: hi all, could you check me the syntax of this statment? UPDATE batchs SET batchs.department_id = (SELECT products.department_id FROM products WHERE

[sqlite] Update case in a transaction

Hi all, I would create a trigger to update a field in a table when in another table a new record is insert My scenario is products table product_id = INTEGER PK product = TEXT stock = INTEGER transactions table transaction_id = INTEGER PK product_id = INTEGER FK flow = BOOLEAN (0,1) quantitty

Re: [sqlite] Update case in a transaction

On Fri, 2012-03-16 at 12:28 -0400, Igor Tandetnik wrote: On 3/16/2012 11:59 AM, Giuseppe Costanzi wrote: CREATE TRIGGER update_stocks AFTER INSERT ON transactions BEGIN UPDATE products SET products.stock =(CASE WHEN (transactions.flow =1

[sqlite] Between And statement too much slow

Hi, I'm using this query on my aplication to retrive a recordset that shows transactions between two date. The problem is that it's too much slow. I'm using python and the field TransactionDate is Datetime (e.g. 2008-01-01) and i passed some such parameters ('1', datetime.date(2008, 7, 1),

Re: [sqlite] Extract month and year from a datetime field

Igor Tandetnik wrote: Giuseppe Costanzi [EMAIL PROTECTED] wrote: How extract the month and/or year from a datetime field? For example: SELECT OrderID,OrderDate FROM tblOrders select OrderID, strftime('%m', OrderDate) as Month, strftime('%Y', OrderDate) as Year from tblOrders