Differences between revisions 1 and 2
Revision 1 as of 2003-02-06 19:12:23
Size: 1097
Editor: MikeRovner
Comment:
Revision 2 as of 2003-02-06 19:44:56
Size: 2355
Editor: MikeRovner
Comment:
Deletions are marked like this. Additions are marked like this.
Line 2: Line 2:
Things you connect to. Things you connect to. [[BR]]
Take a look at
http://www.python.org/topics/database/modules.html and
http://dmoz.org/Computers/Programming/Languages/Python/Modules/Databases_and_Persistence/.
Line 4: Line 8:
mysqldb module http://www.mysql.com/downloads/api-python.html
Line 5: Line 11:
pypgsql (http://pypgsql.sf.net/)
Line 6: Line 14:
 * dcOracle
 * cxOracle
Line 7: Line 18:
module developed by Dave Cole http://www.object-craft.com.au/projects/sybase/
Line 8: Line 21:
Line 17: Line 31:
 * xBase (http://linux.techass.com/projects/xdb/)  * xBase (http://linux.techass.com/projects/xdb/) - Python interface in plans
Line 33: Line 47:
== MetaKit ==
http://www.equi4.com/metakit/python.html

= Native Python Databases =
Line 34: Line 53:
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 ==
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.

DBMS interfaces

Things you connect to. BR 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

mysqldb module http://www.mysql.com/downloads/api-python.html

PostgreSQL

pypgsql (http://pypgsql.sf.net/)

Oracle

  • dcOracle
  • cxOracle

Sybase

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

MSSQL

BerkeleyDb

Datafiles interfaces

Things you open.

xBase

Which stands for .dbf files interface.BR .bdf 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

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

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.

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

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