[iggy1]

A good reference point for sqlite would be the following site. But it's not really sa-mp related, and probably a more up to date version than sa-mp uses.

http://sqlite.org/docs.html

There you can see how it works internally. There's also the C API on that site which you can use in plugins.