<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
	<id>https://wiki.dabo.leafe.com/index.php?action=history&amp;feed=atom&amp;title=SQLite</id>
	<title>SQLite - Revision history</title>
	<link rel="self" type="application/atom+xml" href="https://wiki.dabo.leafe.com/index.php?action=history&amp;feed=atom&amp;title=SQLite"/>
	<link rel="alternate" type="text/html" href="https://wiki.dabo.leafe.com/index.php?title=SQLite&amp;action=history"/>
	<updated>2026-11-21T09:32:49Z</updated>
	<subtitle>Revision history for this page on the wiki</subtitle>
	<generator>MediaWiki 1.39.12</generator>
	<entry>
		<id>https://wiki.dabo.leafe.com/index.php?title=SQLite&amp;diff=4060&amp;oldid=prev</id>
		<title>Ed: Created page with &quot;A simple, free SQL engine, completely self-contained. As far as I can tell, you instantiate it, read in a SQL file (consisting of plain SQL statements), and then query/update/...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.dabo.leafe.com/index.php?title=SQLite&amp;diff=4060&amp;oldid=prev"/>
		<updated>2020-05-11T17:23:21Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;A simple, free SQL engine, completely self-contained. As far as I can tell, you instantiate it, read in a SQL file (consisting of plain SQL statements), and then query/update/...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;A simple, free SQL engine, completely self-contained. As far as I can tell, you instantiate it, read in a SQL file (consisting of plain SQL statements), and then query/update/insert against that SQL, and then output it to a file again when you are done. I hope there is an easy way to just point it at a file and be done with it, however.&lt;br /&gt;
&lt;br /&gt;
See [http://www.hwaci.com/sw/sqlite/ the SQLite site] for more info.&lt;br /&gt;
&lt;br /&gt;
Installing on Linux:&lt;br /&gt;
* Download sqlite-2.8.15.tar.gz from http://www.sqlite.org/download.html (Note: I was unsuccessful getting PySQLite to build after installing sqlite-3.0.6. I think that it was a combination of things: sqlite3. instead of sqlite. mostly though.)&lt;br /&gt;
&lt;br /&gt;
* Execute the following shell commands:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;bash&amp;quot;&amp;gt;&lt;br /&gt;
tar -xzvf sqlite-2.8.15.tar.gz&lt;br /&gt;
cd sqlite&lt;br /&gt;
mkdir bld&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;br /&gt;
&lt;br /&gt;
* Edit Makefile-linux.gcc and uncomment line 35, and comment line 36. The section should now look like:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;bash&amp;quot;&amp;gt;&lt;br /&gt;
#    If you want the SQLite library to be safe for use within a&lt;br /&gt;
#    multi-threaded program, then define the following macro&lt;br /&gt;
#    appropriately:&lt;br /&gt;
#&lt;br /&gt;
THREADSAFE = -DTHREADSAFE=1&lt;br /&gt;
#THREADSAFE = -DTHREADSAFE=0&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;br /&gt;
&lt;br /&gt;
* Execute:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;bash&amp;quot;&amp;gt;&lt;br /&gt;
cd bld&lt;br /&gt;
../configure&lt;br /&gt;
make&lt;br /&gt;
sudo make install&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;br /&gt;
&lt;br /&gt;
* Download PySQLite from http://pysqlite.sf.net and follow along:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;bash&amp;quot;&amp;gt;&lt;br /&gt;
tar -xzvf pysqlite-0.5.1.tar.gz&lt;br /&gt;
cd sqlite&lt;br /&gt;
python2.3 setup.py build&lt;br /&gt;
sudo python2.3 setup.py install&lt;br /&gt;
sudo /sbin/ldconfig&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;br /&gt;
&lt;br /&gt;
* Start Python and make sure it imports:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;python&amp;quot;&amp;gt;&lt;br /&gt;
[pmcnett@sol pmcnett]$ python&lt;br /&gt;
Python 2.3.2 (#1, Oct  6 2003, 10:07:16)&lt;br /&gt;
[GCC 3.2.2 20030222 (Red Hat Linux 3.2.2-5)] on linux2&lt;br /&gt;
Type &amp;quot;help&amp;quot;, &amp;quot;copyright&amp;quot;, &amp;quot;credits&amp;quot; or &amp;quot;license&amp;quot; for more information.&lt;br /&gt;
&amp;gt;&amp;gt;&amp;gt; import sqlite&lt;br /&gt;
&amp;gt;&amp;gt;&amp;gt; dir(sqlite)&lt;br /&gt;
[BINARY, Binary, Connection, Cursor, DATE, DBAPITypeObject, DataError, DatabaseError, Error, INT, IntegrityError, InterfaceError, InternalError, NUMBER, NotSupportedError, OperationalError, PgResultSet, ProgrammingError, ROWID, STRING, TIME, TIMESTAMP, UNICODESTRING, Warning, __all__, __builtins__, __doc__, __file__, __name__, __path__, __revision__, _sqlite, apilevel, connect, decode, encode, main, paramstyle, threadsafety, version, &amp;#039;version_info&amp;#039;]&lt;br /&gt;
&amp;gt;&amp;gt;&amp;gt;&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;/div&gt;</summary>
		<author><name>Ed</name></author>
	</entry>
</feed>