<?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=PySQLite</id>
	<title>PySQLite - 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=PySQLite"/>
	<link rel="alternate" type="text/html" href="https://wiki.dabo.leafe.com/index.php?title=PySQLite&amp;action=history"/>
	<updated>2026-11-21T03:06:32Z</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=PySQLite&amp;diff=4059&amp;oldid=prev</id>
		<title>Ed: Created page with &quot;&#039;&#039;&#039;PySQLite&#039;&#039;&#039; is a python wrapper for the SQLite database. SQLite is a small, embeddable, FAST database library written in C. It is somewhere around 20k lines of code, an...&quot;</title>
		<link rel="alternate" type="text/html" href="https://wiki.dabo.leafe.com/index.php?title=PySQLite&amp;diff=4059&amp;oldid=prev"/>
		<updated>2020-05-11T17:00:37Z</updated>

		<summary type="html">&lt;p&gt;Created page with &amp;quot;&amp;#039;&amp;#039;&amp;#039;PySQLite&amp;#039;&amp;#039;&amp;#039; is a python wrapper for the &lt;a href=&quot;/index.php?title=SQLite&quot; title=&quot;SQLite&quot;&gt;SQLite&lt;/a&gt; database. SQLite is a small, embeddable, FAST database library written in C. It is somewhere around 20k lines of code, an...&amp;quot;&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;&amp;#039;&amp;#039;&amp;#039;PySQLite&amp;#039;&amp;#039;&amp;#039; is a python wrapper for the [[SQLite]] database. SQLite is a small, embeddable, FAST database library written in C. It is somewhere around 20k lines of code, and in the public domain. See the [[SQLite]] page for more information.&lt;br /&gt;
&lt;br /&gt;
Typical usage of SQLite might be:&lt;br /&gt;
On a webserver where you would like a database, but not the hassle of all the functionality offered by more advanced dB&amp;#039;s such as MySQL or PostgreSQL.&lt;br /&gt;
Embedded within your application. If you simply want a datastore that is more advanced than text based access and don&amp;#039;t want to &amp;quot;roll your own&amp;quot; solution.&lt;br /&gt;
Other ideas?&lt;br /&gt;
&lt;br /&gt;
Home pages:&lt;br /&gt;
[http://www.sqlite.org SQLite] and [http://pysqlite.org PySQLite]&lt;br /&gt;
&lt;br /&gt;
To create or modify an instance of a database, simply:&lt;br /&gt;
&lt;br /&gt;
&amp;lt;syntaxhighlight lang=&amp;quot;python&amp;quot;&amp;gt;&lt;br /&gt;
import sqlite&lt;br /&gt;
# if the dB doesnt exist, it will be created for you:&lt;br /&gt;
db = sqlite.connect(&amp;#039;somedb&amp;#039;)&lt;br /&gt;
curs = db.cursor()&lt;br /&gt;
curs.execute(&amp;#039;SELECT * FROM some_table&amp;#039;)&lt;br /&gt;
curs.execute(&amp;#039;INSERT INTO some_table VALUES (some_value, another_value, etc)&amp;#039;)&lt;br /&gt;
db.commit() # Note, without this commit the previous query sits in limbo&lt;br /&gt;
db.close()&lt;br /&gt;
&amp;lt;/syntaxhighlight&amp;gt;&lt;br /&gt;
&lt;br /&gt;
I highly recommend checking the tools out - they&amp;#039;re easy to use, yet extremely powerful. Good luck!&lt;/div&gt;</summary>
		<author><name>Ed</name></author>
	</entry>
</feed>