Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

[Gilles Vollant]

The crash occur with sqlite 3.7.8 on line below:
  u.bp.pC->nullRow = (u8)u.bp.res;

  u.bp.pC did not reference a valid address.


here is the stack

(gdb) bt
#0  0x00055000 in sqlite3VdbeExec (p=0x18e9d8) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:68038
#1  0x96d2 in sqlite3_step (pStmt=0x18e9d8) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:61954
#2  0xc7f2 in sqlite3_exec (db=0xa85408, zSql=0x786688 "SELECT name,
rootpage, sql FROM 'main'.sqlite_master ORDER BY rowid", xCallback=0x3cfa5
, pArg=0x2fdfdec0, pzErrMsg=0x0) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:88791
#3  0x0003ce7a in sqlite3InitOne (db=0xa85408, iDb=0, pzErrMsg=0xa84410) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:91809
#4  0x0003ca6a in sqlite3Init (db=0xa85408, pzErrMsg=0xa84410) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:91875
#5  0xb9f2 in sqlite3ReadSchema [inlined] () at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:91912
#6  0xb9f2 in sqlite3LocateTable (pParse=0xa84408, isView=0,
zName=0x786788 "base_version", zDbase=0x0) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:79437
#7  0x0003a604 in selectExpander (pWalker=0x2fdfe050, p=0x786708) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:95581
#8  0x00038560 in sqlite3WalkSelect (pWalker=0x2fdfe050, p=0x786708) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:71787
#9  0x00037bcc in sqlite3SelectPrep (pParse=0xa84408, p=0x786708,
pOuterNC=) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:95776
#10 0x0002a296 in sqlite3Select (pParse=0xa84408, p=0x786708,
pDest=0x2fdfe2c4) at /Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:96116
#11 0x000220e2 in yy_reduce (yypParser=0xab8208, yyruleno=112) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:107894
#12 0x000200ce in sqlite3Parser (yyp=0xab8208, yymajor=1, pParse=) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:108862
#13 0xdaa4 in sqlite3RunParser (pParse=0xa84408, zSql=0x68f87 "SELECT *
FROM base_version", pzErrMsg=0x2fdfe430) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:109699
#14 0x000520b0 in sqlite3Prepare (db=0xa85408, zSql=0x68f87 "SELECT * FROM
base_version", nBytes=,
saveSqlFlag=1, pReprepare=0x0, ppStmt=0x2fdfe4a8, pzTail=0x0) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:92089
#15 0xcfb6 in sqlite3LockAndPrepare (db=0xa85408, zSql=0x68f87 "SELECT *
FROM base_version", nBytes=-1, saveSqlFlag=1, pOld=0x0, ppStmt=0x2fdfe4a8,
pzTail=0x0) at /Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:92181
#16 0xd084 in sqlite3_prepare_v2 (db=, zSql=, nBytes=, ppStmt=, pzTail=0x0) at
/Volumes/hfsdata/sqliteTest/sqlite/sqlite3.c:92256
#17 0x232c in getDatabaseVersion [inlined] () at
/Volumes/hfsdata/sqliteTest/Classes/MainViewController.m:19
.

#38 0x21bc in main (argc=, argv=)
at /Volumes/hfsdata/sqliteTest/main.m:14
(gdb) 



On 3 Nov 2011, at 8:39am, Price,Ray wrote:

> I'm having a VERY odd problem with Sqlite at the moment.  I have an
application that works fine and has been working find for over a year, but
since updating to xcode 4 and the ios 5 SDK Sqlite crashes regularly, but
ONLY on older devices still running iOS 3.1.3.
> 
> However, if I compile the sqlite3.c module WITHOUT optimizations, the
crash goes away, but this is obviously FAR from ideal.
> 
> Has anyone else experienced this?

First, well done for identifying your workaround.  I use Xcode and iOS and
I've had situations where compiling without optimization cures crashes.  But
they haven't involved SQLite code.  I don't know how much optimization
improves sqlite's speed.  Might help a lot, might not.

One problem with sqlite is that it has to compile on a lot of platforms with
a lot of compilers and it's impossible to get rid of all warnings under
those conditions.

If possible play with each of the optimization levels and find out which
level is causing the problems.  If you can figure out what part of the C
code is causing the problem, or post an extract from the crash log which
gives symbol names, someone here might be able to figure out what to fix in
the code.

Simon.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

[Price,Ray]

Interesting, I'll give that a try, thanks.  Good to know I'm not going crazy... 
my worry with this kind of thing is always that my memory management is not 
bulletproof and is having a knock-on effect somewhere.

Thanks
Ray

-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 
On Behalf Of James Berry
Sent: Thursday, November 03, 2011 3:56 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without 
Optimizations


On Nov 3, 2011, at 6:19 AM, James Berry wrote:

> I've seen this same problem. It crashes seemingly due to bugs in llvm-clang 
> when compiled for arm6 if, as you say, optimizations at any level are turned 
> on. I've worked around this issue by turning off optimizations for arm6. 
> Sqlite3, by the way, is not the only bit of my iOS app that encounters 
> problems with that arm6 optimization combination. arm6, fortunately, is 
> required by fewer and fewer devices these days.
> 
> Report bugs to apple, if you care.

Btw, somebody mentioned to me this morning that these issues can be worked 
around by disabling thumb mode when compiling for arm6 (as an alternative to 
disabling optimizations). That would be the -mno-thumb switch to the compiler. 
Note that these issues only manifest when compiling using the llvm/clang 
compiler.

James

> 
> 
> On Nov 3, 2011, at 1:39 AM, Price,Ray wrote:
> 
>> Hi All,
>> 
>> I'm having a VERY odd problem with Sqlite at the moment.  I have an 
>> application that works fine and has been working find for over a year, but 
>> since updating to xcode 4 and the ios 5 SDK Sqlite crashes regularly, but 
>> ONLY on older devices still running iOS 3.1.3.
>> 
>> However, if I compile the sqlite3.c module WITHOUT optimizations, the crash 
>> goes away, but this is obviously FAR from ideal.
>> 
>> Has anyone else experienced this?  Is there anything I can do to narrow down 
>> the problem, or is there anyone I could report this to?
>> 
>> Thanks
>> Ray
>> 
>> 
>> 
>> 
>> This e-mail message, including any attachments, is for the sole use of the 
>> person to whom it has been sent, and may contain information that is 
>> confidential or legally protected. If you are not the intended recipient or 
>> have received this message in error, you are not authorized to copy, 
>> distribute, or otherwise use this message or its attachments. Please notify 
>> the sender immediately by return e-mail and permanently delete this message 
>> and any attachments. Gartner makes no warranty that this e-mail is error or 
>> virus free.
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

[James Berry]

On Nov 3, 2011, at 6:19 AM, James Berry wrote:

> I've seen this same problem. It crashes seemingly due to bugs in llvm-clang 
> when compiled for arm6 if, as you say, optimizations at any level are turned 
> on. I've worked around this issue by turning off optimizations for arm6. 
> Sqlite3, by the way, is not the only bit of my iOS app that encounters 
> problems with that arm6 optimization combination. arm6, fortunately, is 
> required by fewer and fewer devices these days.
> 
> Report bugs to apple, if you care.

Btw, somebody mentioned to me this morning that these issues can be worked 
around by disabling thumb mode when compiling for arm6 (as an alternative to 
disabling optimizations). That would be the -mno-thumb switch to the compiler. 
Note that these issues only manifest when compiling using the llvm/clang 
compiler.

James

> 
> 
> On Nov 3, 2011, at 1:39 AM, Price,Ray wrote:
> 
>> Hi All,
>> 
>> I'm having a VERY odd problem with Sqlite at the moment.  I have an 
>> application that works fine and has been working find for over a year, but 
>> since updating to xcode 4 and the ios 5 SDK Sqlite crashes regularly, but 
>> ONLY on older devices still running iOS 3.1.3.
>> 
>> However, if I compile the sqlite3.c module WITHOUT optimizations, the crash 
>> goes away, but this is obviously FAR from ideal.
>> 
>> Has anyone else experienced this?  Is there anything I can do to narrow down 
>> the problem, or is there anyone I could report this to?
>> 
>> Thanks
>> Ray
>> 
>> 
>> 
>> 
>> This e-mail message, including any attachments, is for the sole use of the 
>> person to whom it has been sent, and may contain information that is 
>> confidential or legally protected. If you are not the intended recipient or 
>> have received this message in error, you are not authorized to copy, 
>> distribute, or otherwise use this message or its attachments. Please notify 
>> the sender immediately by return e-mail and permanently delete this message 
>> and any attachments. Gartner makes no warranty that this e-mail is error or 
>> virus free.
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

[James Berry]

I've seen this same problem. It crashes seemingly due to bugs in llvm-clang 
when compiled for arm6 if, as you say, optimizations at any level are turned 
on. I've worked around this issue by turning off optimizations for arm6. 
Sqlite3, by the way, is not the only bit of my iOS app that encounters problems 
with that arm6 optimization combination. arm6, fortunately, is required by 
fewer and fewer devices these days.

Report bugs to apple, if you care.

James


On Nov 3, 2011, at 1:39 AM, Price,Ray wrote:

> Hi All,
> 
> I'm having a VERY odd problem with Sqlite at the moment.  I have an 
> application that works fine and has been working find for over a year, but 
> since updating to xcode 4 and the ios 5 SDK Sqlite crashes regularly, but 
> ONLY on older devices still running iOS 3.1.3.
> 
> However, if I compile the sqlite3.c module WITHOUT optimizations, the crash 
> goes away, but this is obviously FAR from ideal.
> 
> Has anyone else experienced this?  Is there anything I can do to narrow down 
> the problem, or is there anyone I could report this to?
> 
> Thanks
> Ray
> 
> 
> 
> 
> This e-mail message, including any attachments, is for the sole use of the 
> person to whom it has been sent, and may contain information that is 
> confidential or legally protected. If you are not the intended recipient or 
> have received this message in error, you are not authorized to copy, 
> distribute, or otherwise use this message or its attachments. Please notify 
> the sender immediately by return e-mail and permanently delete this message 
> and any attachments. Gartner makes no warranty that this e-mail is error or 
> virus free.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

[Simon Slavin]

On 3 Nov 2011, at 8:39am, Price,Ray wrote:

> I'm having a VERY odd problem with Sqlite at the moment.  I have an 
> application that works fine and has been working find for over a year, but 
> since updating to xcode 4 and the ios 5 SDK Sqlite crashes regularly, but 
> ONLY on older devices still running iOS 3.1.3.
> 
> However, if I compile the sqlite3.c module WITHOUT optimizations, the crash 
> goes away, but this is obviously FAR from ideal.
> 
> Has anyone else experienced this?

First, well done for identifying your workaround.  I use Xcode and iOS and I've 
had situations where compiling without optimization cures crashes.  But they 
haven't involved SQLite code.  I don't know how much optimization improves 
sqlite's speed.  Might help a lot, might not.

One problem with sqlite is that it has to compile on a lot of platforms with a 
lot of compilers and it's impossible to get rid of all warnings under those 
conditions.

If possible play with each of the optimization levels and find out which level 
is causing the problems.  If you can figure out what part of the C code is 
causing the problem, or post an extract from the crash log which gives symbol 
names, someone here might be able to figure out what to fix in the code.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] iPhone iOS 3.1.3 Sqlite3 Crashes Unless Compiled Without Optimizations

[Price,Ray]

Hi All,

I'm having a VERY odd problem with Sqlite at the moment.  I have an application 
that works fine and has been working find for over a year, but since updating 
to xcode 4 and the ios 5 SDK Sqlite crashes regularly, but ONLY on older 
devices still running iOS 3.1.3.

However, if I compile the sqlite3.c module WITHOUT optimizations, the crash 
goes away, but this is obviously FAR from ideal.

Has anyone else experienced this?  Is there anything I can do to narrow down 
the problem, or is there anyone I could report this to?

Thanks
Ray




This e-mail message, including any attachments, is for the sole use of the 
person to whom it has been sent, and may contain information that is 
confidential or legally protected. If you are not the intended recipient or 
have received this message in error, you are not authorized to copy, 
distribute, or otherwise use this message or its attachments. Please notify the 
sender immediately by return e-mail and permanently delete this message and any 
attachments. Gartner makes no warranty that this e-mail is error or virus free.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

[Raeldor]

Ah, that's great to know... thank you for the link.  I was going crazy trying
to figure out what setting I'd screwed up.

Thanks
Ray


On Tue, Nov 2, 2010 at 7:05 PM, Raeldor  wrote:

>
> I believe you.  The main problem is in the iPad simulator... funny thing
> is
> that the same database opens fine on the iPhone device and iPhone
> simulator.
>

There is a bug in the iPad/iPhone simulator that causes SQLite to
malfunction.  The same bug is described here:
http://www.openradar.me/8140890

Apple knows about the problem and will soon release a fix (if they have not
already done so), I am told.



-- 
View this message in context: 
http://old.nabble.com/iPhone-iPad-Database-Disk-Image-Malformed-tp30118432p30118608.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

[Richard Hipp]

On Tue, Nov 2, 2010 at 7:05 PM, Raeldor  wrote:

>
> I believe you.  The main problem is in the iPad simulator... funny thing is
> that the same database opens fine on the iPhone device and iPhone
> simulator.
>

There is a bug in the iPad/iPhone simulator that causes SQLite to
malfunction.  The same bug is described here:
http://www.openradar.me/8140890

Apple knows about the problem and will soon release a fix (if they have not
already done so), I am told.



>
>
> BareFeetWare-2 wrote:
> >
> > Hi Ray,
> >
> > In reply to:
> >
> >> My application was working fine, but now I get this message consistantly
> >> in
> >> the iPad simulator and on the device too when I try and run my updated
> >> database since iOS 4.0.
> >
> >> Is anyone else seeing this behavior?  Any tips for debugging?
> >
> > For what it's worth I have several databases in an iPad/iPhone projects
> > that I have been running for weeks in my Cocoa app on both iOS3.2 and iOS
> > 4.x without a problem.
> >
> > Thanks,
> > Tom
> > BareFeetWare
> >
> >  --
> > Comparison of SQLite GUI tools:
> > http://www.barefeetware.com/sqlite/compare/?ml
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> >
>
> --
> View this message in context:
> http://old.nabble.com/iPhone-iPad-Database-Disk-Image-Malformed-tp30118432p30118566.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone/iPad Database Disk Image Malformed

[Raeldor]

I believe you.  The main problem is in the iPad simulator... funny thing is
that the same database opens fine on the iPhone device and iPhone simulator.


BareFeetWare-2 wrote:
> 
> Hi Ray,
> 
> In reply to:
> 
>> My application was working fine, but now I get this message consistantly
>> in
>> the iPad simulator and on the device too when I try and run my updated
>> database since iOS 4.0.
> 
>> Is anyone else seeing this behavior?  Any tips for debugging?
> 
> For what it's worth I have several databases in an iPad/iPhone projects
> that I have been running for weeks in my Cocoa app on both iOS3.2 and iOS
> 4.x without a problem.
> 
> Thanks,
> Tom
> BareFeetWare
> 
>  --
> Comparison of SQLite GUI tools:
> http://www.barefeetware.com/sqlite/compare/?ml
> 
> 
> 
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> 
> 

-- 
View this message in context: 
http://old.nabble.com/iPhone-iPad-Database-Disk-Image-Malformed-tp30118432p30118566.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] iPhone/iPad Database Disk Image Malformed

[Raeldor]

Hi All,

My application was working fine, but now I get this message consistantly in
the iPad simulator and on the device too when I try and run my updated
database since iOS 4.0.

My database was built on the PC and copied to the Mac and then into my xCode
project which I've never had a problem with before.

Is anyone else seeing this behavior?  Any tips for debugging?

Thanks
Ray

-- 
View this message in context: 
http://old.nabble.com/iPhone-iPad-Database-Disk-Image-Malformed-tp30118432p30118432.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone App close database

[Greg Walters]

Simon,
Thanks a lot. This is just what I needed.
Greg





From: Simon Slavin <slav...@bigfraud.org>
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Sent: Wed, December 9, 2009 4:34:09 PM
Subject: Re: [sqlite] iPhone App close database


On 9 Dec 2009, at 11:13pm, Greg Walters wrote:

> I am looking for some general information regarding closing the sqlite 
> database when used from an iPhone app. Since you never know when you app will 
> go away, when do you close the database. I have found one example application 
> that closes the database after getting data and doing updates. Most never 
> close the database. What is the best way to handle this so in an iPhone app. 

Your application does get warned about important like that, and is expected to 
provide a routine to respond to each warning.  Look for

applicationWillTerminate

for quitting, which is the question you asked.  But also look for

applicationWillResignActive
applicationDidBecomeActive

since, if possible without too much extra work, I'd recommend that you also 
close files while the iPhone is handling external interruptions like phone 
calls, SMS notifications, and 'push' notifications.  You might find this useful:

http://developer.apple.com/iPhone/library/documentation/iPhone/Conceptual/iPhoneOSProgrammingGuide/ApplicationEnvironment/ApplicationEnvironment.html#//apple_ref/doc/uid/TP40007072-CH7-SW6

(that's all one long URL).

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone App close database

[Simon Slavin]

On 9 Dec 2009, at 11:13pm, Greg Walters wrote:

> I am looking for some general information regarding closing the sqlite 
> database when used from an iPhone app. Since you never know when you app will 
> go away, when do you close the database. I have found one example application 
> that closes the database after getting data and doing updates. Most never 
> close the database. What is the best way to handle this so in an iPhone app. 

Your application does get warned about important like that, and is expected to 
provide a routine to respond to each warning.  Look for

applicationWillTerminate

for quitting, which is the question you asked.  But also look for

applicationWillResignActive
applicationDidBecomeActive

since, if possible without too much extra work, I'd recommend that you also 
close files while the iPhone is handling external interruptions like phone 
calls, SMS notifications, and 'push' notifications.  You might find this useful:

http://developer.apple.com/iPhone/library/documentation/iPhone/Conceptual/iPhoneOSProgrammingGuide/ApplicationEnvironment/ApplicationEnvironment.html#//apple_ref/doc/uid/TP40007072-CH7-SW6

(that's all one long URL).

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] iPhone App close database

[Greg Walters]

Hi,
I am looking for some general information regarding closing the sqlite database 
when used from an iPhone app. Since you never know when you app will go away, 
when do you close the database. I have found one example application that 
closes the database after getting data and doing updates. Most never close the 
database. What is the best way to handle this so in an iPhone app. 
Thanks,
Greg



  
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] iPhone

[Will Leshner]

On 7/2/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:


Congratulations to DRH and all.

I Just love this beast,incredibly small but with monster features.


Of course, SQLite is already a big part of Mac OS X. It is the "core"
of Core Data:



It is also used extensively throughout the OS.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] iPhone

[RaghavendraK 70574]

Definitely not iPhone.

regards
ragha

**
 This email and its attachments contain confidential information from HUAWEI, 
which is intended only for the person or entity whose address is listed above. 
Any use of the information contained herein in any way (including, but not 
limited to, total or partial disclosure, reproduction, or dissemination) by 
persons other than the intended recipient(s) is prohibited. If you receive this 
e-mail in error, please notify the sender by phone or email immediately and 
delete it!
 
*

- Original Message -
From: P Kishor <[EMAIL PROTECTED]>
Date: Tuesday, July 3, 2007 10:32 am
Subject: Re: [sqlite] iPhone

> On 7/2/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:
> >
> > Congratulations to DRH and all.
> >
> > I Just love this beast,incredibly small but with monster features.
> >
> 
> 
> hmmm now, is that a phone in your pocket, or is it just that your
> database is happy to see me? Which beast are we talking about here?
> 
> ;-)
> 
> 
> 
> 
> > - Original Message -
> > From: Rich Shepard <[EMAIL PROTECTED]>
> > Date: Tuesday, July 3, 2007 3:01 am
> > Subject: Re: [sqlite] iPhone
> >
> > > On Mon, 2 Jul 2007, Peter van Dijk wrote:
> > >
> > > > Apple's new iPhone uses SQLite 3.1.3 to manage its database of
> > > certificates
> > >   Well, then: imagine how much more folks would have had to pay
> > > to cover the
> > > costs of developing their own dbms, or licensing a commercial one.
> > >
> > > Rich
> > >
> > > --
> > > Richard B. Shepard, Ph.D.   |The Environmental
> > > PermittingApplied Ecosystem Services, Inc.|
> > > Accelerator(TM)<http://www.appl-ecosys.com> Voice: 503-667-
> > > 4517  Fax: 503-667-8863
> > >
> > > ---
> 
> > > --
> > > To unsubscribe, send email to [EMAIL PROTECTED]
> > > ---
> 
> > > --
> > >
> > >
> >
> > -
> 
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -
> 
> >
> >
> 
> 
> -- 
> Puneet Kishor http://punkish.eidesis.org/
> Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
> Open Source Geospatial Foundation http://www.osgeo.org/education/
> S Policy Fellow, National Academy of Sciences http://www.nas.edu/
> ---
> --
> collaborate, communicate, compete
> =
> 
> ---
> --
> To unsubscribe, send email to [EMAIL PROTECTED]
> ---
> --
> 
> 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] iPhone

[P Kishor]

On 7/2/07, RaghavendraK 70574 <[EMAIL PROTECTED]> wrote:


Congratulations to DRH and all.

I Just love this beast,incredibly small but with monster features.




hmmm now, is that a phone in your pocket, or is it just that your
database is happy to see me? Which beast are we talking about here?

;-)





- Original Message -
From: Rich Shepard <[EMAIL PROTECTED]>
Date: Tuesday, July 3, 2007 3:01 am
Subject: Re: [sqlite] iPhone

> On Mon, 2 Jul 2007, Peter van Dijk wrote:
>
> > Apple's new iPhone uses SQLite 3.1.3 to manage its database of
> certificates
>   Well, then: imagine how much more folks would have had to pay
> to cover the
> costs of developing their own dbms, or licensing a commercial one.
>
> Rich
>
> --
> Richard B. Shepard, Ph.D.   |The Environmental
> PermittingApplied Ecosystem Services, Inc.|
> Accelerator(TM)<http://www.appl-ecosys.com> Voice: 503-667-
> 4517  Fax: 503-667-8863
>
> ---
> --
> To unsubscribe, send email to [EMAIL PROTECTED]
> ---
> --
>
>

-
To unsubscribe, send email to [EMAIL PROTECTED]
-





--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
S Policy Fellow, National Academy of Sciences http://www.nas.edu/
-
collaborate, communicate, compete
=

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] iPhone

[RaghavendraK 70574]

Congratulations to DRH and all.

I Just love this beast,incredibly small but with monster features.

regards
ragha
**
 This email and its attachments contain confidential information from HUAWEI, 
which is intended only for the person or entity whose address is listed above. 
Any use of the information contained herein in any way (including, but not 
limited to, total or partial disclosure, reproduction, or dissemination) by 
persons other than the intended recipient(s) is prohibited. If you receive this 
e-mail in error, please notify the sender by phone or email immediately and 
delete it!
 
*

- Original Message -
From: Rich Shepard <[EMAIL PROTECTED]>
Date: Tuesday, July 3, 2007 3:01 am
Subject: Re: [sqlite] iPhone

> On Mon, 2 Jul 2007, Peter van Dijk wrote:
> 
> > Apple's new iPhone uses SQLite 3.1.3 to manage its database of 
> certificates
>   Well, then: imagine how much more folks would have had to pay 
> to cover the
> costs of developing their own dbms, or licensing a commercial one.
> 
> Rich
> 
> -- 
> Richard B. Shepard, Ph.D.   |The Environmental 
> PermittingApplied Ecosystem Services, Inc.|  
> Accelerator(TM)<http://www.appl-ecosys.com> Voice: 503-667-
> 4517  Fax: 503-667-8863
> 
> ---
> --
> To unsubscribe, send email to [EMAIL PROTECTED]
> ---
> --
> 
> 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] iPhone

[Rich Shepard]

On Mon, 2 Jul 2007, [EMAIL PROTECTED] wrote:


Rich, can you bring this to attention of Steve Jobs for me.  ;-)


  Well, I'd be happy to, but he would most likely ignore any email message I
sent. More to the point, he wouldn't care.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.|  Accelerator(TM)
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] iPhone

[drh]

Rich Shepard <[EMAIL PROTECTED]> wrote:
> On Mon, 2 Jul 2007, Peter van Dijk wrote:
> 
> > Apple's new iPhone uses SQLite 3.1.3 to manage its database of certificates
> 
>Well, then: imagine how much more folks would have had to pay to cover the
> costs of developing their own dbms, or licensing a commercial one.
> 

Rich, can you bring this to attention of Steve Jobs for me.  ;-)

--
D. Richard Hipp <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] iPhone

[Rich Shepard]

On Mon, 2 Jul 2007, Peter van Dijk wrote:


Apple's new iPhone uses SQLite 3.1.3 to manage its database of certificates


  Well, then: imagine how much more folks would have had to pay to cover the
costs of developing their own dbms, or licensing a commercial one.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.|  Accelerator(TM)
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] iPhone

[Peter van Dijk]

Apple's new iPhone uses SQLite 3.1.3 to manage its database of  
certificates :)


Cheers, Peter

-
To unsubscribe, send email to [EMAIL PROTECTED]
-