This project's goal is to create a demonstration application that works with the SQLite library on the OpenWRT platform. The program will be written in the C language, and will use the sqlite3 library (and not the sqlite3 command line interface application).
The application will create a new database, create a table, load a few rows of data into the table, and then read the results of the table.
I have some example code that can be used as a starting point. It works properly on my Ubuntu linux system, but I was not able to get it to work on OpenWRT.
## Deliverables
FURTHER DETAILS:
The deliverable for this project will be a set of three files:
1) the source code for the application, written in C. This file will perform 4 tasks:
task 1: create a new SQLite database, eg. "/tmp/[login to view URL]"
task 2: create a new table in the database, eg. "users" with colums "id" and "name"
task 3: add 2 rows of data to the table, eg. (1,"Joe"),(2,"Fred")
task 4: display the contents of the table, eg. send to stdout
This project will use version 3.5.9 of SQLite (can be downloaded here: [login to view URL] )
This project will use version 8.09_RC1 of OpenWRT ([login to view URL]). The code will be tested on the broadcom-2.4 version of OpenWRT.
The code must run on both linux (Ubuntu 8.10) and the Broadcom-2.4 version of OpenWRT.
The interface for this program will be a simple command line. The program can be called "sqlite-demo" and take one command line argument, which will be used as the name of the database. As an example, the user would run this program by typing this command at the prompt:
sqlite-demo [login to view URL]
The program would then load and create the database, create the table, and insert the rows, then close the database. As it runs, it should print some status messages to stdout to let the user know it is making progress.
2) Makefile for compiling on linux, and the command to compile the program
3) Makefile for OpenWRT package system. This will work with the "make menuconfig" "make package/sqlite-demo-compile" style of building packages.
More detail about the buildroot system can be found here: [login to view URL]
Optionally, the code could use the file I've attached to this request as a starting point. Or the code could be written from scratch.
Success is defined as a successful compile and run on both my Linux system and my OpenWRT system. Note that the compile process for OpenWRT will be a cross-compile as done by OpenWRT's buildroot system.
Please let me know if you need more details about either of these systems to complete the project. As a start, here are some version numbers of some of the relevant software installed on my OpenWRT system (as reported by "opkg list_installed":
libsqlite3 - 3.5.9-1
sqlite3-cli - 3.5.9-1
libgcc - 3.4.6-13
libncurses - 5.6-1
libpthread - 0.9.29-13
libreadline - 5.2-1
Thanks!
* * *This broadcast message was sent to all bidders on Friday Jan 30, 2009 9:13:08 AM:
Please note that I will be traveling until Feb 1 and unable to respond to messages until then. Thanks, Dan.