ADDED www/features.wiki Index: www/features.wiki ================================================================== --- /dev/null +++ www/features.wiki @@ -0,0 +1,85 @@ +Features + +

+ Written from scratch on VS2008 specifically for ADO.NET 2.0, implementing all the + base classes and features recently introduced in the framework, including automatic + transaction enlistment. +
+ Supports the Full + and Compact .NET Framework, and native C/C++ development. 100% binary + compatible with the original sqlite3.dll. +
+ Full support for Mono via a "managed only" provider that runs against the + official SQLite 3.6.1 or higher library. +
Full Entity Framework support (ADO.NET 3.5 SP1)
+ On the Compact Framework, it is faster than SQL Server + Mobile. SQLite's installed size is a fraction of SQL Mobile's. It uses less memory at runtime, runs queries faster, + and has a smaller database file size as well. +
+ Encrypted database support. Encrypted databases are fully encrypted and + support both binary and cleartext password types. +
+ Visual Studio 2005/2008 Design-Time Support, works with all versions of VS2005/2008, + including all Express Editions of VS2005. You can add a SQLite + database to the Servers list, design queries with the Query Designer, + drag-and-drop tables onto a Typed DataSet, etc. +
+ Full SQLite schema editing inside Visual Studio. + You can create/edit tables, views, triggers, indexes, check constraints and foreign keys. +
+ Single file redistributable (except on Compact Framework). The core sqlite3 codebase and the ADO.NET wrapper + are combined into one multi-module assembly. +
+ Binaries included for Itanium, x64, x86 and ARM processors. +
+ DbProviderFactory support. +
+ Full support for ATTACH'ed databases. Exposed as Catalogs + in the schema. When cloning a connection, all attached databases are + automatically re-attached to the new connection. +
+ DbConnection.GetSchema(...) support includes ReservedWords, MetaDataCollections, DataSourceInformation, + DataTypes, Columns, Tables, Views, ViewColumns, Catalogs, + Indexes, IndexColumns, ForeignKeys and Triggers. +
+ Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace + and detailed schema information even for complex queries. +
+ Named and unnamed parameters. +
+ Full UTF-8 and UTF-16 support, each with optimized pipelines into the native + database core. +
+ Multiple simultaneous DataReaders (one DataReader per Command however). +
+ Full support for user-defined scalar and aggregate functions, encapsulated into + an easy-to-use base class in which only a couple of overrides are necessary to + implement new SQL functions. +
+ Full support for user-defined collating sequences, every bit as simple to + implement as user-defined functions and uses the same base class. +
+ Full source for the entire engine and wrapper. No copyrights. + Public Domain. 100% free for commercial and non-commercial use. +

ADDED www/index.wiki Index: www/index.wiki ================================================================== --- /dev/null +++ www/index.wiki @@ -0,0 +1,18 @@ +About + +

+ * [./features.wiki | Features] + * [./news.wiki | News] + * [./support.wiki | Support] + * [./release.wiki | Release Procedures] +

+ +

This is a fork of the popular ADO.NET 4.0 adaptor for SQLite known +as System.Data.SQLite. The originator of System.Data.SQLite, Robert Simpson, +is aware of this fork, has expressed his approval, and has commit privileges on the new Fossil repository. +The SQLite development team intends to maintain System.Data.SQLite moving forward.

+ +

Historical versions, as well as the original support forums, may still be found +at http://sqlite.phxsoftware.com, though +there have been no updates to this version since April of 2010.

+ ADDED www/news.wiki Index: www/news.wiki ================================================================== --- /dev/null +++ www/news.wiki @@ -0,0 +1,19 @@ +News + +Version History + +

+ 1.0.68.0 - February 2011 +

Code merge with SQLite 3.7.5
Continuing work on supporting Visual Studio 2010

+ 1.0.67.0 - January 3, 2011 +

Code merge with SQLite 3.7.4
Continuing work on supporting Visual Studio 2010

+ ADDED www/release.wiki Index: www/release.wiki ================================================================== --- /dev/null +++ www/release.wiki @@ -0,0 +1,68 @@ +Release Procedures + +

Follow these steps to build a new release of SQLite.NET. Unless otherwise noted, all steps need to be done in the order specified.

+ +

You will need a Visual Studio 2010 development environment for this build.

+ +

Build runtime components + +
1. Build SQLite.NET.sln for Release/ia64 + +
2. Change to Release/x64 and rebuild + +
3. Change to Release/x86 and rebuild + +
+ +
Build designer components + +
1. Build SQLite.Designer.sln for Release + +
+ +
Update documentation + +
1. Update the readme.htm file with the latest version changes + +
2. Copy the version changes from readme.htm into doc\extra\version.html + +
3. Update doc\extra\dbfactorysupport.html to reflect the latest version # of the DLL + +
4. Copy over doc\extra\dbfactorysupport.html and version.html to my temp + ndoc2 location where all my intermediate files are for the CHM + +
5. Run HTML Help Workshop on the HHP project to get my CHM + +
6. Copy the CHM file over to \doc + +
+ +
Build install and setup packages + +
1. Load up the \tools\setup\sqlite_setup.sln solution + +
2. Change the "Version" property of the sqlite project (this is the MSI + file project) to reflect the new version of the release. + +
3. Edit the setup.rc file of the setup project, drilling down to the + Version resource, and editing VS_VERSION_INFO, and populating the version + info with the newest version #. + +
4. Build both projects. + +
5. Copy the and rename the resulting \tools\setup\release\setup.exe to + SQLite-1.0.xx.0-setup.exe + +
+ +

ADDED www/support.wiki Index: www/support.wiki ================================================================== --- /dev/null +++ www/support.wiki @@ -0,0 +1,57 @@ +Support + +

Mailing Lists

+ +

SQLite has an active mailing list and support community, and users of this version of +System.Data.SQLite are encouraged to use these for support questions.

+ +

Three separate mailing lists have been established to help support +SQLite:

+ +

+sqlite-announce - announcements of new releases or significant developments.
+sqlite-users - general user discussion; most postings belong here.
+sqlite-dev - developer conversations; for people who have or aspire to +have write permission on the SQLite source code repository.

+ +

+Most users of SQLite will want to join the + +sqlite-announce list and many will want to join the + +sqlite-users list. The + +sqlite-dev list is more specialized and appeals to a narrower audience. +Off-site archives of the + +sqlite-users list are available at: +

+ +

Direct E-Mail

+ +

Use the mailing list. Please do not send email directly to the authors of SQLite or System.Data.SQLite +unless:

+ +

You have or intend to acquire professional support contract +
You are working on an open source project. +

+ +

You are welcomed to use SQLite in closed source, proprietary, and/or commercial projects and to +ask questions about such use on the public mailing list. But please do not ask to receive free direct +technical support. The software is free; direct technical support is not.

+ + +

Documentation

+ + * [./release.wiki | Release Procedures]