This is a little tutorial of how to use sqlite with Code::Blocks. It is assumed that you have already installed Code::Blocks with MinGW.
This is the way I did it:
1. Download sqlitedll-3_6_22.zip and sqlite-source-3_6_22.zip fromhttp://www.sqlite.org/download.html
2. Extract sqlitedll-3.6.22.zip in some folderand then run from the command line,go to the directory of the folder:
dlltool -D sqlite3.dll -d sqlite3.def -l libsqlite3dll.a
You will now have libsqlite3dll.a,which should be placed in the MinGW lib directory.
3. Place sqlite3.dll in your system path.
4. Extract sqlite-source-3_6_22.zip and place sqlite3.h in your MinGW include directory.