LiteWrap. Wrapper for SQLite. Simple API to return a query as table in memory. No lock left on database. Random access on returned data. Data may be kept indefinitelly. Contains several functions for displying/streaming result table. Now with a simple shell.

simple_sqlite_wrap. The code extends sqlite so you are now able to execute sql statements off a file (see the how we use routes.sql in the example), return a recordset that is formatted into well defined rows and columns and execute a simple sql statement.

sqlite.ico (29.22 KB)
contributed by Brannon King on 2006-07-18 17:14:49

This is a Windows (non XP) icon file built from the logo using the "Real World Icon Editor" for compilation into the shell. Just add it as a resource to exe compiles.

exeWtimer.zip (203.86 KB)
contributed by Brannon King on 2006-07-18 18:23:39

This file contains a Windows exe of the sqlite3.exe utility. It is changed in that it has options (on by default) to output the time the query required. You can also shut off the output printing so that the timer does not include the time to render the text to the console. The shell.c (v1.144) is included as well. The shell.c should work on Linux as well, though it has not been tested.

Experimental combination of SQLite 3.3.x and TinyCC 0.9.23
using the new SQLite loadable extension mechanism.
An extension module creates an SQLite scalar function
'tcc_compile' which takes one argument which is a string
made up of C source code to be on-the-fly compiled using
TinyCC (www.tinycc.org). The SQLite API is visible during
compilation when 'sqlite3.h' is included.
So far, only partially tested on Linux i386.

This is a working demonstration of sqlite3 wrapped as
a client-server pair, based on an earlier implementation
for sqlite2 http://www.it77.de/sqlite/sqlite.htm.
This demo was developed and tested only under win32.

I am working to a software project (WINNERS' Project) embedding a server web a database (starting from SQLite) and a content generator. So I am rewriting all sqlite in C++. I cleaned SQLite C code to obtain a more compact source code and a faster and shorter binary code before rewriting it in C++. This file, result of my efforts, is a "work in progress" to C++ so it is not intended to work (I have to debug final job) but and you can use any portion to substitute slower SQLite functions I improved.