[sqlite] Two processes accessing same DB lock problems

2012-11-15 Thread TR Shaw
This is probably really simple but I don't know how to fix. I have two processes that access the same sqlite3 db file using php. Process 1 starts first and is loading data in spurts into the db. Process 2 cannot access the db oto get data even when Process 1 is not doing anything. All file hav

Re: [sqlite] how do I cd on Mac OX 10?

2011-10-07 Thread TR Shaw
On Oct 7, 2011, at 5:54 PM, TR Shaw wrote: > > On Oct 7, 2011, at 5:46 PM, Mary Andes wrote: > >> Last login: Fri Oct 7 17:26:34 on console >> Mary-Andess-MacBook-Air:~ mjandes$ sqlite3 >> SQLite version 3.7.5 >> Enter ".help" for instruction

Re: [sqlite] how do I cd on Mac OX 10?

2011-10-07 Thread TR Shaw
On Oct 7, 2011, at 5:46 PM, Mary Andes wrote: > Last login: Fri Oct 7 17:26:34 on console > Mary-Andess-MacBook-Air:~ mjandes$ sqlite3 > SQLite version 3.7.5 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> cd /Users/mjandes/SQLite3 and Hedis > ...> > I

Re: [sqlite] Lack of "decimal" support

2011-03-27 Thread TR Shaw
On Mar 26, 2011, at 10:15 PM, BareFeetWare wrote: > On 27/03/2011, at 12:39 PM, Patrick Earl wrote: > >> Base-10 numbers are frequently used in financial calculations because >> of their exact nature. SQLite forces us to store decimal numbers as >> text to ensure precision is not lost. Unfortu

Re: [sqlite] storing big numbers into NUMERIC, DECIMAL columns

2011-03-23 Thread TR Shaw
On Mar 23, 2011, at 1:25 PM, Igor Tandetnik wrote: > On 3/23/2011 12:58 PM, Eugene N wrote: >> I find the discussion very interesting. Apart from billing/accounting every >> good (scientific) application soones or later is bound to requare >> multiprecision library. > > Which scientific instrume

Re: [sqlite] storing big numbers into NUMERIC, DECIMAL columns

2011-03-22 Thread TR Shaw
On Mar 22, 2011, at 9:12 AM, LacaK wrote: >> You still don't say what you're planning on doing with these number...just >> displaying them? > > Yes may be ... > I am working on modification of database component for accessing SQLite3 > databases for FreePascal project. > We map declared column

Re: [sqlite] Rounding Strategy

2011-01-05 Thread TR Shaw
On Jan 5, 2011, at 4:25 AM, Jean-Christophe Deschamps wrote: > Richard, > >> Use floating point for the purpose for which it was created: scientific >> calculations. If you need to know your bank balance to 17 significant >> figures, use integers. Store the values as cents instead of dollar an

Re: [sqlite] Rounding Strategy

2011-01-05 Thread TR Shaw
On Jan 5, 2011, at 4:09 AM, Jean-Christophe Deschamps wrote: > >> I can't help but wonder how decimal math is supposed to make 1/3 + 1/3 >> + 1/3 better. > > Sorry it was almost a private joke here. It's a very common maths > question / challenge about what infinite decimal expansion means.

Re: [sqlite] Rounding Strategy

2011-01-05 Thread TR Shaw
On Jan 4, 2011, at 9:30 PM, Simon Slavin wrote: > > On 5 Jan 2011, at 2:08am, TR Shaw wrote: > >> On Jan 4, 2011, at 7:53 PM, Simon Slavin wrote: >>> >>> >>> Back then I was programming on a PDP11, so both numerator and denominator >>> wer

Re: [sqlite] Rounding Strategy

2011-01-04 Thread TR Shaw
On Jan 4, 2011, at 7:53 PM, Simon Slavin wrote: > > On 5 Jan 2011, at 12:20am, Igor Tandetnik wrote: > >> On 1/4/2011 7:11 PM, Simon Slavin wrote: >>> >>> >>> I bet I'm not the only one here old enough to remember FORTRAN and ALGOL >>> implementations with a 'RATIONAL' math type. It stored

Re: [sqlite] Merry Christmas

2010-12-25 Thread TR Shaw
+1 On Dec 25, 2010, at 12:31 AM, Artur Reilin wrote: > Merry Christmas to the whole mailing list and your families :) > > > Artur Reilin > sqlite.yuedream.de > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/