Are there any advantages of using either a static library over the linked library (Performace, Speed, Compatibality)?
Depends, but on Windows platforms hardly. It matters startup times and perhaps the ease of deployment. A) On platforms where the system uses SQLite (like SUN Solaris, Apple OS X) the provided library is usually a bit old. In order to include newer functions you may prefer to link the library statically into your application.
