[Tutor] Database acces vs XML [documentation on Database API 2.0]

[Danny Yoo]

> I had a look to the pysqlite module, and seems to better fit my needs.In
> the docs they say sqlite "fully comply with the Python Database API
> v.2.0 specification" and give no further details about pysqlite use. I
> had a look into the python library reference and there seems to be no
> "standard" database module. All those different database modules are
> quite confusing! Is there any tutorial for using databases with the
> Database API specification? Or describing this specification?

Hi Guillermo,


Yes, there's documentation on the Database API 2.0, starting from the
'Database' topic guide:

    http://python.org/topics/database/

We can find the API here:

    http://python.org/peps/pep-0249.html

(It might be nice for the Sqlite folks to directly hyperlink the Database
API link into their documentation.  That should reduce the confusion for
anyone else who's using Sqlite for the first time.)



Examples, examples... ok, Linux Journal has written an article that shows
how to use the API:

    http://www.linuxjournal.com/article.php?sid=2605

There's another example from the Devshed folks:

    http://www.devshed.com/Server_Side/Python/PythonMySQL/

We can also talk about examples on the Tutor list, if you'd like.



If you have some really hefty database questions, there's a dedicated
Special Interest Group for Python and databases:

    http://mail.python.org/mailman/listinfo/db-sig