SQLite and CSharp - Revision history

Zelenka: /* SQLite Nuts and Bolts */

2010-09-11T07:14:30Z

SQLite Nuts and Bolts

← Older revision		Revision as of 07:14, 11 September 2010
Line 112:		Line 112:

	This has some strange effects in comparing data, especially of different types. All comparisons are done as strings. The SQLite API provides helper functions to convert from a internal representation of a datatype in C# to a string.		This has some strange effects in comparing data, especially of different types. All comparisons are done as strings. The SQLite API provides helper functions to convert from a internal representation of a datatype in C# to a string.
		+
		+	=external links=
		+	{{Teaser\|11.9.2010\|A SQLite Tutorial\|http://souptonuts.sourceforge.net/readme_sqlite_tutorial.html\|This tutorial explores the power of sqlite3, showing common commands, triggers, attach statement with the union operation, introduced in a way that allows multiple tables, in separate databases, to be combined as one virtual table, without the overhead of copying or moving data. Last but not least Mike Chirico shows the power of the sign function and the amazingly powerful trick of using this function in SQL select statements to solve complex queries with a single pass through the data, after making a brief mathematical case for how the sign function defines the absolute value and IF conditions.}}

	[[Category:CSharp]]		[[Category:CSharp]]

Henon: /* Example SQLite-DB access with LiteX.dll */

2009-06-13T22:03:12Z

Example SQLite-DB access with LiteX.dll

← Older revision		Revision as of 22:03, 13 June 2009
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	<div style="width:300px;float:right;margin:50px;padding:10px;border:1px solid;background:white;">		<div style="width:300px;float:right;margin:50px;padding:10px;border:1px solid;background:white;">
-	<h1>Git for C#</h1>	+	<h1>Git for .NET</h1>

-	<br>Check out <big><big><big>[[~~dotgit~~]]</big></big></big>, the most advanced open source implementation of git for .NET	+	<br>Check out <big><big><big>[[GitSharp\|Git#]]</big></big></big>, the most advanced open source implementation of git for .NET

	</div>		</div>

Henon: /* Example SQLite-DB access with LiteX.dll */

2009-06-10T18:15:06Z

Example SQLite-DB access with LiteX.dll

← Older revision		Revision as of 18:15, 10 June 2009
Line 3:		Line 3:
	<h1>Git for C#</h1>		<h1>Git for C#</h1>

-	<br>Check out <big><big><big>[[dotgit]]</big></big></big>, the most ~~'''~~advanced~~'''~~ open source implementation of git for .NET ~~in C#.~~	+	<br>Check out <big><big><big>[[dotgit]]</big></big></big>, the most advanced open source implementation of git for .NET

	</div>		</div>
Line 97:		Line 97:

	----		----
		+
	=SQLite Nuts and Bolts=		=SQLite Nuts and Bolts=
	==Query what's in the database==		==Query what's in the database==

Henon at 15:39, 10 June 2009

2009-06-10T15:39:51Z

← Older revision		Revision as of 15:39, 10 June 2009
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	<div style="width:300px;float:right;margin:50px;padding:10px;border:1px solid;background:white;">		<div style="width:300px;float:right;margin:50px;padding:10px;border:1px solid;background:white;">
-	<h1>Git ~~powered by~~ C#</h1>	+	<h1>Git for C#</h1>

	<br>Check out <big><big><big>[[dotgit]]</big></big></big>, the most '''advanced''' open source implementation of git for .NET in C#.		<br>Check out <big><big><big>[[dotgit]]</big></big></big>, the most '''advanced''' open source implementation of git for .NET in C#.

Henon at 15:19, 10 June 2009

2009-06-10T15:19:09Z

← Older revision		Revision as of 15:19, 10 June 2009
Line 1:		Line 1:
		+	__NOTOC__
		+	<div style="width:300px;float:right;margin:50px;padding:10px;border:1px solid;background:white;">
		+	<h1>Git powered by C#</h1>
		+
		+	<br>Check out <big><big><big>[[dotgit]]</big></big></big>, the most '''advanced''' open source implementation of git for .NET in C#.
		+
		+	</div>
		+
	The easiest way for an application to set up a database back-end is [http://www.sqlite.org SQLite]. Here is a small sample that creates a table, inserts some data and queries them back in C#. We use [http://roed.republika.pl/litex/index.html LiteX] which is a nice .Net wrapper for SQLite 3.		The easiest way for an application to set up a database back-end is [http://www.sqlite.org SQLite]. Here is a small sample that creates a table, inserts some data and queries them back in C#. We use [http://roed.republika.pl/litex/index.html LiteX] which is a nice .Net wrapper for SQLite 3.

Zelenka: /* SQLite Nuts and Bolts */

2008-07-19T15:39:08Z

SQLite Nuts and Bolts

← Older revision		Revision as of 15:39, 19 July 2008
Line 88:		Line 88:


		+	----
	=SQLite Nuts and Bolts=		=SQLite Nuts and Bolts=
	==Query what's in the database==		==Query what's in the database==
Line 99:		Line 100:

	==SQLite and Types==		==SQLite and Types==
-	SQLite is typeless.	+	SQLite is typeless. All data is stored internally as a null-terminated string. As a result of this typeless design you can omit most data type definitions from a CREATE TABLE statement without any difference in result. The only interpreted data type definition is INTEGER PRIMARY KEY, which really uses integers. Further you can insert strings to columns defined as integer and vice versa.
		+
		+	This has some strange effects in comparing data, especially of different types. All comparisons are done as strings. The SQLite API provides helper functions to convert from a internal representation of a datatype in C# to a string.

	[[Category:CSharp]]		[[Category:CSharp]]

Zelenka at 14:32, 19 July 2008

2008-07-19T14:32:50Z

← Older revision		Revision as of 14:32, 19 July 2008
Line 87:		Line 87:
	<span class="S10">}</span></span>		<span class="S10">}</span></span>

		+
		+	=SQLite Nuts and Bolts=
		+	==Query what's in the database==
		+	;using sqlite3.exe from command line: '.tables' delivers a list of all tables.
		+
		+	Every SQLite database stores their tables in a internal special table called '''SQLITE_MASTER'''. The SQLITE_MASTER table is read only, you can not use UPDATE, INSERT or DELETE commands with this table, and the table is automatically updated by CREATE TABLE, CREATE INDEX, DROP TABLE, and DROP INDEX commands. Temporary tables do not appear in the SQLITE_MASTER table. At this time there is no way to get a listing of temporary tables and indices. SQLITE_MASTER's schema looks like this:
		+	CREATE TABLE sqlite_master ( type TEXT, name TEXT, tbl_name TEXT, rootpage INTEGER, sql TEXT );
		+
		+	You can query '''SQLITE_MASTER''' table to get the tables and index names of all other tables and indexes this database contains. For tables, the type field will always be 'table' and the name field will be the name of the table. For indices, type is equal to 'index', name is the name of the index and tbl_name is the name of the table to which the index belongs. For both tables and indices, the sql field is the text of the original CREATE TABLE or CREATE INDEX statement that created the table or index. For automatically created indices (used to implement the PRIMARY KEY or UNIQUE constraints) the sql field is NULL.
		+	SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;
		+
		+	==SQLite and Types==
		+	SQLite is typeless.

	[[Category:CSharp]]		[[Category:CSharp]]

Henon: /* Alternative Way: ADO.NET and System.Data.SQLite.dll */

2007-12-13T23:43:57Z

Alternative Way: ADO.NET and System.Data.SQLite.dll

← Older revision		Revision as of 23:43, 13 December 2007
Line 41:		Line 41:
	<span class="S10">}</span></span>		<span class="S10">}</span></span>

-	== Alternative Way: ADO.NET and System.Data.SQLite~~.dll~~ ==	+	== Alternative Way: ADO.NET and [http://sqlite.phxsoftware.com/ System.Data.SQLite] ==
	<span><span class="S5">using</span><span class="S0"> </span>System<span class="S10">;</span><br />		<span><span class="S5">using</span><span class="S0"> </span>System<span class="S10">;</span><br />
	<span class="S5">using</span><span class="S0"> </span>System<span class="S10">.</span>Data<span class="S10">;</span><br />		<span class="S5">using</span><span class="S0"> </span>System<span class="S10">.</span>Data<span class="S10">;</span><br />

Henon: /* Alternative Way: System.Data.SQLite.dll */

2007-12-13T09:33:59Z

Alternative Way: System.Data.SQLite.dll

← Older revision		Revision as of 09:33, 13 December 2007
Line 41:		Line 41:
	<span class="S10">}</span></span>		<span class="S10">}</span></span>

-	== Alternative Way: System.Data.SQLite.dll ==	+	== Alternative Way: ADO.NET and System.Data.SQLite.dll ==
	<span><span class="S5">using</span><span class="S0"> </span>System<span class="S10">;</span><br />		<span><span class="S5">using</span><span class="S0"> </span>System<span class="S10">;</span><br />
	<span class="S5">using</span><span class="S0"> </span>System<span class="S10">.</span>Data<span class="S10">;</span><br />		<span class="S5">using</span><span class="S0"> </span>System<span class="S10">.</span>Data<span class="S10">;</span><br />

Henon: /* Another Way to do it Via ADO.NET */

2007-12-13T09:31:34Z

Another Way to do it Via ADO.NET

Show changes