Differences between revisions 18 and 21 (spanning 3 versions)
Revision 18 as of 2003-09-19 00:59:46
Size: 4369
Editor: dsl081-228-065
Comment:
Revision 21 as of 2005-01-28 04:10:02
Size: 4530
Editor: dhcp024-208-248-242
Comment:
Deletions are marked like this. Additions are marked like this.
Line 59: Line 59:
== KirbyBase ==
http://www.netpromi.com/kirbybase.html
Line 67: Line 70:
 * http://www.fiby.at/dbfpy.html  * http://www.fiby.at/dbfpy.html - file missing (take it [http://starship.python.net/crew/jjkunce/python/dbfpy.tgz here])
Line 70: Line 73:
 * http://www.e-bachmann.dk/docs/xbase.htm  * http://www.e-bachmann.dk/docs/xbase.htm - dead link

TableOfContents

See also HigherLevelDatabaseProgramming

DBMS interfaces

Things you connect to.

Take a look at http://www.python.org/topics/database/modules.html and http://dmoz.org/Computers/Programming/Languages/Python/Modules/Databases_and_Persistence/.

MySQL

PostgreSQL

Oracle

See ["Oracle"] for details, there are two choices:

  • dcOracle
  • cx_Oracle

Sybase

module developed by Dave Cole http://www.object-craft.com.au/projects/sybase/

MSSQL

BerkeleyDb

ThinkSQL

Native Python Databases

gadfly

Gadfly is a simple relational database system implemented in Python based on the SQL Structured Query Language. Currently use C-extension module for speed. Pure Python version included. http://gadfly.sourceforge.net/

ZODB

http://www.zope.org/Wikis/ZODB Zope Object DB

shelve

A [http://www.python.org/doc/current/lib/module-shelve.html shelf] is a persistent, dictionary-like object. The difference with dbm databases is that the values (not the keys!) in a shelf can be essentially arbitrary Python objects -- anything that the [http://www.python.org/doc/current/lib/module-pickle.html pickle] module can handle. This includes most class instances, recursive data types, and objects containing lots of shared sub-objects. The keys are ordinary strings.

KirbyBase

http://www.netpromi.com/kirbybase.html

Datafiles interfaces

Things you open.

xBase

Which stands for .dbf files interface.BR .dbf files were produced by several old systems like dBase(II,III,IV), Fox(Base,Pro)

dbm

A family of old unix plain hash tables. Has varieties like dbm, ndbm, gdbm, dbmdb185.BR See [http://www.python.org/doc/current/lib/module-anydbm.html anydbm], [http://www.python.org/doc/current/lib/module-dumbdbm.html dumbdbm], [http://www.python.org/doc/current/lib/module-dbhash.html dbhash], [http://www.python.org/doc/current/lib/module-bsddb.html bsddb], [http://www.python.org/doc/current/lib/module-dbm.html dbm], [http://www.python.org/doc/current/lib/module-gdbm.html gdbm] in Python Standard Library.

MetaKit

http://www.equi4.com/metakit/python.html

SQLite

Actualy it's a full-fleged SQL server, but embeddable. No external SQL server required. Think of Gadfly, only faster. http://PySQLite.sf.net

XML Databases or Interfaces

Forest

[http://cvs.infrae.com/forest/ Forest] is a (native) XML database written in Python. It is intended to support fast queries of XML data.

4ODS

http://www.4suite.org/

Object-Relational Mappers

SQLObject

[http://sqlobject.org SQLObject] is an object-relational mapper. It allows you to translate RDBMS table rows into Python objects, and manipulate those objects to transparently manipulate the database.

Special file interface

DatabaseInterfaces (last edited 2020-12-09 09:29:13 by MarcAndreLemburg)

Unable to edit the page? See the FrontPage for instructions.