Re: [sqlite] Adding the source to XCode

2013-10-22 Thread Simon Slavin
On 23 Oct 2013, at 12:13am, Igor Korot wrote: > Now one last question hopefully. Where XCode will store the db file inside > the bundle? Is there a specific place or it will go where the executable > will be put? If you haven't specified anywhere, then it will just be

Re: [sqlite] Adding the source to XCode

2013-10-22 Thread Igor Korot
Simon, First of, thank you for all those links and explanation. Very much appreciated. Now, more below. On Tue, Oct 22, 2013 at 3:48 PM, Simon Slavin wrote: > > On 22 Oct 2013, at 7:37pm, Igor Korot wrote: > > > On Tue, Oct 22, 2013 at 2:29 AM, Simon

Re: [sqlite] Adding the source to XCode

2013-10-22 Thread Simon Slavin
On 22 Oct 2013, at 7:37pm, Igor Korot wrote: > On Tue, Oct 22, 2013 at 2:29 AM, Simon Slavin wrote: > >> On 22 Oct 2013, at 9:17am, Igor Korot wrote: >> >>> Now I am trying to add the "sqlite3.c" but I couldn't. >>> Going to

Re: [sqlite] Adding the source to XCode

2013-10-22 Thread Igor Korot
Hi, Simon,, On Tue, Oct 22, 2013 at 2:29 AM, Simon Slavin wrote: > > On 22 Oct 2013, at 9:17am, Igor Korot wrote: > > > Now I am trying to add the "sqlite3.c" but I couldn't. > > Going to "File"->"Add Files to,,," I see only my .cpp, .h and sqlite3.h

Re: [sqlite] Force float (instead of double) for storage

2013-10-22 Thread Michael Foss
That worked like a charm, thank you! I'm not sure whether this was an oversight or intentional, but I didn't find this particular compile-time option in the SQLite docs: http://www.sqlite.org/compile.html. But this is kind of a strange case, so I can see why you may have intended to leave this as

Re: [sqlite] Force float (instead of double) for storage

2013-10-22 Thread Clemens Ladisch
Michael Foss wrote: > The processor where I am running my instance of SQLite has a problem in > that it serializes double-precision floating point values incorrectly. If > the 8-byte double should be stored as 0x123456789ABCDEF0, it is instead > stored as 0x9ABCDEF012345678. > > Other solutions I

Re: [sqlite] Force float (instead of double) for storage

2013-10-22 Thread Simon Slavin
On 22 Oct 2013, at 4:47pm, Michael Foss wrote: > Other solutions I have considered, but have decided are undesirable: 4) Copy the code of SQLite but in your copy change the part of the code which formats a REAL for writing to disk and the part of the code which reads it

Re: [sqlite] Force float (instead of double) for storage

2013-10-22 Thread Richard Hipp
On Tue, Oct 22, 2013 at 11:47 AM, Michael Foss wrote: > Hello, > > The processor where I am running my instance of SQLite has a problem in > that it serializes double-precision floating point values incorrectly. If > the 8-byte double should be stored as 0x123456789ABCDEF0,

[sqlite] Force float (instead of double) for storage

2013-10-22 Thread Michael Foss
Hello, The processor where I am running my instance of SQLite has a problem in that it serializes double-precision floating point values incorrectly. If the 8-byte double should be stored as 0x123456789ABCDEF0, it is instead stored as 0x9ABCDEF012345678. Four-byte floating point values are stored

Re: [sqlite] Adding the source to XCode

2013-10-22 Thread Simon Slavin
On 22 Oct 2013, at 9:17am, Igor Korot wrote: > Now I am trying to add the "sqlite3.c" but I couldn't. > Going to "File"->"Add Files to,,," I see only my .cpp, .h and sqlite3.h > files. I don't see sqlite3.c file in the "Add File" dialog. > > Is there any setting I need to

Re: [sqlite] Adding the source to XCode

2013-10-22 Thread Rob Willett
Hi, I used the builtin sqlite library that comes with Mac OS X. The problem I found was compiling it under 64 bit under X code seemed very difficult. I'm not blaming SQLite just my poor knowledge of how Xcode works and how 64 bit compilation worked. I needed 64 bit as I have very large data

[sqlite] asdasd

2013-10-22 Thread Jaydeep Dungarani
___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Adding the source to XCode

2013-10-22 Thread Igor Korot
Hi, ALL, I'm trying to build my C++ project which involves SQLite on MAC. I have Snow Leopard (OS X 10.6.8) along with XCode 4.2. I successfully made a project in XCode, then moved my cpp files in it. Now I am trying to add the "sqlite3.c" but I couldn't. Going to "File"->"Add Files to,,," I see

Re: [sqlite] When does SQLite DB file get locked?

2013-10-22 Thread Simon Slavin
On 22 Oct 2013, at 5:31am, romtek wrote: > I started writing this message and then read > http://www.sqlite.org/lang_transaction.html, and I think I've gotten my > answer, but I will ask the question to be absolutely certain, particularly > when using SQLite with PHP (using