Get the scoop on SQLite with this slideshow

[Corey]

This is pretty cool, it's aimed at PHPers but it's a really great overview of SQLite and how top optimize your queries in a quick and easy slideshow format:

http://www.sqlite.org/php2004/page-001.html

I think I'm going to start using SQLite quite a bit. SQLite is "dropping it like it's hot" as the kids say. :yes

[Intrigued]

SQLite... makes me say "bling bling" often.

:D

[Corey]

The I-dog dropping it like it's hot. Yo, that's off da chain B. Anyhow, if it's Trump enough for the O.G. dictionaries, then who am I to be tripping?

http://dictionary.reference.com/search?r=2&q=bling-bling

[Intrigued]

Corey, I read that 63 page document just now...

I found a couple pages that caught my eye and then one towards the end.

Pages: 39 -> 40

and then...

Page 62 summing it up.

One other thing interested me. The use of Explain.

It made a lot more since this time around (reading such), now that I have used SQLite.

[Corey]

Cool. I have to re-read it when I get time, or more importantly in conjunction with building some sort of SQL driven app so the knowledge hits home. Anyhow I read through it once, it's got some very handy info. Definitely made me re-think the way I query. Now if I could only remember the conclusions I'd reached I'd be in good shape... :wow

[Intrigued]

Yes, the use of indices is a point I also dragged away from the document.

Piece-by-piece we shall unite the whole of SQLite!

(ah, that's my Lionheart speech I think, sorry, mixed messages up ;-))

[Corey]

It's sure an awesome system. I don't think most people realize how well developed SQlite is. It's got more than enough firepower for most basic scenarios.