ssk's posterous - Filed under 'sqlalchemy'

Database Engines — SQLAlchemy 0.6beta1 Documentation

by ssk

Downloads for each DBAPI at the time of this writing are as follows:

Supported Dialects - PostgreSQL: psycopg2 pg8000 - PostgreSQL on Jython: PostgreSQL JDBC Driver - SQLite: sqlite3 (included in Python 2.5 or greater) pysqlite - MySQL: MySQLdb (a.k.a. mysql-python) - MySQL on Jython: MySQL Connector/J JDBC driver - Oracle: cx_Oracle - Oracle on Jython: Oracle JDBC Driver - Firebird: kinterbasdb - MS-SQL, MSAccess: pyodbc (recommended) adodbapi pymssql - MS-SQL on Jython: jTDS JDBC Driver

Experimental Dialects - MSAccess: pyodbc - Informix: informixdb - Sybase: TODO - MAXDB: sapdb

Third Party Dialects - DB2/Informix IDS: ibm-db

via sqlalchemy.org

S3 書いてない

Filed under // sqlalchemy

Comments (0)

Frank Wierzbicki's Weblog: SQLAlchemy, MySQL, and Jython

from sqlalchemy import *

db = create_engine('mysql://username:password@localhost/mydb')
metadata = BoundMetaData(db)

users_table = Table('users', metadata, autoload=True)

s = users_table.select()
r = s.execute()
print r.fetchall()

via fwierzbicki.blogspot.com

ssk’s posterous

ssk’s posterous

sqlalchemy

Database Engines — SQLAlchemy 0.6beta1 Documentation

Frank Wierzbicki's Weblog: SQLAlchemy, MySQL, and Jython

My Other Sites

Tags

Get Updates