sqlite - Sqlite Wrappers

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• Diff
• Text

If you know of a driver or wrapper for SQLite that is not listed below, please feel free to add it to the list. Please indicate SQLite version(s) supported.

Ada

• SQLite Base Package. http://gnade.sourceforge.net/#native

Appforge MobileVB

• DragonDB - MVB Edition: an SQL database engine and software development toolkit for creating Microsoft Pocket PC and Smartphone database applications using {link: http://www.appforge.com/products/enterprise/crossfire/index.html AppForge MobileVB} (version 3.2 or later). DragonDB is built upon SQLite3 so its databases are portable to all platforms and applications which support the SQLite3 database format.

C

• High level C API for SQLite 3.x with thread-safe Connection Pooling http://www.tildeslash.com/libzdb/
• SQLcrypt - SQLite3 + C API for transparent storage-level AES encryption - Windows and Mac OS X. Also Tcl, Python and Zope interfaces. Try before you buy. http://www.sqlcrypt.com

Ch --- an Embeddable C/C++ Interpreter for Script Computing

• Ch SQLite is a Ch binding to SQLite C library. Ch is an embeddable C/C++ interperter for scripting, shell programming, numerical computing, 2D/3D plotting and embedded scripting. With the Ch SQLite package, all C (or C++) programs using functions from the SQLite C library can readily run in Ch interpretively without compilation. It is an ideal solution for rapid prototyping, Web- based applications, and embedded scripting.

C++ Wrappers

• SharpLite, ado.net style wrappers. http://sourceforge.net/projects/sharplite/
• LiteSQL - C++ Object-relational persistence framework (supports SQLite3 as backend, too). http://litesql.sourceforge.net
• Sqlitedataset. Has functions for handling query results. Makefile included. http:// sqlitedataset.sourceforge.net/
• GQL Generic SQL Library supports PostgreSQL, MySQL and SQLite. Included in Debian Sarge. http:// gql.sourceforge.net/
• SQLite Plus, a minimalistic C++ wrapper for SQLite and SQLite3, inspired by the ADO.NET classes. Authors name is not mentioned in package. Written with MS Visual Studio. Depends on BOOST, if UNICODE is used it probably won't work on anything but Windows. Open Source zlib Licensed http://dev.int64.org/sqlite.html
• wxSQLite - wxWindows wrapper for SQLite 2.x. http://sourceforge.net/projects/wxsqlite
• wxSQLite3 - wxWindows wrapper for SQLite 3.x. Inspired by wxSQLite and CppSQLite, supporting most features of SQLite 3 including user-defined functions. http://wxcode.sourceforge.net/components/wxsqlite3/
• CppSQLite - a very thin C++ wrapper around the public domain SQLite database library. http://www.codeproject.com/database/CppSQLite.asp
• SQLite++ - non-free cross-platform C++ wrapper library for SQLite. http://www.sqliteplus.com ($$)
• Borland C++. Delphi components have been succesfully installed into Borland C++ Builder 5 and 6. http://sqlite.aducom.com
• Sword - cross-platform LGPL C++ lib with many features, including a SQLite C++ abstraction. http://www.erik-n.net/sword/ (404 not found) or http://savannah.nongnu.org/projects/sword/
• cmksql - C++ library. http://cmk.navorski.com/index.php?wiki=CmkSql
• KexiDB - KDE/Qt layer for accesing and creating databases, used by Kexi and other KDE applications. Contains SQLite v2 and v3 drivers. Also works on win32.
• Sqliteclass - A very simple C++ wrapper for sqlite.Public Domain. http://www.giannirossi.org/ index.php?mod=Download
• Sqlite wrapped - C++ wrapper for win32 and linux/unix (GNU GPL) http://www.alhem.net/project/sqlite/

Clipper

• Harbour wrapper for SQLite.
  A simple wrapper for Clipper, using the free [x]Harbour compiler. http://www.geocities.com/SiliconValley/Board/5300/sqlite/hbsqlite_en.htm

Common Lisp

• CLSQL
  a Common Lisp interface to SQL RDBMS which includes both functional and object oriented subsystems for data definition and manipulation as well as an integrated symbolic SQL syntax. A number of Common Lisp implementations and RDBMS (including SQLite) are supported.
• Lispworks bindings for SQLite at http://members.optusnet.com.au/apicard/

COM Wrappers / Visual Basic DLLs

• DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina. http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html (DEAD link!)
• Visual Basic 6 http://www.ag-software.com/Downloads/default.aspx?DownLoadID=5 (2005-Nov-29 [mpot] sqlite 2.x only)
• DLL (Not COM) - Dynamicly binds to SQLite DLL at runtime and so doesn't need recompiling everytime a new version of SQLite is released: http://www.pivotal-solutions.co.uk/downloads/company/pssqlite.zip (sqlite 2.x and 3.x) Source and DLL
• SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL). http://www.sqliteplus.com ($$)
• SQLiteDb (updated!) - fastest COM wrapper (written in ATL7), featuring on-the-fly database encryption, OLEDB Data Binding and an ADO-like object model. http://www.terrainformatica.com/ sqlitedb/ (free and commercial versions available) (2005-Nov-29 [mpot] sqlite 3.x compatible, lots of useful sample code, seems to work well)
• ADOSQLite VB6 wrapper; requires AGS_SQLite.dll from ag-software (above): http://ubt.ebunda.com (2005-Nov-29 [mpot] sqlite 2.x only)
• SqLite2X - Free ActiveX wrapper with sources http://dimzon541.narod.ru/sqlitex/ (2005-Nov-29 [mpot] sqlite 2.x only)
• DAO like Sqlite Wrapper for VB6 http://perso.wanadoo.fr/jveritecontribs/DAOSqlite.zip (2005-Nov-29 [mpot] sqlite 2.x only) (2005-Nov-14, [Michael B. Johnson] No sample code on usage that I could see.)
• LiteX: another COM DLL wrapper for SQLite3 (ATL) http://www.republika.pl/roed/litex (2005-Nov-29 [mpot] sqlite 3.x compatible, wrapper source code provided, useful sample code, works very well)

  It would be usefull if people could comment on the merrits of using a particular wrapper !

BlitzMax

• Pub.SqLite - Straightforward BlitzMax bindings of the SQLite3 API in the form of a module. Public domain. http://www.noelcower.com/mod/pub.sqlite.zip (Currently unavailable publicly, e-mail "cower @t noelcower dot com")

Drivers

• libdbi (C abstraction lib) driver for SQLite. http://libdbi-drivers.sourceforge.net
• ODBC driver for SQLite. http://www.ch-werner.de/sqliteodbc/.
• KexiDB driver for SQLite. Can be also used with KexiDB library for other apps than Kexi. http://webcvs.kde.org/cgi-bin/cvsweb.cgi/koffice/kexi/kexidb/drivers/sqlite/
• Borland DBExpress driver for SQLite. http://www.bcp-software.nl.

Delphi

• ZeosLIB: The ZeosLib is a set of database components for MySQL, PostgreSQL, Interbase, Firebird, MS SQL, Sybase, Oracle, DB/2, SQLite (2.8.x & 3.x - in cvs) for Delphi, Kylix, C++ Builder, Lazarus
• DISQLite3: The fully embedded, no-DLL SQLite3 solution for Delphi (D4, D5, D6, D7, D2005, D2005). Yes, it does compile with Delphi standard / personal and does NOT require sqlite3.dll: DISQLite3 provides the complete SQLite3 API, is regularly updated, very small, well documented, tightly integrated, and carefully optimized. As a result, DISQLite3 outperforms sqlite3.dll up to 50% for common operations. Free personal edition.
• *ASGSQLite*: Open source (NewBSD) Delphi (4..7, 2005, 2006) C++ (BCB5, 6) components for SQLite V2.8.x and V3.x.x. (TASQLiteDB, TASQLiteQuery, TASQLiteTable, TASQLiteUpdateSQL). No need for the BDE but Delphi standard edition is not supported. Support for static linking (obj files included, no dll needed), utf-8 and unidirectonal dataset (max speed). (updated 10 jan 2006) http://sqlite.aducom.com
• Delphi class for SQLite. http://www.torry.net/db/direct/db_directsql/tsqlite.zip
• LibSQL - Delphi/Kylix/Freepascal interface for SQLite, MySQL and ODBC32. http:// libsql.sourceforge.net/
• Fast and lean wrappers, browser, date/time and soundEx functions http://www.it77.de/sqlite/sqlite.htm
• Dataset descendant for SQLite: http://sourceforge.net/projects/sqlite4delphi
• Simple SQLite 3.0 wrapper, no TDataset or databinding, but fast and easy to use. Free for any purpose. http://www.itwriting.com/sqlitesimple.php

eyuyan (an OO programming language with a full-featured-IDE including UI-visual-designer and words-auto-complete, suporting platform-crossing-programme, easy to use, perfect in functions)

• Wrapper for SQLite: (SqliteDB.fne version:1.1) http://www.dywt.com.cn/help/zcksc.htm http://www.dywt.com.cn/

Ewe (Java clone, Waba descendant, nice PDA support)

• Wrapper for SQLite (alpha): http://ewe.e-masi.com/forum/viewtopic.php?p=968#968

Forth

• Reva 6.0 includes an interface to Sqlite 3.0 http://ronware.org/reva/

Fortran

• An example that shows how to call SQLite functions from Fortran. http://danial.org/sqlite/fortran/

Haskell

• HSQL supports SQLite 2 and 3.
• Takusen supports SQLite 3 only.

Java

• Java wrapper incl. JDBC driver for SQLite. http://www.ch-werner.de/javasqlite
• Java wrapper (around a SWIG interface): http://tk-software.home.comcast.net/
• Java wrapper - Dynamicly binds to SQLite DLL at runtime and so doesn't need recompiling everytime a new version of SQLite is released: http://www.pivotal-solutions.co.uk/downloads/company/pssqlite.zip (sqlite 3.x) Source and DLL

Javascript

• SpiderApe (a C++ framework for extending SpiderMonkey) includes an SQLite3 plugin providing Javascript-based access to the basic SQLite3 features. http://spiderape.sourceforge.net

Lua

• Lua wrapper for SQLite. http://domingo.dad-it.com/lua-sqlite.whtm
• Lua5 wrapper for SQLite. http://lua-users.org/wiki/LuaSqlite
• A multithread webserver with lua and sqlite works in windows and linux (it's working but it's still immature). http://domingo.dad-it.com/ws-lua-sqlite.whtm
• A more complete Lua 5 wrapper for SQLite. http://luaforge.net/projects/luasqlite
• A version of LuaSQLite3 (http://luaforge.net/projects/luasqlite) for PtokaX DC Hub can be found at http://www.thewildplace.dk/lua/pxsqlite3/
• Lua-Sqlite3: Sqlite 3 for Lua. Two layer architecture, multiple interfaces, coroutines, iterators and much more.

.NET Framework

• ADO.NET Data Provider for SQLite. (.NET Framework 1.1). Supports both SQLite 2 and 3, Full and Compact Framework. http://adodotnetsqlite.sourceforge.net/
• ADO.NET 2.0/VS2005 Data Provider for SQLite. Supports Full and Compact Framework, Visual Studio Design-Time Support. http://sqlite.phxsoftware.com
• .NET wrapper for SQLite. http://www.ag-software.com/?tabid=14. Online Documentation DocumentationSqliteNet
• .NET Mono ADO.NET provider for SQL Lite: http://www.go-mono.com/sqlite.html
• .NET C# wrapper for SQLite (usable with C#, Managed C++ & VB.NET) - http://www.phpguru.org/static/SQLite.NET.html

newLISP

• newLISP is a LISP based scripting language and has a module for interfacing with SQLite 2 and 3 for Win32 and Linux/BSD/OSX platforms. http://newlisp.org

Objective-C

• Objective-C (Cocoa) wrapper for SQLite. http://www.blackholemedia.com/code/
• STEnterprise: Another Cocoa wrapper for SQLite. Includes a framework and NSCoder subclass for object persistence.
• ObjC/Cocoa relational framework. No query strings/tables http://treehouseideas.com/datacrux/
• QuickLite is a Cocoa-based wrapper for SQLite 3. It's easy and powerful, object-oriented, offers full cursor access, datatype support (QLString, QLNumber, QLBoolean, QLDateTime, and QLContainer), distributed notifications, data file compaction, data integrity check, debugging facilities, includes introspection methods to access table names, column names, indexes, etc. Also includes utility methods to create and drop tables, add and remove columns, insert data, and more! Access to SQLite's last error ID and associated error string. BLOB support. and more! http://www.webbotech.com
• CoreData, Apples persistence framework for Cocoa and part of OS X 10.4 uses SQLite as its efficient storage backend. http://developer.apple.com/macosx/coredata.html

Objective Caml (OCaml)

• ocaml-sqlite wrapper for sqlite: http://neugierig.org/software/ocaml/sqlite/
• ocaml-dbi includes the sqlite wrapper as part of Database Independant framework for ocaml: http://www.merjis.com/developers/mod_caml/

Perl

• Perl-DBI driver for SQLite (DBD::SQLite). http://search.cpan.org/perldoc?DBD::SQLite
• Perl wrapper around a SWIG generated interface. Provides a nice class oriented interface. http://tk-software.home.comcast.net/

PHP

• SQLite is bundled with PHP 5. http://www.php.net
• PHP 4 extension for SQLite. (Official) http://pecl.php.net/package/SQLite
• PEAR DB contains an interface for SQLite. http://pear.php.net/package/DB
• PHP driver for SQLite 3.XX (Unofficial). Also includes a PEAR DB driver class http://php-sqlite3.sourceforge.net
• PHP driver for SQLite. (Unofficial) http://freshmeat.net/projects/sqlite-php (no longer being worked on see above)
• ADOdb database abstraction layer for PHP 4/5 is supporting SQLite. http://adodb.sourceforge.net/
• Creole - Common Database API for ZE2 supports SQLite. http://creole.phpdb.org/
• SQLiteDB: A simple wrapper class that supports ALTER TABLE statements.

Pike

• Pike SQLite glue (pike -x monger --install Sql.Provider.SQLite)

Python

• Python driver for SQLite. http://pysqlite.org/. This provides a DBAPI compliant wrapper for SQLite 2 or 3 and hides some of SQLite's idiosyncrasies.
• SQLObject Python object-relational mapper. http://sqlobject.org
• Modeling - Object-Relational Bridge for Python. http://modeling.sourceforge.net/
• Another Python SQLite Wrapper. http://www.rogerbinns.com/apsw.html. APSW is not DBAPI compliant, and instead lets you do everything you can do from C, but in Python.
• ZSQLiteDA, for using sqlite from Zope. http://www.zope.org/Members/nakagami/ZSQLiteDA
• Django object-relational mapper. http://djangoproject.org

REALbasic

• SQLite is the database engine for the REAL SQL Database, which is built into the currently shipping version of REALbasic. http://realsoftware.com

Revolution

• altSQLite Revolution Database Add-On: http://www.altuit.com/webs/altuit2/altSQLiteCover/ default.htm

Ruby

• Ruby DBI (dbd_sqlite). This needs some work (see mailing list!). http://ruby-dbi.sourceforge.net
• Ruby wrapper for SQLite. http://domingo.dad-it.com/ruby-sqlite.whtm
• Ruby wrapper for SQLite (BSD license). http://rubyforge.org/projects/sqlite-ruby
• Ruby wrapper for SQLite3 (BSD license). http://rubyforge.org/projects/sqlite-ruby

Scheme

• For PLT Scheme: http://jay.makeoutcity.com/#sqlite
• For the Chicken Scheme-to-C compiler: http://www.call-with-current-continuation.org/eggs/ sqlite.html

SmallTalk

• Squeak Smalltalk wrapper for SQLite. http://map1.squeakfoundation.org/sm/packagebyname/sqlite
• VisualWorks Smalltalk: http://www.gjdv.at/v2/en/oss/vwsqlite.xhtml

Tcl/Tk

• A Tcl interface is included with the SQLite core.

Other

• (Small)Eiffel wrapper for SQLite. http://elj.sourceforge.net/
• Euphoria wrapper: Updated : http://members.aol.com/chriscrylex/EUSQLite/eusql.html (http://www.rapideuphoria.com for info on Euphoria)
• Io wrapper for SQLite. http://www.iolanguage.com/Source/Io/IoServer/SQLite/_docs/SQLite.html
• KOL (Key Objects Library by Vladimir Kladov : http://xcl.cjb.net) wrapper for SQLite(beta 1.1). http://members.fortunecity.com/boguslaw/KOLSQLite.zip
• Qt. The Opie Project ( http://opie.handhelds.org ), generic Qt wrapped sqlite at http://cvs.handhelds.org/cgi-bin/viewcvs.cgi/opie/libsql/
• R: RSQLite package conforming to the R DBI standard. http://cran.us.r-project.org/src/contrib/PACKAGES.html#RSQLite
• REXX wrapper for SQLite. http://rexxsql.sf.net
• PureBasic SQLite Userlibrary: http://www.purearea.net/pb/english/userlibs.php
• PowerBasic - Source code by Nathan Evans http://www.powerbasic.com/support/forums/Forum7/HTML/001853.html
• PowerBasic - Source code by Don Dickinson sqlite version 3: http://www.greatwebdivide.com/files/pbsqlite3.zip sqlite version 2: http://www.greatwebdivide.com/files/pbsqlite.zip
• uSQLD - A small networked database server based on sqlite. http://gpe.handhelds.org/projects/GPE-usqld.shtml (acutal download file IS MISSING!!! DEAD LINK!)
• SQlite4WD - Native driver class for Windev 7.5 / 8 (www.pcsoft.fr). http://www.SQLManagerX.com
• SQLLite.DLL - Interface to allow Dark Basic Professional to use SQLite (www.codingarea.co.uk). http://www.codingarea.co.uk/
• REBOL wrapper for SQLite: http://www.rebol.org/cgi-bin/cgiwrap/rebol/view-script.r? script=sqlite3.r
• REBOL Port based interface : http://www.rebol.org/cgi-bin/cgiwrap/rebol/view-script.r? script=sqlite3-protocol.r
• SuperCard Bundle External for SQLite: http://tom.lightheadsw.com/supercard/
• Assembly language (Fresh/FASM); Pretty complete set of include files with SQLite definitions and imports for assembly language programming are part of the latest Fresh version: {link: http:// fresh.flatassembler.net Fresh main site, section "downloads"} ; Also, simple example project is included in the package.

Attachments:

• dblite.zip 12906 bytes added by anonymous on 2006-Mar-11 04:49:18 UTC.
  DBLite - a C++ template wrapper for win32. depend on BOOST MPL. support VC6, VC7.1