好久没有光顾sqlite了,没想到已经到了3.7.8了。
以前手动下载,并且建工程,编译,挺浪费时间的。干脆用wget, 7z, 结合批处理,整理成一个可以下载并编译成dll和exe的脚本。至于wget, 7z,网上都可以直接下载,不再缀述。
运行脚本之前,请先将vs2008(或者vs2005,vs2003,甚至vc6)的vcvars32.bat运行一下,得到vc的编译环境。内容如下:
- @echooff
- setversion=%1
- setos_cpu=win32-x86
- rem
- remfromsqlite3.7.4,
- remsqlite3-product-version.zip
- remsqlite3-product-version.tar.gz
- remsqlite3-product-os-cpu-version.zip
- remsqlite3-product-date.zip
- @remsqlite-build307050030704003070800
- ifnotexist"sqlite-amalgamation-%version%.zip"(
- echofetchingsqlite-amalgamation-%version%.zip...
- wgethttp:
- ifnotexist"sqlite-amalgamation-%version%.zip"(
- echodownloadsqlite-amalgamation-%version%.ziperror!
- gotoEOF
- )
- )
- 7zx-y-o.\sqlite-amalgamation-%version%"sqlite-amalgamation-%version%.zip"
- ifexist".\sqlite-amalgamation-%version%\sqlite-amalgamation-%version%"(
- move.\sqlite-amalgamation-%version%\sqlite-amalgamation-%version%\*.\sqlite-amalgamation-%version%\
- )
- ifnotexist".\sqlite-amalgamation-%version%\shell.c"(
- echocopyshell.cfromanotherlocation...
- ifnotexist".\sqlite-source-%version%.zip"(
- echofetchingsqlite-source-%version%.zip...
- wgethttp:
- )
- 7zx-y-o.\sqlite-source-%version%"sqlite-source-%version%.zip"
- copy/y.\sqlite-source-%version%\shell.c.\sqlite-amalgamation-%version%\
- rd/s/qsqlite-source-%version%
- echocopyshell.cfromanotherlocation...
- ifnotexist".\sqlite-src-%version%.zip"(
- echofetchingsqlite-src-%version%.zip...
- wgethttp:
- )
- 7zx-y-o.\"sqlite-src-%version%.zip"
- copy/y.\sqlite-src-%version%\shell.c.\sqlite-amalgamation-%version%\
- rd/s/qsqlite-src-%version%
- )
- ifnotexist".\sqlite-amalgamation-%version%\sqlite3.def"(
- ifnotexist"sqlitedll-%version%.zip"(
- echofetchingsqlitedll-%version%.zip...
- wgethttp:
- )
- 7zx-y-o.\sqlitedll-%version%"sqlitedll-%version%.zip"
- copy/y.\sqlitedll-%version%\sqlite3.def.\sqlite-amalgamation-%version%\
- rd/s/qsqlitedll-%version%
- echotryanotherdllzip
- ifnotexist"sqlite-dll-%os_cpu%-%version%.zip"(
- echofetchingsqlite-dll-%os_cpu%-%version%.zip...
- wgethttp:
- )
- 7zx-y-o.\sqlite-dll-%os_cpu%-%version%"sqlite-dll-%os_cpu%-%version%.zip"
- copy/y.\sqlite-dll-%os_cpu%-%version%\sqlite3.def.\sqlite-amalgamation-%version%\
- rd/s/qsqlite-dll-%os_cpu%-%version%
- )
- cd/dsqlite-amalgamation-%version%
- echobeginbuildingsqlite-amalgamation-%version%
- cl-Gs-GX-D_WIN32-nologo-Zi-DOS_WIN=1-DSQLITE_DEBUG=1-DWIN32=1-DTHREADSAFE=1-DSQLITE_OS_WIN=1-DSQLITE_ENABLE_COLUMN_METADATA=1-DSQLITE_SOUNDEX=1-DSQLITE_OMIT_LOAD_EXTENSION=1-I.shell.csqlite3.c-osqlite3.exe
- echosqlite3.exebuildfinished......
- cl/nologo/MLd/W3/Gm/GX/ZI/Od/D"WIN32"/D"_DEBUG"/D"_WINDOWS"/D"_MBCS"/D"_USRDLL"/D"SQLITE3_EXPORTS"/DTHREADSAFE=1/DSQLITE_OS_WIN=1/DSQLITE_ENABLE_COLUMN_METADATA=1/DSQLITE_SOUNDEX=1/DQLITE_OMIT_LOAD_EXTENSION=1/DSQLITE_ENABLE_RTREE=1/YX/Fp"sqlite3.pch"/FD/GZ/c/debugsqlite3.c
- remlib-out:"sqlite3.lib"sqlite3.obj
- link.exekernel32.libuser32.lib/nologo/dll/incremental:yes/debug/machine:I386/pdb:"sqlite3.pdb"/def:"sqlite3.def"/out:"sqlite3.dll"/implib:"sqlite3.lib"/pdbtype:septsqlite3.obj
- echosqlite3.dllbuildfinished......
- echoendbuildingsqlite-amalgamation-%version%
- echo-----------------------------------------------
- cd/d..
- :EOF
- @echoon
以下是我的执行结果:引用
fetching sqlite-amalgamation-3070800.zip ...
--2011-09-20 08:48:30-- http://www.sqlite.org/sqlite-amalgamation-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 1329197 (1.3M) [application/zip]
Saving to: `sqlite-amalgamation-3070800.zip'
100%[==========================================================>] 1,329,197 119K/s in 11s
2011-09-20 08:48:41 (120 KB/s) - `sqlite-amalgamation-3070800.zip' saved [1329197/1329197]
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Processing archive: sqlite-amalgamation-3070800.zip
Extracting sqlite-amalgamation-3070800
Extracting sqlite-amalgamation-3070800\shell.c
Extracting sqlite-amalgamation-3070800\sqlite3.c
Extracting sqlite-amalgamation-3070800\sqlite3.h
Extracting sqlite-amalgamation-3070800\sqlite3ext.h
Everything is Ok
Folders: 1
Files: 4
Size: 5059684
Compressed: 1329197
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\shell.c
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3.c
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3.h
E:\xionghe\sqlite\sqlite-3.7.3\demo\sqlite-amalgamation-3070800\sqlite-amalgamation-3070800\sqlite3ext.h
fetching sqlitedll-3070800.zip ...
--2011-09-20 08:48:46-- http://www.sqlite.org/sqlitedll-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2011-09-20 08:48:47 ERROR 404: Not Found.
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Error:
cannot find archive
The system cannot find the path specified.
The system cannot find the file specified.
try another dll zip
fetching sqlite-dll-win32-x86-3070800.zip ...
--2011-09-20 08:48:47-- http://www.sqlite.org/sqlite-dll-win32-x86-3070800.zip
Resolving www.sqlite.org... 67.18.92.124
Connecting to www.sqlite.org|67.18.92.124|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 289182 (282K) [application/zip]
Saving to: `sqlite-dll-win32-x86-3070800.zip'
100%[==========================================================>] 289,182 127K/s in 2.2s
2011-09-20 08:48:51 (127 KB/s) - `sqlite-dll-win32-x86-3070800.zip' saved [289182/289182]
7-Zip 9.15 beta Copyright (c) 1999-2010 Igor Pavlov 2010-06-20
Processing archive: sqlite-dll-win32-x86-3070800.zip
Extracting sqlite3.def
Extracting sqlite3.dll
Everything is Ok
Files: 2
Size: 575107
Compressed: 289182
1 file(s) copied.
begin building sqlite-amalgamation-3070800
cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
cl : Command line warning D9035 : option 'o' has been deprecated and will be removed in a future release
shell.c
sqlite3.c
Generating Code...
sqlite3.exe build finished ......
cl : Command line warning D9035 : option 'GX' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'EHsc' instead of 'GX'
cl : Command line warning D9035 : option 'GZ' has been deprecated and will be removed in a future release
cl : Command line warning D9036 : use 'RTC1' instead of 'GZ'
cl : Command line warning D9002 : ignoring unknown option '/MLd'
cl : Command line warning D9002 : ignoring unknown option '/YX'
cl : Command line warning D9002 : ignoring unknown option '/debug'
sqlite3.c
LINK : warning LNK4044: unrecognized option '/pdbtype:sept'; ignored
LINK : sqlite3.dll not found or not built by the last incremental link; performing full link
Creating library sqlite3.lib and object sqlite3.exp
sqlite3.dll build finished ......
end building sqlite-amalgamation-3070800
-----------------------------------------------
分享到:
相关推荐
sqlite最新编译好的x64库,包括sqlite.dll和sqlite.lib,即开即用,无需动手编译.
sqlite3,已经编译好的DLL,lib,.H文件,拿来就可以用
既可以支撑QGIS在Windows环境下的编译工作,也可以进行Sqlite3的二次研发。 四、其他说明 在Windows环境下,基于Qt Creator进行编译的Sqlite3开源库。包含有头文件include、库文件lib、动态库dll等,提供了Debug、...
gcc使用的sqlite3数据库,sqlite3.a ,可以用于Dev-C++,也可以用于Windows下使用gcc编译的程序,sqlite版本是:3270200,还包含了sqlite3.lib库文件,可以用于visual studio。
简单整合32位SQLite跟64位SQLite,项目属性设置为anycpu的时候不会再有烦人的编译平台不同的提示,sqlite会自动根据系统的位数,而选择相应的版本。 同时还阔以解决System.DllNotFoundException: 无法加载 DLL...
注册命令: rundll32 sqlite3odbc.dll,install 卸载命令: rundll32 sqlite3odbc.dll,uninstall
使用 mingw 编译出 sqlite3.dll 和 sqlite3.exe 2. lsqlite3 (也是本压缩包的原型) http://lua.sqlite.org 从下面网址下载 Version 0.8 http://lua.sqlite.org/index.cgi/zip/lsqlite3_svn08.zip?uuid=svn_8 ...
用源码整合sqlite3 odbc + wxsqlite3 编译 用 AES128 加密方式的ODBC驱动程序, 并附带修改sqlite3 db密码工具. 需要自行替换或注册 sqlite3odbc.dll. 稳定通过各种测试.(PB, VC++等)
win10系统编译的sqlcipher执行工具,库...VS2017 x64编译sqlcipher-4.0.1,sqlcipher可执行,如果执行失败,将libcrypto-1_1-x64.dll放在C:\Windows\System32\文件夹下。 库和头文件导入到其他项目时记得采用x64平台。
2.sqlite3.7.5以前的sqlite_amalgamation包内包括shell.c,sqlite3.c,sqlite3.def,sqlite3.h,sqlite3ext.h五个文件,可在VS环境下编译生成sqlite3.lib和sqlite3.dll,具体编译设置过程参看网上文献:...
sqlite3官网上也可以下载dll文件直接用,但是使用的时候有事会出问题,笔者在C++ builder下使用的时候就有问题。工程是笔者参照官网说明,修改了一些bug,自己编译sqlite3.dll时的工程,可以放心使用。编译过程如有...
wxsqlite 加密 已编译好的 dll, lib,有32/64/debug/release版本 注意有加密的数据库文件必须先open后解密,中间不能有其他调用否则容易失败,sqlite3.h中写的.
SqLite3编译好的dll,lib ,适合x86 和x64平台使用,编译工具vs2015
sqlite3 是一个开源的小型数据库。本文件是C++访问sqlite3的动态库和静态库。大家下载只需要编译一下即可出现lib和dll文件,非常方面
Visual studio 2012 下 sqlite3的工程文件,生成32或64位的sqlite3库 This page explains how to compile SQLite with Microsoft Visual Studio.NET (aka VS.NET). Download Download and unzip the file sqlite_...
使用Qt Creator编译sqlite3,均是源代码,可以实现sqlite跨平台编译。工程很简单,只是sqlite的源代码及配置好的pro文件。
vs2017 x64位下编译的 sqlite3。包括sqlite3.c & sqlite3.def & sqlite3.h , sqlite3.lib & sqlite3d.lib, sqlite3.dll & sqlite3d.dll。成功用于osgearth三方库编译。 另外还包括sqlite3源码,附上两种编译方法,...
Win64操作系统,在sqliteodbc...它由SQLite 3.32.3和MinGW交叉编译器组成,包含驱动程序DLL和用于安装和卸载ODBC驱动程序的程序。请注意,这是仅64位驱动程序。如果在Win64上使用32位软件,则也应该安装Win32驱动程序。
System.Data.SQLite 官网的 download 中的 Precompiled Binaries for 32-bit Windows (.NET Framework 4.6) sqlite-netFx46-binary-bundle-Win32-2015-1.0.112.0.zip (3.24 MiB)
sqlite3 64位 开发所需文件,自己要用干脆就编译了一份