Tuesday, June 24, 2008

Sqlite Wrappers - COM Wrappers / Visual Basic DLLs

SQLite Wrappers

COM Wrappers / Visual Basic DLLs
SQLitePlus Top selling COM Wrapper DLL and Database Explorer that extends the functionality of SQLite to add important features such as on-the-fly Encryption and Compression, .csv data import and export, stored Procedures, and an ADO-like object model. Also includes an excellent Database Explorer/Query Analyzer for visualizing and working with your Sqlite data. http://www.sqliteplus.com/

System.Data.SQLite is an enhanced version of the original SQLite database engine. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll). It has no linker dependency on the .NET runtime so it can be distributed independently of .NET, yet embedded in the binary is a complete ADO.NET 2.0 provider for full managed development.

dhSQLite, free ADO-like COM Wrapper. Current Version 1.2 (engine-version 3.4.0)... great performance, builtin encryption, optimized for disconnected Recordset-scenarios, super fast serialization/deserialization with 'UpdateBatch', Connection-, Recordset-, Field- and Command-Objects, DB-Schema-Obj-Model, builtin VB-Function-Set (DateDiff, DatePart, Format$, etc.), userdefinable Functions/Collations, FTS2-support, Overridden Like, Upper, Lower and NoCase means UTF8-awareness without ICU ... combinable with a free COM-RPC-Server for usage in real AppServer-scenarios in your LAN or over the Internet (due to builtin protocol-compression and -encryption).

SQLite3VB - Making SQLite VB Compatible. Teaches how to modify the SQLite C source code to make it VB-friendly. You end up with a non-COM DLL that you can call from a VB Classic project. [Sept 2007: The instructions will let you compile the project yourself (might require some common sense!) or download the compiled DLL - Currently 3.4.2]

AGS_SQLite SQLite wrapper 1.1.0 for Visual Basic is based on SQLite 2.8.13, and includes source + sample program. The AGS_SQLite.DLL file contains all of the functions that SQLite.DLL has, so all you need is AGS_SQLite.DLL. Geckoware was formerly known as AGSoftware.

SqLite2X : Free ActiveX wrapper with sources (2005-Nov-29 [mpot] sqlite 2.x only)

SleepSleep sqlite wrapper for vb6 - wrapper dll coded using fasm. Come with wrapper dll source code, a vb6 "sqlite browser" project files to show how to use the dll and a .bas file for you to attach on your project to use the dll instantly. (sqlite 2.x only)
(July 2007: dead link) qrfSQL2 Database Engine
(July 2007: dead link) SQLITEDB by Javier S. Bermudez
(July 2007: dead link) ADOSQLite VB6 wrapper requires AGS_SQLite.dll from ag-software (2005-Nov-29 [mpot] sqlite 2.x only)
(Apr, 2008: Dead link) Pivotal Solutions' non-COM DLL dynamically binds to SQLite DLL at runtime and so doesn't need recompiling everytime a new version of SQLite is released, ie. you'll need to distribute both PS' DLL and SQLite's DLL. (Apr, 2008: Dead link)
(Apr, 2008: No longer maintained) SQLiteDB is an ActiveX DLL built on top of SQLite (i.e. you only need to distribute SQLiteDb.dll) and is designed as an ADO replacement. Available in free and commercial versions. Although the site has not been updated recently, the developer does release frequent updates via the message board. The current SQLiteDB Professional build is based off of SQLite 3.4.0. The demo (built on SQLite 3.3.6) comes with plenty of examples and sample applications.

LiteX: COM DLL wrapper for SQLite3 (ATL). ("Release date: 16-04-2008, Used SQLite3 library version: 3.5.7.")
SQLite 3.x compatible
Source code provided (SVN repository: http://trac2.assembla.com/aIPblab5qr3zkdab7jnrAJ/browser)
Useful sample code
Works very well
Excellent wrapper for VBA
(Apr, 2008: Dead link) http://perso.wanadoo.fr/jveritecontribs/DAOSqlite.zip DAO like Sqlite Wrapper for VB6} (2005-Nov-29 [mpot] sqlite 2.x only) (2005-Nov-14, [Michael B. Johnson] No sample code on usage that I could see.)


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/
SQLite OLEDB Provider. http://CherryCitySoftware.com/ccs/Home/Default.aspx.
SQLite2007 Pro ODBC Driver, the first free ODBC Driver which have supported for accessing encrypted database that was build with SQLite2007 Pro Enterprise Manager. http://osenxpsuite.net/xpsuite/sqliteodbc2007.html


.NET Framework
ADO.NET 2.0/VS2005 Data Provider for SQLite Supports Full and Compact Framework, Visual Studio Design-Time Support.
.NET Mono ADO.NET provider for SQLite
myGeneration - a freeware template based code generation tool that supports SQLite and many other databases. With this tool, you can generate a middle tier for your database in practically any language
Updated! LightSpeed - .NET O/R Mapper with full support for SQLite. 100% .NET 2.0. Supports LINQ to SQLite - http://www.mindscape.co.nz/products/lightspeed/
(Apr, 2008: Deadware) ADO.NET Data Provider for SQLite (.NET Framework 1.1). Supports both SQLite 2 and 3, Full and Compact Framework.
(Apr, 2008: Deadware) qrfSQL2 Database Engine - an abstractions and modified version of SQLite optimized to run on Windows CE devices (Handhelds, PocketPC's, Smartphones). Runs on all Windows CE versions since WCE 2.10. Runs also on Win32, Cygwin and Linux operating systems. Provider a high-level (ADO style) API to quick create robust applications. Native API's for C, C++, Delphi, COM (any ActiveX language such Visual Basic, VBScript, ASP, .NET Framework, etc), Java and SuperWaba.
(Apr, 2008: Latest release June 1, 2006) SQLite-client for NEO: The .NET Entity Objects Framework (persistence-framework). The framework: http://neo.codehaus.org/ The client: http://www.rosa.nl/neo/
(Apr, 2008: "Looking for developers! Please email me!") New! : ManagedSQLite MIT-licensed open source sqlite (v2) wrapper for .NET; written in C#.
.NET wrapper for SQLite 2.8.13 Online Documentation DocumentationSqliteNet
(Apr, 2008: "Last modified: 16:57 29th December 2006") .NET C# wrapper for SQLite (usable with C#, Managed C++ & VB.NET)
newLISP

No comments: