System.Data.SQLite
Check-in [22ba9778cb]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Added a few embedded web pages.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 22ba9778cb05ed0476d263ecc2d240b133d5309a
User & Date: shaneh 2011-01-31 19:58:45
Context
2011-01-31
20:17
Updates to web pages. check-in: b4b0148f05 user: shaneh tags: trunk
19:58
Added a few embedded web pages. check-in: 22ba9778cb user: shaneh tags: trunk
04:23
Added setup and msi projects to main solution and modified to remove design time support. Need to get this building and tested and re-added. check-in: 1e42f1810d user: shaneh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Added www/features.wiki.

            1  +<title>Features</title>
            2  +
            3  +<ul>
            4  +  <li>
            5  +    Written from scratch on VS2008 specifically for ADO.NET 2.0, implementing all the
            6  +    base classes and features recently introduced in the framework, including automatic
            7  +    transaction enlistment.
            8  +  </li>
            9  +  <li>
           10  +    Supports the Full
           11  +    and Compact .NET Framework, and native C/C++ development.  100% binary
           12  +    compatible with the original sqlite3.dll.
           13  +  </li>
           14  +  <li>
           15  +    Full support for Mono via a &quot;managed only&quot; provider that runs against the
           16  +    official SQLite 3.6.1 or higher library.
           17  +  </li>
           18  +  <li>Full Entity Framework support (ADO.NET 3.5 SP1)</li>
           19  +  <li>
           20  +    On the Compact Framework, it is faster than SQL Server
           21  +    Mobile.  SQLite's installed size is a fraction of SQL Mobile's. It uses less memory at runtime, runs queries faster,
           22  +    and has a smaller database file size as well.
           23  +  </li>
           24  +  <li>
           25  +    Encrypted database support.  Encrypted databases are fully encrypted and
           26  +    support both binary and cleartext password types.
           27  +  </li>
           28  +  <li>
           29  +    Visual Studio 2005/2008 Design-Time Support, works with all versions of VS2005/2008,
           30  +    including all Express Editions of VS2005.  You can add a SQLite
           31  +    database to the Servers list, design queries with the Query Designer,
           32  +    drag-and-drop tables onto a Typed DataSet, etc.
           33  +  </li>
           34  +  <li>
           35  +    Full SQLite schema editing inside Visual Studio.
           36  +    You can create/edit tables, views, triggers, indexes, check constraints and foreign keys.
           37  +  </li>
           38  +  <li>
           39  +    Single file redistributable (except on Compact Framework).  The core sqlite3 codebase and the ADO.NET wrapper
           40  +    are combined into one multi-module assembly.
           41  +  </li>
           42  +  <li>
           43  +    Binaries included for Itanium, x64, x86 and ARM processors.
           44  +  </li>
           45  +  <li>
           46  +    DbProviderFactory support.
           47  +  </li>
           48  +  <li>
           49  +    Full support for ATTACH'ed databases.  Exposed as <i>Catalogs</i>
           50  +    in the schema.  When cloning a connection, all attached databases are
           51  +    automatically re-attached to the new connection.
           52  +  </li>
           53  +  <li>
           54  +    DbConnection.GetSchema(...) support includes <i>ReservedWords</i>, <i>MetaDataCollections</i>, <i>DataSourceInformation</i>,
           55  +    <i>DataTypes</i>, <i>Columns</i>, <i>Tables</i>, <i>Views</i>, <i>ViewColumns</i>, <i>Catalogs</i>, 
           56  +      <i>Indexes</i>, <i>IndexColumns</i>, <i>ForeignKeys</i> and <i>Triggers</i>.
           57  +  </li>
           58  +  <li>
           59  +    Enhanced DbDataReader.GetSchemaTable() functionality returns catalog, namespace
           60  +    and detailed schema information even for complex queries.
           61  +  </li>
           62  +  <li>
           63  +    Named and unnamed parameters.
           64  +  </li>
           65  +  <li>
           66  +    Full UTF-8 and UTF-16 support, each with optimized pipelines into the native
           67  +    database core.
           68  +  </li>
           69  +  <li>
           70  +    Multiple simultaneous DataReaders (one DataReader per Command however).
           71  +  </li>
           72  +  <li>
           73  +    Full support for user-defined scalar and aggregate functions, encapsulated into
           74  +    an easy-to-use base class in which only a couple of overrides are necessary to
           75  +    implement new SQL functions.
           76  +  </li>
           77  +  <li>
           78  +    Full support for user-defined collating sequences, every bit as simple to
           79  +    implement as user-defined functions and uses the same base class.
           80  +  </li>
           81  +  <li>
           82  +    Full source for the entire engine and wrapper.  No copyrights.
           83  +    Public Domain.  100% free for commercial and non-commercial use.
           84  +  </li>
           85  +</ul>

Added www/index.wiki.

            1  +<title>About</title>
            2  +
            3  +<div style="float:right">
            4  +  *  [./features.wiki | Features]
            5  +  *  [./news.wiki | News]
            6  +  *  [./support.wiki | Support]
            7  +  *  [./release.wiki | Release Procedures]
            8  +</div>
            9  +
           10  +<p>This is a fork of the popular ADO.NET 4.0 adaptor for <a href="http://www.sqlite.org">SQLite</a> known 
           11  +as System.Data.SQLite. The originator of System.Data.SQLite, <a href="mailto:robert@blackcastlesoft.com">Robert Simpson</a>, 
           12  +is aware of this fork, has expressed his approval, and has commit privileges on the new Fossil repository. 
           13  +The SQLite development team intends to maintain System.Data.SQLite moving forward. </p>
           14  +
           15  +<p>Historical versions, as well as the original support forums, may still be found
           16  +at <a href="http://sqlite.phxsoftware.com">http://sqlite.phxsoftware.com</a>, though
           17  +there have been no updates to this version since April of 2010.</p>
           18  +

Added www/news.wiki.

            1  +<title>News</title>
            2  +
            3  +<b>Version History</b>
            4  +
            5  +<p>
            6  +  <b>1.0.68.0 - February 2011</b>
            7  +</p>
            8  +<ul>
            9  +  <li>Code merge with SQLite 3.7.5</li>
           10  +  <li>Continuing work on supporting Visual Studio 2010</li>
           11  +</ul>
           12  +<p>
           13  +  <b>1.0.67.0 - January 3, 2011</b>
           14  +</p>
           15  +<ul>
           16  +  <li>Code merge with SQLite 3.7.4</li>
           17  +  <li>Continuing work on supporting Visual Studio 2010</li>
           18  +</ul>
           19  +

Added www/release.wiki.

            1  +<title>Release Procedures</title>
            2  +
            3  +<p>Follow these steps to build a new release of SQLite.NET.  Unless otherwise noted, all steps need to be done in the order specified.</p>
            4  +
            5  +<p>You will need a Visual Studio 2010 development environment for this build.</p>
            6  +
            7  +<ol type="A">
            8  +
            9  +  <li><b>Build runtime components</b>
           10  +
           11  +  <ol type="1">
           12  +
           13  +    <li>Build SQLite.NET.sln for Release/ia64
           14  +
           15  +    <li>Change to Release/x64 and rebuild
           16  +
           17  +    <li>Change to Release/x86 and rebuild
           18  +
           19  +  </ol>
           20  +
           21  +  <li><b>Build designer components</b>
           22  +
           23  +  <ol type="1">
           24  +
           25  +    <li>Build SQLite.Designer.sln for Release
           26  +
           27  +  </ol>
           28  +
           29  +  <li><b>Update documentation</b>
           30  +
           31  +  <ol type="1">
           32  +
           33  +    <li>Update the readme.htm file with the latest version changes
           34  +
           35  +    <li>Copy the version changes from readme.htm into doc\extra\version.html
           36  +
           37  +    <li>Update doc\extra\dbfactorysupport.html to reflect the latest version # of the DLL
           38  +
           39  +    <li>Copy over doc\extra\dbfactorysupport.html and version.html to my temp
           40  +    ndoc2 location where all my intermediate files are for the CHM
           41  +
           42  +    <li>Run HTML Help Workshop on the HHP project to get my CHM
           43  +
           44  +    <li>Copy the CHM file over to \doc
           45  +
           46  +  </ol>
           47  +
           48  +  <li><b>Build install and setup packages</b>
           49  +
           50  +  <ol type="1">
           51  +
           52  +    <li>Load up the \tools\setup\sqlite_setup.sln solution
           53  +
           54  +    <li>Change the "Version" property of the sqlite project (this is the MSI
           55  +    file project) to reflect the new version of the release.
           56  +
           57  +    <li>Edit the setup.rc file of the setup project, drilling down to the
           58  +    Version resource, and editing VS_VERSION_INFO, and populating the version
           59  +    info with the newest version #.
           60  +
           61  +    <li>Build both projects.
           62  +
           63  +    <li>Copy the and rename the resulting \tools\setup\release\setup.exe to
           64  +    SQLite-1.0.xx.0-setup.exe
           65  +
           66  +  </ol>
           67  +
           68  +</ol>

Added www/support.wiki.

            1  +<title>Support</title>
            2  +
            3  +<h3>Mailing Lists</h3>
            4  +
            5  +<p>SQLite has an active mailing list and support community, and users of this version of
            6  +System.Data.SQLite are encouraged to use these for support questions.</p>
            7  +
            8  +<p>Three separate mailing lists have been established to help support
            9  +SQLite:</p>
           10  +
           11  +<ul>
           12  +<li><a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">
           13  +sqlite-announce</a> - announcements of new releases or significant developments.</li>
           14  +<li><a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
           15  +sqlite-users</a> - general user discussion; most postings belong here.</li>
           16  +<li><a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev">
           17  +sqlite-dev</a> - developer conversations; for people who have or aspire to
           18  +have write permission on the SQLite source code repository.</li>
           19  +</ul>
           20  +
           21  +<p>
           22  +Most users of SQLite will want to join the
           23  +<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-announce">
           24  +sqlite-announce</a> list and many will want to join the
           25  +<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
           26  +sqlite-users</a> list.  The
           27  +<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-dev">
           28  +sqlite-dev</a> list is more specialized and appeals to a narrower audience.
           29  +Off-site archives of the
           30  +<a href="http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users">
           31  +sqlite-users</a> list are available at:
           32  +</p>
           33  +
           34  +<ul>
           35  +<li><a href="http://www.mail-archive.com/sqlite-users%40sqlite.org/">http://www.mail-archive.com/sqlite-users%40sqlite.org/</a><br>
           36  +<li><a href="http://marc.info/?l">http://marc.info/?l=sqlite-users&r=1&w=2</a><br>
           37  +<li><a href="http://news.gmane.org/gmane.comp.db.sqlite.general">http://news.gmane.org/gmane.comp.db.sqlite.general</a>
           38  +</ul>
           39  +
           40  +<h3>Direct E-Mail</h3>
           41  +
           42  +<p>Use the mailing list. Please do <b>not</b> send email directly to the authors of SQLite or System.Data.SQLite
           43  +unless:</p>
           44  +
           45  +<ul>
           46  +<li>You have or intend to acquire <a href="http://www.sqlite.org/draft/support.html">professional support contract</a>
           47  +<li>You are working on an open source project.
           48  +</ul>
           49  +
           50  +<p>You are welcomed to use SQLite in closed source, proprietary, and/or commercial projects and to 
           51  +ask questions about such use on the public mailing list. But please do not ask to receive free direct 
           52  +technical support. The software is free; direct technical support is not.</p>
           53  +
           54  +
           55  +              <h1>Documentation</h1>
           56  +
           57  +  *  [./release.wiki | Release Procedures]