[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

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 inst

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.

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

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

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] 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 >