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: |
22ba9778cb05ed0476d263ecc2d240b1 |
| 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
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 "managed only" 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]