What is the best solution, in your opinion ? I like the idea to just include the source to my project and have it being build with my project. Is there and drawback to this solution ?
Both have advantages and disadvantages.
Including the sources in the project will make the project source tree more portable in that you won't have to install SQLite on a machine before doing development work.
Building SQLite static and standalone makes it much easier to upgrade SQLite as new versions are released, which happens relatively frequently. It also separates your sources from third party sources.
Personally, I always build open source projects independently from my projects. I also generally check the open source projects out from their cvs/svn repositories. And I'll do so by tag, if I need to be locked to a release version. This also allows me to easily quantify changes to the OS project over time and track my own changes, if necessary.
b.bum
