发布sqlite在win下自动下载编译开源项目

为了维护方便，将其开源了。 
代码在： http://code.google.com/p/sqlite-autobuild-win/
原理比较简单：
提供一下版本号，执行脚本sqlite_build.bat <branch>时，会自动从sqlite官网上下载相关源码，最终为你编译生成你要的sqlite3.dll以及独立的sqlite3.exe。
同时你也拥有完整的源代码，非常方便。

目前支持如下版本号：
3_6_16
3_6_22
3_6_3
3_7_3
3070400
3071400
3080000
3080100
3080200

支持的编译器从VC6开始，VS2003, VS2005, VS2008等。
在进入命令行之前，先要初始化VC编译器环境，找到VCVARS32.bat，执行一下，或者VSTools->Visual Studio Command Prompt. 这样，cl, link等命令就都在PATH里头，可以用于编译了。

下边是执行3080200这个版本的完整输出信息：

点击(此处)折叠或打开

1. D:\Projects\springtech\trunk\sqlite>sqlite_build.bat 3080200
2. fetching sqlite-amalgamation-3080200.zip ...
3. --2013-12-28 06:23:35-- http://www.sqlite.org/sqlite-amalgamation-3080200.zip
4. Resolving www.sqlite.org... 67.18.92.124
5. Connecting to www.sqlite.org|67.18.92.124|:80... connected.
6. HTTP request sent, awaiting response... 404 Not Found
7. 2013-12-28 06:23:36 ERROR 404: Not Found.
9. --2013-12-28 06:23:36-- http://www.sqlite.org/2013/sqlite-amalgamation-3080200.zip
10. Resolving www.sqlite.org... 67.18.92.124
11. Connecting to www.sqlite.org|67.18.92.124|:80... connected.
12. HTTP request sent, awaiting response... 200 OK
13. Length: 1473300 (1.4M) [application/zip]
14. Saving to: `sqlite-amalgamation-3080200.zip'
16. 100%[==========================================================>] 1,473,300 295K/s in 6.0s
18. 2013-12-28 06:23:42 (242 KB/s) - `sqlite-amalgamation-3080200.zip' saved [1473300/1473300]
21. 7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
23. Processing archive: sqlite-amalgamation-3080200.zip
25. Extracting sqlite-amalgamation-3080200
26. Extracting sqlite-amalgamation-3080200\shell.c
27. Extracting sqlite-amalgamation-3080200\sqlite3.c
28. Extracting sqlite-amalgamation-3080200\sqlite3ext.h
29. Extracting sqlite-amalgamation-3080200\sqlite3.h
31. Everything is Ok
33. Folders: 1
34. Files: 4
35. Size: 5634577
36. Compressed: 1473300
37. D:\Projects\springtech\trunk\sqlite\sqlite-amalgamation-3080200\sqlite-amalgamation-3080200\shell.c
38. D:\Projects\springtech\trunk\sqlite\sqlite-amalgamation-3080200\sqlite-amalgamation-3080200\sqlite3.c
39. D:\Projects\springtech\trunk\sqlite\sqlite-amalgamation-3080200\sqlite-amalgamation-3080200\sqlite3.h
40. D:\Projects\springtech\trunk\sqlite\sqlite-amalgamation-3080200\sqlite-amalgamation-3080200\sqlite3ext.h
41. 移动了 4 个文件。
42. fetching sqlitedll-3080200.zip ...
43. --2013-12-28 06:23:43-- http://www.sqlite.org/sqlitedll-3080200.zip
44. Resolving www.sqlite.org... 67.18.92.124
45. Connecting to www.sqlite.org|67.18.92.124|:80... connected.
46. HTTP request sent, awaiting response... 404 Not Found
47. 2013-12-28 06:23:43 ERROR 404: Not Found.
49. --2013-12-28 06:23:44-- http://www.sqlite.org/2013/sqlitedll-3080200.zip
50. Resolving www.sqlite.org... 67.18.92.124
51. Connecting to www.sqlite.org|67.18.92.124|:80... connected.
52. HTTP request sent, awaiting response... 404 Not Found
53. 2013-12-28 06:23:44 ERROR 404: Not Found.
56. 7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
59. Error:
60. cannot find archive
61. 系统找不到指定的路径。
62. 系统找不到指定的文件。
63. fetching sqlite-dll-win32-x86-3080200.zip ...
64. --2013-12-28 06:23:45-- http://www.sqlite.org/sqlite-dll-win32-x86-3080200.zip
65. Resolving www.sqlite.org... 67.18.92.124
66. Connecting to www.sqlite.org|67.18.92.124|:80... connected.
67. HTTP request sent, awaiting response... 404 Not Found
68. 2013-12-28 06:23:45 ERROR 404: Not Found.
70. --2013-12-28 06:23:45-- http://www.sqlite.org/2013/sqlite-dll-win32-x86-3080200.zip
71. Resolving www.sqlite.org... 67.18.92.124
72. Connecting to www.sqlite.org|67.18.92.124|:80... connected.
73. HTTP request sent, awaiting response... 200 OK
74. Length: 327949 (320K) [application/zip]
75. Saving to: `sqlite-dll-win32-x86-3080200.zip'
77. 100%[==========================================================>] 327,949 147K/s in 2.2s
79. 2013-12-28 06:23:48 (147 KB/s) - `sqlite-dll-win32-x86-3080200.zip' saved [327949/327949]
82. 7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
84. Processing archive: sqlite-dll-win32-x86-3080200.zip
86. Extracting sqlite3.def
87. Extracting sqlite3.dll
89. Everything is Ok
91. Files: 2
92. Size: 646431
93. Compressed: 327949
94. 已复制 1 个文件。
95. begin building sqlite-amalgamation-3080200
96. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
97. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
98. cl : Command line warning D9035 : option 'o' has been deprecated and will be removed in a future release
99. shell.c
100. sqlite3.c
101. Generating Code...
102. sqlite3.exe build finished ......
103. cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
104. cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
105. cl : Command line warning D9035 : option 'GZ' has been deprecated and will be removed in a future release
106. cl : Command line warning D9036 : use 'RTC1' instead of 'GZ'
107. cl : Command line warning D9002 : ignoring unknown option '/MLd'
108. cl : Command line warning D9002 : ignoring unknown option '/YX'
109. cl : Command line warning D9002 : ignoring unknown option '/debug'
110. sqlite3.c
111. LINK : warning LNK4044: unrecognized option '/pdbtype:sept'; ignored
112. LINK : sqlite3.dll not found or not built by the last incremental link; performing full link
113. Creating library sqlite3.lib and object sqlite3.exp
114. sqlite3.dll build finished ......
115. end building sqlite-amalgamation-3080200
116. -----------------------------------------------

在google code上也有完整的readme.
下载方法：

用tortoise svn client, 就可以直接下载：
svn checkout  http://sqlite-autobuild-win.googlecode.com/svn/trunk/  sqlite-autobuild-win-read-only

如果你有兴趣，也可以加入此开源项目，共同维护以后各个branch的自动下载和编译。