SQLite3 移植到 ARM

来源：互联网发布：淘宝网游交易编辑：程序博客网时间：2024/05/21 15:39

Tableof Contents

1. SqLite Porting – porting to arm step by step

2. AppendixA – Features Of SQLite

3. AppendixB – SQLite command

1. SqLite Porting

1. Download sqlitesource

URL: http://www.sqlite.org/download.html

Package src: sqlite3-3.6.23.1.bin.gz

Package doc: sqlite_docs_3_6_23.zip

2. Decompressionpackage

$ tar -zxvf sqlite-amalgamation-3.6.23.1.tar.gz

3. Confirm your Crosscompiler is arm-linux-gcc, in my notebook, version is 3.4.5

$ echo $PATH

/crosstool/gcc-3.4.5-glibc-2.3.6/arm-softfloat-linux-gnu/bin:

$ arm-linux-gcc--version

arm-linux-gcc (GCC) 3.4.5

4. Configure

I installed sqlite3 under sqlite_build:

$ mkdirsqlite_build

See more information: ./configure --help

/sqlite-3.6.23.1$ ./configure --host=arm-linux --prefix /

=/home/furtherchan/work/sqlite_porting/sqlite_build

5. make and makeinstall, then you’ll find some files in the sqlite_build dir

(1).view file

furtherchan@further:~/work/sqlite_porting/sqlite_build$ ls

bin include lib share

(2). In embedded system, file size, the smaller the better, using arm-linux-strip to remove symbolsand sections from files.

furtherchan@further:~/work/sqlite_porting/sqlite_build/lib$ arm-linux-strip libsqlite3.so.0.8.6

furtherchan@further:~/work/sqlite_porting/sqlite_build/lib$file libsqlite3.so.0.8.6

libsqlite3.so.0.8.6: ELF 32-bit LSBshared object, ARM, version 1, dynamically linked, stripped

(3).if you don’t have follow symbol link, use “ln -s” command to create it.

furtherchan@further:~/work/sqlite_porting/sqlite_build/lib$ll libsqlite3.so.0

lrwxrwxrwx 1 furtherchan furtherchan 192010-06-22 20:59 libsqlite3.so.0 -> libsqlite3.so.0.8.6

(4). copy /bin/sqlite3 into target board /usr/bin/ directory, /lib/ibsqlite3.so.0.8.6 and libsqlite3.so.0 into /lib directory,

6. Start testing, the follow codes are comefrom: sqlite-3_6_23-docs/quickstart.html

//test.c

#include <stdio.h>

#include <sqlite3.h>

static int callback(void *NotUsed, intargc, char **argv, char**azColName){

int i;

for(i=0; i<argc; i++){

printf("%s = %s/n",azColName[i], argv[i] ? argv[i] : "NULL");

}

printf("/n");

return 0;

}

int main(int argc, char **argv){

sqlite3 *db;

char *zErrMsg = 0;

int rc;

if( argc!=3 ){

fprintf(stderr, "Usage: %s DATABASESQL-STATEMENT/n", argv[0]);

exit(1);

}

rc = sqlite3_open(argv[1], &db);

if( rc ){

fprintf(stderr, "Can't open database:%s/n", sqlite3_errmsg(db));

sqlite3_close(db);

exit(1);

}

rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);

if( rc!=SQLITE_OK ){

fprintf(stderr, "SQL error: %s/n",zErrMsg);

sqlite3_free(zErrMsg);

}

sqlite3_close(db);

return 0;

}

7. Compiling test.c

$arm-linux-gcc -I/home/furtherchan/work/sqlite_porting/sqlite_build//

include-L/home/furtherchan/work/sqlite_porting/sqlite_build/lib -o test test.c-lsqlite3

$file test

test: ELF 32-bit LSB executable, ARM,version 1, dynamically linked (uses shared libs), for GNU/Linux 2.4.3, not stripped

8. Testsqlite3 in target board:

# echo$PATH

/sbin:/usr/sbin:/bin:/usr/bin

# echo$LD_LIBRARY_PATH

/Qtopia/lib:/lib:

# whichsqlite3

/usr/bin/sqlite3

# sqlite3

SQLiteversion 3.6.23.1

Enter".help" for instructions

Enter SQLstatements terminated with a ";"

sqlite>create table gps(pos_x varchar(20), pos_y varchar(20));

sqlite>insert into gps values('123.4', '567.8');

sqlite>select * from gps;

123.4|567.8

sqlite>./test

Usage:./test DATABASE SQL-STATEMENT

2. Appendix A

FeaturesOf SQLite

· Transactions are atomic, consistent, isolated, anddurable (ACID) even after system crashes and power failures.

· Zero-configuration - no setup or administration needed.

· Implements most of SQL92. (Features notsupported)

· A complete database is stored in a singlecross-platform disk file.

· Supports terabyte-sized databases and gigabyte-sized strings andblobs. (See limits.html.)

· Small code footprint: less than 300KiB fully configured or less than 180KiBwith optional features omitted.

· Faster than popular client/server databaseengines for most common operations.

· Simple, easy to use API.

· Written in ANSI-C. TCL bindings included. Bindings for dozens of otherlanguages available separately.

· Well-commented source code with 100% branch test coverage.

· Available as a singleANSI-C source-code file that you can easily drop into another project.

· Self-contained: no external dependencies.

· Cross-platform: Unix (Linux and Mac OS X), OS/2, and Windows(Win32 and WinCE) are supported out of the box. Easy to port to other systems.

· Sources are in the public domain. Use for any purpose.

· Comes with a standalone command-lineinterface (CLI)client that can be used to administer SQLite databases.

3. Appendix B

SQLitecommand: from help

sqlite> .help

.backup ?DB? FILE Backup DB (default "main") toFILE

.bail ON|OFF Stop after hitting an error. Default OFF

.databases List names and files of attacheddatabases

.dump ?TABLE? ... Dump the database in an SQL text format

If TABLE specified,only dump tables matching

LIKE pattern TABLE.

.echo ON|OFF Turn command echo on or off

.exit Exit this program

.explain ?ON|OFF? Turn output mode suitable for EXPLAIN on oroff.

With no args, it turnsEXPLAIN on.

.header(s) ON|OFF Turn display of headers on or off

.help Show this message

.import FILE TABLE Import data from FILE into TABLE

.indices ?TABLE? Show names of all indices

If TABLE specified,only show indices for tables

matching LIKE patternTABLE.

.load FILE ?ENTRY? Load an extension library

.log FILE|off Turn logging on or off. FILE can be stderr/stdout

.mode MODE ?TABLE? Set output mode where MODE is one of:

csv Comma-separated values

column Left-aligned columns. (See .width)

html HTML <table> code

insert SQL insert statements for TABLE

line One value per line

list Values delimited by .separator string

tabs Tab-separated values

tcl TCL list elements

.nullvalue STRING Print STRING in place of NULL values

.output FILENAME Send output to FILENAME

.output stdout Send output to the screen

.prompt MAIN CONTINUE Replace the standard prompts

.quit Exit this program

.read FILENAME Execute SQL in FILENAME

.restore ?DB? FILE Restore content of DB (default"main") from FILE

.schema ?TABLE? Show the CREATE statements

If TABLE specified,only show tables matching

LIKE pattern TABLE.

.separator STRING Change separator used by output mode and.import

.show Show the current values forvarious settings

.tables ?TABLE? List names of tables

If TABLE specified,only list tables matching

LIKE pattern TABLE.

.timeout MS Try opening locked tables for MSmilliseconds

.width NUM1 NUM2 ... Set column widths for "column"mode

.timer ON|OFF Turn the CPU timer measurement on oroff