On Fri, Aug 28, 2009 at 11:12:12AM -0700, [email protected] wrote:
> > SQLite3 meets all of those requirements; it's tiny, has resource
> > controls, no external dependencies outside libc, no reason why it
> > couldn't be used by the client and server (though it's not a networked
> > DB) and already on the livecd (because Firefox needs it). It's
> > blindingly fast for things like "pkg search -l ls", as in Mike's
> > example.
>
> I believe that Brock investigated SQLite and found that it didn't meet
> his needs, but he has the specifics, not me. Bart has always said that
I'd love to hear the specifics, for several reasons:
- So I can determine if it's even worth doing what you suggest
(contribute prototype code to IPS to use SQLite3). Perhaps there
really are good reasons to not bother with SQLite3 in IPS, and I'd
like to know before I spend any time on it.
- So we can file bugs/RFEs against SQLite3 -- the SQLite3 community may
well be interested in Brock's feedback.
- So I can correct Brock's impression. Perhaps he didn't used prepared
queries, or didn't use explicit transactions, or made some other
mistake that made SQLite3 go slow, or whatever.
> one good test is worth a thousand expert opinions. If you'd like to
> write a prototype for search that uses SQLite, I'm sure we would be
> interested to see how it performs.
Sure, but see above. I understand that you guys must be frustrated at
the constant second guessing from everyone else. I'm not asking for a
multi-hundred e-mail thread[*], just enough details to figure out
whether I can or cannot help you.
[*] Like the parent of this sub-thread. IMO there comes a point where
the i-team should just answer challenges via an FAQ and stop
bothering with never ending debates. It's tricky though -- you
can't just ignore good points, but you can't spend all your energy
constantly answering them (and less good points to boot).
_______________________________________________
pkg-discuss mailing list
[email protected]
http://mail.opensolaris.org/mailman/listinfo/pkg-discuss
