sqlite fundamentals

Question

How to build sqlite3 library to use with bode blocks mingw compiler? Already I downloaded sqlite amalgamation it contains four files shell.c, sqlite3.c, sqlite3.h, sqlite3ext.h I want to create sqlite3.a library.

(I'm using win xp sp3)

Answer 1

The recommended way to use SQLite is to compile it statically into your program, i.e., just add the sqlite3.c file to your other source files.