# sqlite

**Repository Path**: fulinux/sqlite

## Basic Information

- **Project Name**: sqlite
- **Description**: 数据库移植
- **Primary Language**: C
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2014-07-25
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README


This package contains:

 * the SQLite library amalgamation (single file) source code distribution,
 * the shell.c file used to build the sqlite3 shell too, and
 * the sqlite3.h and sqlite3ext.h header files required to link programs
   and sqlite extensions against the installed libary.
 * autoconf/automake installation infrastucture.

The generic installation instructions for autoconf/automake are found
in the INSTALL file.

The following SQLite specific boolean options are supported:

  --enable-readline           use readline in shell tool   [default=yes]
  --enable-threadsafe         build a thread-safe library  [default=yes]
  --enable-dynamic-extensions support loadable extensions  [default=yes]

The default value for the CFLAGS variable (options passed to the C 
compiler) includes debugging symbols in the build, resulting in larger
binaries than are necessary. Override it on the configure command
line like this:

  $ CFLAGS="-Os" ./configure

to produce a smaller installation footprint.

Other SQLite compilation parameters can also be set using CFLAGS. For
example:

  $ CFLAGS="-Os -DSQLITE_OMIT_TRIGGERS" ./configure


STEPS:

 * 首先创建一个工程根目录下创建一个安装目录。
$mkdir install

 * 配置、编译和安装sqlite，相关的执行文件，头文件和库都在install目录下面。
$./configure --prefix=/home/fulinux/sqlite/install/ && make install

 * 编译一个测试文件，用来测试工程根目录下前面创建的一个test.db数据库，并显示其中的内容。
$gcc -g test.c -o test -lsqlite3 -L /home/fulinux/sqlite/install/lib/ -I /home/fulinux/sqlite/install/include/

$./test test.db "select * from test;"
id = 1
value = hxl

id = 2
value = sqlite

id = 3
value = test

id = 4
value = for

id = 5
value = linux