PyPyODBC 1.0.5 released. (DBI 2.0 ODBC module compatible with PyPy,IronPython and SQLAlchemy)

Discussion in 'Python' started by ½­ÎÄ, Mar 10, 2013.

  1. ½­ÎÄ

    ½­ÎÄ Guest

    Changes in Ver 1.0.5 (and 1.0.4, 1.0.3, 1.0.2, 1.0.1)

    - *Fix several bugs under Python 3.x*
    - *Add Mac / iODBC platform support*
    - *Improved ODBC ANSI / unicode mode support*


    Features

    - *One pure Python script, runs on CPython /
    IronPython<https://code.google.com/p/pypyodbc/wiki/Enable_SQLAlchemy_on_IronPython>
    / PyPy <http://pypy.org/> , Python 3.3 / 2.4 / 2.5 / 2.6 / 2.7 , Win /
    Linux / Mac , 32 / 64 bit*
    - *Almost totally same usage as pyodbc <http://code.google.com/p/pyodbc>* (
    can be seen as a re-implementation of pyodbc in pure Python )
    - *Simple - the whole module is implemented in a single python script
    with less than 3000
    lines<https://github.com/jiangwen365/pypyodbc/blob/master/pypyodbc.py>
    *
    - *Built-in functions<https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file>
    to
    create and compress Access MDB files on Windows*

    Simply try pypyodbc:

    import pypyodbc

    pypyodbc.win_create_mdb('D:\\database.mdb')

    connection_string = 'Driver={Microsoft Access Driver
    (*.mdb)};DBQ=D:\\database.mdb'

    connection = pypyodbc.connect(connection_string)

    SQL = 'CREATE TABLE saleout (id COUNTER PRIMARY KEY,product_name VARCHAR(25));'

    connection.cursor().execute(SQL).commit()

    ....

    Samples*A HelloWorld sample of python database
    programming<https://code.google.com/p/pypyodbc/wiki/A_HelloWorld_sample_to_access_mssql_with_python>
    **Create & Compact Access MDB
    database<https://code.google.com/p/pypyodbc/wiki/pypyodbc_for_access_mdb_file>
    *Install

    *Download the latest package<http://code.google.com/p/pypyodbc/downloads/list>
    * , unzip to a folder, *double click the setup.py file*, or run

    setup.py install

    Or if you have pip available:

    pip install pypyodbc

    Or get the latest pypyodbc.py script from
    *GitHub<https://github.com/jiangwen365/pypyodbc>
    * (Main Development site)
     
    ½­ÎÄ, Mar 10, 2013
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ½­ÎÄ
    Replies:
    0
    Views:
    292
    ½­ÎÄ
    Jun 15, 2012
  2. ½­ÎÄ
    Replies:
    0
    Views:
    286
    ½­ÎÄ
    Jul 4, 2012
  3. ½­ÎÄ
    Replies:
    0
    Views:
    203
    ½­ÎÄ
    Aug 25, 2012
  4. ½­ÎÄ
    Replies:
    0
    Views:
    199
    ½­ÎÄ
    Feb 3, 2013
  5. ½­ÎÄ
    Replies:
    0
    Views:
    215
    ½­ÎÄ
    Feb 21, 2013
Loading...

Share This Page