Sqlite3.8.1移植到TQ2416(在ARM-Linux平台上移植SQLite)

在ARM-Linux平台上移植SQLite,Port SQLite to ARM-Linux Platform.
一，交叉编译器：
arm-linux-gcc-4.4.1

二、移植步骤
下载源码
http://www.sqlite.org/2013/sqlite-autoconf-3080100.tar.gz

1.解压压缩包并改名进入解压后的目录，如下：

cd sqlite3.8.1

2.创建一个目录_install并进入该目录，用于在这个目录中进行交叉编译，如下：
mkdir _install
cd _install

3.在_install目录中运行sqlite3.8.1中的configure脚本生成Makefile文件，如下：
../configure CC=arm-linux-gcc –host=arm-linux –prefix=/home/gl/e/sqlite3.8.1/_install
选项host指定的是用arm交叉编译器(非交叉环境不用指定)进行编译 选项prefix后面的路径是到时候编译安装后目标存放的目录，

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
[root@austgl _install]# ../configure CC=arm-linux-gcc --host=arm-linux --prefix=/home/gl/e/sqlite3.8.1/_install/  
checking for a BSD-compatible install... /usr/bin/install -c  
checking whether build environment is sane... yes  
checking for arm-linux-strip... arm-linux-strip  
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p  
checking for gawk... gawk  
checking whether make sets $(MAKE)... yes  
checking for style of include used by make... GNU  
checking for arm-linux-gcc... arm-linux-gcc  
checking whether the C compiler works... yes  
checking for C compiler default output file name... a.out  
checking for suffix of executables...   
checking whether we are cross compiling... yes  
checking for suffix of object files... o  
checking whether we are using the GNU C compiler... yes  
checking whether arm-linux-gcc accepts -g... yes  
checking for arm-linux-gcc option to accept ISO C89... none needed  
checking dependency style of arm-linux-gcc... gcc3  
checking for special C compiler options needed for large files... no  
checking for _FILE_OFFSET_BITS value needed for large files... 64  
checking for arm-linux-gcc... (cached) arm-linux-gcc  
checking whether we are using the GNU C compiler... (cached) yes  
checking whether arm-linux-gcc accepts -g... (cached) yes  
checking for arm-linux-gcc option to accept ISO C89... (cached) none needed  
checking dependency style of arm-linux-gcc... (cached) gcc3  
checking for arm-linux-ranlib... arm-linux-ranlib  
checking build system type... x86_64-unknown-linux-gnu  
checking host system type... arm-unknown-linux-gnu  
checking how to print strings... printf  
checking for a sed that does not truncate output... /usr/bin/sed  
checking for grep that handles long lines and -e... /usr/bin/grep  
checking for egrep... /usr/bin/grep -E  
checking for fgrep... /usr/bin/grep -F  
checking for ld used by arm-linux-gcc... /home/gl/e/4.4.3/arm-none-linux-gnueabi/bin/ld  
checking if the linker (/home/gl/e/4.4.3/arm-none-linux-gnueabi/bin/ld) is GNU ld... yes  
checking for BSD- or MS-compatible name lister (nm)... /home/gl/e/4.4.3/bin/arm-linux-nm -B  
checking the name lister (/home/gl/e/4.4.3/bin/arm-linux-nm -B) interface... BSD nm  
checking whether ln -s works... yes  
checking the maximum length of command line arguments... 1572864  
checking whether the shell understands some XSI constructs... yes  
checking whether the shell understands "+="... yes  
checking how to convert x86_64-unknown-linux-gnu file names to arm-unknown-linux-gnu format... func_convert_file_noop  
checking how to convert x86_64-unknown-linux-gnu file names to toolchain format... func_convert_file_noop  
checking for /home/gl/e/4.4.3/arm-none-linux-gnueabi/bin/ld option to reload object files... -r  
checking for arm-linux-objdump... arm-linux-objdump  
checking how to recognize dependent libraries... pass_all  
checking for arm-linux-dlltool... no  
checking for dlltool... no  
checking how to associate runtime and link libraries... printf %s\n  
checking for arm-linux-ar... arm-linux-ar  
checking for archiver @FILE support... @  
checking for arm-linux-strip... (cached) arm-linux-strip  
checking for arm-linux-ranlib... (cached) arm-linux-ranlib  
checking command to parse /home/gl/e/4.4.3/bin/arm-linux-nm -B output from arm-linux-gcc object... ok  
checking for sysroot... no  
checking for arm-linux-mt... no  
checking for mt... no  
checking if : is a manifest tool... no  
checking how to run the C preprocessor... arm-linux-gcc -E  
checking for ANSI C header files... yes  
checking for sys/types.h... yes  
checking for sys/stat.h... yes  
checking for stdlib.h... yes  
checking for string.h... yes  
checking for memory.h... yes  
checking for strings.h... yes  
checking for inttypes.h... yes  
checking for stdint.h... yes  
checking for unistd.h... yes  
checking for dlfcn.h... yes  
checking for objdir... .libs  
checking if arm-linux-gcc supports -fno-rtti -fno-exceptions... no  
checking for arm-linux-gcc option to produce PIC... -fPIC -DPIC  
checking if arm-linux-gcc PIC flag -fPIC -DPIC works... yes  
checking if arm-linux-gcc static flag -static works... yes  
checking if arm-linux-gcc supports -c -o file.o... yes  
checking if arm-linux-gcc supports -c -o file.o... (cached) yes  
checking whether the arm-linux-gcc linker (/home/gl/e/4.4.3/arm-none-linux-gnueabi/bin/ld) supports shared libraries... yes  
checking whether -lc should be explicitly linked in... no  
checking dynamic linker characteristics... GNU/Linux ld.so  
checking how to hardcode library paths into programs... immediate  
checking whether stripping libraries is possible... yes  
checking if libtool supports shared libraries... yes  
checking whether to build shared libraries... yes  
checking whether to build static libraries... yes  
checking for fdatasync... yes  
checking for usleep... yes  
checking for fullfsync... no  
checking for localtime_r... yes  
checking for gmtime_r... yes  
checking whether strerror_r is declared... yes  
checking for strerror_r... yes  
checking whether strerror_r returns char *... no  
checking for library containing tgetent... no  
checking for library containing readline... no  
checking for readline... no  
checking for library containing pthread_create... -lpthread  
checking for library containing dlopen... -ldl  
checking for whether to support dynamic extensions... yes  
checking for posix_fallocate... yes  
configure: creating ./config.status  
config.status: creating Makefile  
config.status: creating sqlite3.pc  
config.status: executing depfiles commands  
config.status: executing libtool commands

4.执行make和make install命令，如下：
make

  1. [root@austgl _install]# ml]# make  
  2. /bin/sh ./libtool –tag=CC   –mode=compile arm-linux-gcc -DPACKAGE_NAME=\“sqlite\” -DPACKAGE_TARNAME=\”sqlite\” -DPACKAGE_VERSION=\”3.8.1\” -DPACKAGE_STRING=\”sqlite\ 3.8.1\” -DPACKAGE_BUGREPORT=\”http://www.sqlite.org\" -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.8.1\" -D_FILE_OFFSET_BITS=64 -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\“ -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -I. -I..    -D_REENTRANT=1 -DSQLITE_THREADSAFE=1  -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c -o sqlite3.lo ../sqlite3.c  
  3. libtool: link: arm-linux-gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -o .libs/sqlite3 shell.o  ./.libs/libsqlite3.so -ldl -lpthread -Wl,-rpath -Wl,/home/gl/e/sqlite3.8.1/_install/lib  
  4. [root@austgl _install]# ls  
  5. config.log  config.status  libsqlite3.la  libtool  Makefile  shell.o  sqlite3  sqlite3.lo  sqlite3.o  sqlite3.pc  

make install

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
[root@austgl _install]# make install  
make[1]: 进入目录“/home/gl/e/sqlite3.8.1/_install”  
 /usr/bin/mkdir -p '/home/gl/e/sqlite3.8.1/_install/lib'  
 /bin/sh ./libtool   --mode=install /usr/bin/install -c   libsqlite3.la '/home/gl/e/sqlite3.8.1/_install/lib'  
libtool: install: /usr/bin/install -c .libs/libsqlite3.so.0.8.6 /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.so.0.8.6  
libtool: install: (cd /home/gl/e/sqlite3.8.1/_install/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so.0 || { rm -f libsqlite3.so.0 && ln -s libsqlite3.so.0.8.6 libsqlite3.so.0; }; })  
libtool: install: (cd /home/gl/e/sqlite3.8.1/_install/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so || { rm -f libsqlite3.so && ln -s libsqlite3.so.0.8.6 libsqlite3.so; }; })  
libtool: install: /usr/bin/install -c .libs/libsqlite3.lai /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.la  
libtool: install: /usr/bin/install -c .libs/libsqlite3.a /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.a  
libtool: install: chmod 644 /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.a  
libtool: install: arm-linux-ranlib /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.a  
libtool: finish: PATH="/usr/lib64/qt-3.3/bin:/usr/lib64/ccache:/usr/local/bin:/usr/bin:/bin:/usr/games:/usr/local/sbin:/usr/sbin:/home/gl/.local/bin:/home/gl/bin:/home/gl/e/4.4.3/bin:/home/gl/e/arm-2013.05:/sbin" ldconfig -n /home/gl/e/sqlite3.8.1/_install/lib  
ldconfig: /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.so.0.8.6 is for unknown machine 40.  
  
ldconfig: /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.so is for unknown machine 40.  
  
ldconfig: /home/gl/e/sqlite3.8.1/_install/lib/libsqlite3.so.0 is for unknown machine 40.  
  
----------------------------------------------------------------------  
Libraries have been installed in:  
   /home/gl/e/sqlite3.8.1/_install/lib  
  
If you ever happen to want to link against installed libraries  
in a given directory, LIBDIR, you must either use libtool, and  
specify the full pathname of the library, or use the `-LLIBDIR'  
flag during linking and do at least one of the following:  
   - add LIBDIR to the `LD_LIBRARY_PATH' environment variable  
     during execution  
   - add LIBDIR to the `LD_RUN_PATH' environment variable  
     during linking  
   - use the `-Wl,-rpath -Wl,LIBDIR' linker flag  
   - have your system administrator add LIBDIR to `/etc/ld.so.conf'  
  
See any operating system documentation about shared libraries for  
more information, such as the ld(1) and ld.so(8) manual pages.  
----------------------------------------------------------------------  
 /usr/bin/mkdir -p '/home/gl/e/sqlite3.8.1/_install/bin'  
  /bin/sh ./libtool   --mode=install /usr/bin/install -c sqlite3 '/home/gl/e/sqlite3.8.1/_install/bin'  
libtool: install: /usr/bin/install -c .libs/sqlite3 /home/gl/e/sqlite3.8.1/_install/bin/sqlite3  
 /usr/bin/mkdir -p '/home/gl/e/sqlite3.8.1/_install/include'  
 /usr/bin/install -c -m 644 ../sqlite3.h ../sqlite3ext.h '/home/gl/e/sqlite3.8.1/_install/include'  
 /usr/bin/mkdir -p '/home/gl/e/sqlite3.8.1/_install/share/man/man1'  
 /usr/bin/install -c -m 644 ../sqlite3.1 '/home/gl/e/sqlite3.8.1/_install/share/man/man1'  
 /usr/bin/mkdir -p '/home/gl/e/sqlite3.8.1/_install/lib/pkgconfig'  
 /usr/bin/install -c -m 644 sqlite3.pc '/home/gl/e/sqlite3.8.1/_install/lib/pkgconfig'  
make[1]: 离开目录“/home/gl/e/sqlite3.8.1/_install”

编译和安装完后，在/home/gl/e/sqlite3.8.1/_install目录中会生成四个文件夹，分别是：
bin、include、 lib 、share， 如图：

sqlite

然后分别将bin下的文件下载到开发板的/bin目录中，

lib下的所有文件下载到开发板的/lib目录中即可。

include 头文件拷贝到 交叉编译器的 include目录下。

5.在开发板上测试移植的sqlite数据库。执行：

#sqlite3
显示版本信息

  1. [root@EmbedSky /]# sqlite3  
  2. SQLite version 3.8.1 2013-10-17 12:57:35  
  3. Enter “.help” for instructions  
  4. Enter SQL statements terminated with a “;”  
  5. sqlite>   

新建数据库 测试如下
  1. [root@EmbedSky /]# sqlite3 test.db ”create table tab1(name vachar(10),number sma  
  2. llint)”  
  3. [root@EmbedSky /]# sqlite3 test.db ”insert into tab1 values(‘test’,1)”  
  4. [root@EmbedSky /]# sqlite3 test.db ”insert into tab1 values(‘iganlei’,2)”  
  5. [root@EmbedSky /]# sqlite3 test.db ”select * from tab1”  
  6. test|1  
  7. iganlei|2  
  8. [root@EmbedSky /]#   

over……

赏

谢谢你请我吃糖果

支付宝
微信

tag:

    缺失模块。
    1、请确保node版本大于6.2
    2、在博客根目录（注意不是yilia根目录）执行以下命令：
    npm i hexo-generator-json-content --save

    3、在根目录_config.yml里添加配置： 

      jsonContent:
    meta: false
    pages: false
    posts:
      title: true
      date: true
      path: true
      text: false
      raw: false
      content: false
      slug: false
      updated: false
      comments: false
      link: false
      permalink: false
      excerpt: false
      categories: false
      tags: true