Re: SQLite vs. Apple's Cocoa SQLite
Re: SQLite vs. Apple's Cocoa SQLite
- Subject: Re: SQLite vs. Apple's Cocoa SQLite
- From: Scott Ellsworth <email@hidden>
- Date: Mon, 6 Mar 2006 14:52:31 -0800
On Mar 6, 2006, at 2:37 PM, Rick Langschultz wrote:
I was wondering if SQLite (current) had any new features than the
SQLite store has.
Take a look at the sqlite.org site and see. I believe we are using
sqlite 3.1.3, based on running the sqlite3 command line tool. There
have been a number of sqlite releases since then, and the history is
on the site.
The only one I noted with the mk I eyeball were the improvements to
the sql optimizer mentioned in 3.2.3.
What is the difference between the two. Do both support BLOBs
VARCHARs and other types. Also is the current version of SQLite
faster than Apple's SQLite Core Data store? What I am wondering is
if i should write my own SQLite framework and libraries opposed to
using existing ones.
It is possible that the new version, combined with some hand tuning,
would be faster. Try an experiment with data representative of that
which you intend to use. With a bit of tuning, you can probably make
dramatic improvements over the sql apple generates for a specific
data layout. At the least, I have found that I write better sql than
most toolkits if my data has a special layout.
Of course, that same effort can also get the same benefits by tuning
my data to the framework, and then I get whatever cookies they bolt
on with system updates. Apple's Core Data framework has a lot of
useful machinery built in, and letting it do the heavy lifting may
save you from maintenance headaches.
From having talked to the people in that group, they pay very close
attention to bug reports that include SQL from the log, and better
sql generated by hand. Especially if you can describe the
circumstance in which your hand tuned stuff is better, as they can
then get that folded into the framework.
Scott
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden