The files below are contributed by users and are not part of the standard SQLite package. The content of these files has not been verified. Use at your own risk.
If you would like to contribute files and need a userid and password, send an email to firstname.lastname@example.org requesting one.
extension-functions.c (50.96 KB) contributed by Liam Healy on 2010-02-06 15:45:07
Provide mathematical and string extension functions for SQL queries using the loadable extensions mechanism. Math: acos, asin, atan, atn2, atan2, acosh, asinh, atanh, difference, degrees, radians, cos, sin, tan, cot, cosh, sinh, tanh, coth, exp, log, log10, power, sign, sqrt, square, ceil, floor, pi. String: replicate, charindex, leftstr, rightstr, ltrim, rtrim, trim, replace, reverse, proper, padl, padr, padc, strfilter. Aggregate: stdev, variance, mode, median, lower_quartile, upper_quartile.
idxchk.py (10.76 KB) contributed by Tom Lynn on 2008-03-07 23:46:27
A Python port of idxchk. Requires pysqlite2, sqlite3 (comes with Python 2.5+) or apsw.
prettyreports.zip (3.43 MB) contributed by Grega Loboda on 2007-10-22 13:39:33
Create reports on SQLite database. Pretty reports are freeware.
WINNERS_embedded_database LAST BETA RELEASE.cpp (916.88 KB) contributed by Ettore Chiacchio on 2007-08-26 06:44:31
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.
sqlite-java-shell-3.4.0.zip (845.13 KB) contributed by Joe Wilson on 2007-06-19 04:35:32
100% pure java version of the sqlite3 command-line shell built with NestedVM. No shared libraries or DLLs required. This is not a JDBC driver.
sqlite-networked.zip (636.60 KB) contributed by Dave Dyer on 2007-04-21 17:06:19
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.
sqlite+tcc.tar.gz (4752 bytes) contributed by Christian Werner on 2006-08-22 17:46:25
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.
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.
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.
simple_sqlite_wrap.tar.gz (23.14 KB) contributed by Joseph Wamicha on 2006-07-07 17:27:51
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_wrapper_0.0.3.tar.gz (7279 bytes) contributed by Ben.Clewett on 2005-06-02 13:34:59
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.
idxchk (9761 bytes) contributed by tpoindex on 2005-02-16 21:07:33
idxchk reports index usage for queries. Can be used to help diagnose performance related problems. See Wiki page for documenation and usage. Version 1.0
DataGrid_DataSet_DataTable.rar (844.84 KB) contributed by Mike Willhite on 2004-12-10 23:24:34
Example Code for working with DataSources, DataTables, DataGrids and SQLite3 in VB.NET with CoreLab SQLite.NET driver.
sqlite_fk.tgz (204.18 KB) contributed by Cody Pisto on 2004-10-14 23:05:34
Utility to generate triggers to enforce foreign key constraints with sqlite, operates on database schema and understands most CREATE TABLE syntax. Win32 and linux x86 binaries included, public domain source code.
mksqlite.zip (14.54 KB) contributed by Mike Cariotoglou on 2004-10-10 08:03:30
Delphi sqlite3 bindings, plus an OO layer for SQLITE