ADOdb for Python

ADOdb is a database abstraction library. ADOdb was originally developed for PHP, and ported to Python. The Python version implements a subset of the PHP version.

You might ask why Python needs a database abstraction library when Python provides the official DB API. Unfortunately the DB API does not encapsulate differences in the database implementations. For example, to select a limited number of rows, say 10 rows, you would have to use very different SQL for different databases:

  • MS SQL select top 10 from table
  • MySQL and PostgreSQL select * from table limit 10
  • Oracle select * from (select * from table) where rownum <= 10

    • These differences are handled by ADOdb (using SelectLimit), but not by the Python DB API. Other important database differences transparently handled by ADOdb include date-formating, associative arrays (records as dictionaries) and LOB-handling.

    Last updated 10 Feb, 2009


    User level: Intermediate

    User Rating:

    Homepage

    License(s) :

    BSD_3Clause

    Rate it!

     

    About

    Leadership
    Related Projects

    ADOdb

    Versions

    220

    User Community and Support

    http://phplens.com/lens/adodb/adodb-py-docs.htm#install

    General Resources

    Development

    Developer Resources
    Bug Tracking Resources
     

    Please send comments on these web pages to bug-directory@fsf.org, send other questions to info@fsf.org.

    Copyright © 2000 - 2009 Free Software Foundation, Inc., 51 Franklin Street, 5th Floor, Boston, MA 02110-1301, USA

    The copyright licensing notice below applies to this text. Any software described in this text has its own copyright notice and license, which can usually be found in the distribution itself.

    Permission is granted to copy, distribute, and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.