[Tutor] Python - Embedded mysql server

[Danny Yoo]

On Tue, 7 Feb 2006, Paul Kraus wrote:

> Anyone know where I can find information about how to embedd mysql into
> a python application. I need my hand held. I have worked with mysql a
> lot. I understand how to use python to manipulate a mysql database. What
> I want to know is how to embedded a database into my application.

Hi Paul,

You may want to look into SQLite and the pysqlite module instead:

    http://www.sqlite.org/
    http://pysqlite.org/

Unlike MySQL, SQLite is meant to be an embedded database.  Grab sqlite
from their web page; I think you'll be pleasantly surprised.


There was some discussion on the pysqlite mailing list about bundling up
pysqlite with a Python application.  According a message to their mailing
list from May 2005, it's not a problem:

    http://lists.initd.org/pipermail/pysqlite/2005-May/000058.html

but you should probably talk to the pysqlite folks to be sure how to make
this work.  More information on their mailing list is here:

    http://lists.initd.org/mailman/listinfo/pysqlite


Good luck!