396
397
<li class="toctree-l1"><a class="reference internal" href="dialects/index.html">Dialects</a><ul>
397
<li class="toctree-l2"><a class="reference internal" href="dialects/drizzle.html">Drizzle</a><ul>
398
<li class="toctree-l3"><a class="reference internal" href="dialects/drizzle.html#connecting">Connecting</a></li>
399
<li class="toctree-l3"><a class="reference internal" href="dialects/drizzle.html#drizzle-data-types">Drizzle Data Types</a></li>
400
<li class="toctree-l3"><a class="reference internal" href="dialects/drizzle.html#module-sqlalchemy.dialects.drizzle.mysqldb">MySQL-Python Notes</a></li>
403
<li class="toctree-l2"><a class="reference internal" href="dialects/firebird.html">Firebird</a><ul>
404
<li class="toctree-l3"><a class="reference internal" href="dialects/firebird.html#dialects">Dialects</a></li>
405
<li class="toctree-l3"><a class="reference internal" href="dialects/firebird.html#locking-behavior">Locking Behavior</a></li>
406
<li class="toctree-l3"><a class="reference internal" href="dialects/firebird.html#returning-support">RETURNING support</a></li>
407
<li class="toctree-l3"><a class="reference internal" href="dialects/firebird.html#kinterbasdb">kinterbasdb</a></li>
410
<li class="toctree-l2"><a class="reference internal" href="dialects/informix.html">Informix</a><ul>
411
<li class="toctree-l3"><a class="reference internal" href="dialects/informix.html#module-sqlalchemy.dialects.informix.informixdb">informixdb Notes</a></li>
414
<li class="toctree-l2"><a class="reference internal" href="dialects/maxdb.html">MaxDB</a><ul>
415
<li class="toctree-l3"><a class="reference internal" href="dialects/maxdb.html#overview">Overview</a></li>
416
<li class="toctree-l3"><a class="reference internal" href="dialects/maxdb.html#connecting">Connecting</a></li>
417
<li class="toctree-l3"><a class="reference internal" href="dialects/maxdb.html#implementation-notes">Implementation Notes</a></li>
420
<li class="toctree-l2"><a class="reference internal" href="dialects/access.html">Microsoft Access</a></li>
421
<li class="toctree-l2"><a class="reference internal" href="dialects/mssql.html">Microsoft SQL Server</a><ul>
422
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#connecting">Connecting</a></li>
423
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#auto-increment-behavior">Auto Increment Behavior</a></li>
424
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#collation-support">Collation Support</a></li>
425
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#limit-offset-support">LIMIT/OFFSET Support</a></li>
426
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#nullability">Nullability</a></li>
427
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#date-time-handling">Date / Time Handling</a></li>
428
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#compatibility-levels">Compatibility Levels</a></li>
429
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#triggers">Triggers</a></li>
430
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#enabling-snapshot-isolation">Enabling Snapshot Isolation</a></li>
431
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#scalar-select-comparisons">Scalar Select Comparisons</a></li>
432
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#known-issues">Known Issues</a></li>
433
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#sql-server-data-types">SQL Server Data Types</a></li>
434
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#module-sqlalchemy.dialects.mssql.pyodbc">PyODBC</a></li>
435
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#module-sqlalchemy.dialects.mssql.mxodbc">mxODBC</a></li>
436
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#module-sqlalchemy.dialects.mssql.pymssql">pymssql</a></li>
437
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#module-sqlalchemy.dialects.mssql.zxjdbc">zxjdbc Notes</a></li>
438
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html#module-sqlalchemy.dialects.mssql.adodbapi">AdoDBAPI</a></li>
441
<li class="toctree-l2"><a class="reference internal" href="dialects/mysql.html">MySQL</a><ul>
442
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#supported-versions-and-features">Supported Versions and Features</a></li>
443
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#connecting">Connecting</a></li>
444
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#connection-timeouts">Connection Timeouts</a></li>
445
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#storage-engines">Storage Engines</a></li>
446
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#case-sensitivity-and-table-reflection">Case Sensitivity and Table Reflection</a></li>
447
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#transaction-isolation-level">Transaction Isolation Level</a></li>
448
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#keys">Keys</a></li>
449
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#sql-mode">SQL Mode</a></li>
450
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#mysql-sql-extensions">MySQL SQL Extensions</a></li>
451
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#rowcount-support">rowcount Support</a></li>
452
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#cast-support">CAST Support</a></li>
453
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#mysql-specific-index-options">MySQL Specific Index Options</a></li>
454
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#mysql-data-types">MySQL Data Types</a></li>
455
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.mysqldb">MySQL-Python Notes</a></li>
456
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.oursql">OurSQL Notes</a></li>
457
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.pymysql">pymysql Notes</a></li>
458
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.mysqlconnector">MySQL-Connector Notes</a></li>
459
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.gaerdbms">Google App Engine Notes</a></li>
460
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.pyodbc">pyodbc Notes</a></li>
461
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html#module-sqlalchemy.dialects.mysql.zxjdbc">zxjdbc Notes</a></li>
464
<li class="toctree-l2"><a class="reference internal" href="dialects/oracle.html">Oracle</a><ul>
465
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#connect-arguments">Connect Arguments</a></li>
466
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#auto-increment-behavior">Auto Increment Behavior</a></li>
467
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#identifier-casing">Identifier Casing</a></li>
468
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#unicode">Unicode</a></li>
469
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#limit-offset-support">LIMIT/OFFSET Support</a></li>
470
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#on-update-cascade">ON UPDATE CASCADE</a></li>
471
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#oracle-8-compatibility">Oracle 8 Compatibility</a></li>
472
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#synonym-dblink-reflection">Synonym/DBLINK Reflection</a></li>
473
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#oracle-data-types">Oracle Data Types</a></li>
474
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#module-sqlalchemy.dialects.oracle.cx_oracle">cx_Oracle Notes</a></li>
475
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html#module-sqlalchemy.dialects.oracle.zxjdbc">zxjdbc Notes</a></li>
478
<li class="toctree-l2"><a class="reference internal" href="dialects/postgresql.html">PostgreSQL</a><ul>
479
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#sequences-serial">Sequences/SERIAL</a></li>
480
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#transaction-isolation-level">Transaction Isolation Level</a></li>
481
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#remote-cross-schema-table-introspection">Remote / Cross-Schema Table Introspection</a></li>
482
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#insert-update-returning">INSERT/UPDATE...RETURNING</a></li>
483
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#postgresql-specific-index-options">Postgresql-Specific Index Options</a></li>
484
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#postgresql-data-types">PostgreSQL Data Types</a></li>
485
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.psycopg2">psycopg2 Notes</a></li>
486
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.pypostgresql">py-postgresql Notes</a></li>
487
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.pg8000">pg8000 Notes</a></li>
488
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html#module-sqlalchemy.dialects.postgresql.zxjdbc">zxjdbc Notes</a></li>
491
<li class="toctree-l2"><a class="reference internal" href="dialects/sqlite.html">SQLite</a><ul>
492
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#date-and-time-types">Date and Time Types</a></li>
493
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#auto-incrementing-behavior">Auto Incrementing Behavior</a></li>
494
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#transaction-isolation-level">Transaction Isolation Level</a></li>
495
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#database-locking-behavior-concurrency">Database Locking Behavior / Concurrency</a></li>
496
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#foreign-key-support">Foreign Key Support</a></li>
497
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#sqlite-data-types">SQLite Data Types</a></li>
498
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html#module-sqlalchemy.dialects.sqlite.pysqlite">Pysqlite</a></li>
501
<li class="toctree-l2"><a class="reference internal" href="dialects/sybase.html">Sybase</a><ul>
502
<li class="toctree-l3"><a class="reference internal" href="dialects/sybase.html#module-sqlalchemy.dialects.sybase.pysybase">python-sybase notes</a></li>
503
<li class="toctree-l3"><a class="reference internal" href="dialects/sybase.html#module-sqlalchemy.dialects.sybase.pyodbc">pyodbc notes</a></li>
504
<li class="toctree-l3"><a class="reference internal" href="dialects/sybase.html#module-sqlalchemy.dialects.sybase.mxodbc">mxodbc notes</a></li>
398
<li class="toctree-l2"><a class="reference internal" href="dialects/index.html#included-dialects">Included Dialects</a><ul>
399
<li class="toctree-l3"><a class="reference internal" href="dialects/drizzle.html">Drizzle</a></li>
400
<li class="toctree-l3"><a class="reference internal" href="dialects/firebird.html">Firebird</a></li>
401
<li class="toctree-l3"><a class="reference internal" href="dialects/informix.html">Informix</a></li>
402
<li class="toctree-l3"><a class="reference internal" href="dialects/mssql.html">Microsoft SQL Server</a></li>
403
<li class="toctree-l3"><a class="reference internal" href="dialects/mysql.html">MySQL</a></li>
404
<li class="toctree-l3"><a class="reference internal" href="dialects/oracle.html">Oracle</a></li>
405
<li class="toctree-l3"><a class="reference internal" href="dialects/postgresql.html">PostgreSQL</a></li>
406
<li class="toctree-l3"><a class="reference internal" href="dialects/sqlite.html">SQLite</a></li>
407
<li class="toctree-l3"><a class="reference internal" href="dialects/sybase.html">Sybase</a></li>
410
<li class="toctree-l2"><a class="reference internal" href="dialects/index.html#external-dialects">External Dialects</a></li>
413
<li class="toctree-l1"><a class="reference internal" href="changelog/index.html">Changes and Migration</a><ul>
414
<li class="toctree-l2"><a class="reference internal" href="changelog/index.html#current-migration-guide">Current Migration Guide</a><ul>
415
<li class="toctree-l3"><a class="reference internal" href="changelog/migration_08.html">What’s New in SQLAlchemy 0.8?</a></li>
418
<li class="toctree-l2"><a class="reference internal" href="changelog/index.html#change-logs">Change logs</a><ul>
419
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_08.html">0.8 Changelog</a></li>
420
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_07.html">0.7 Changelog</a></li>
421
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_06.html">0.6 Changelog</a></li>
422
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_05.html">0.5 Changelog</a></li>
423
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_04.html">0.4 Changelog</a></li>
424
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_03.html">0.3 Changelog</a></li>
425
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_02.html">0.2 Changelog</a></li>
426
<li class="toctree-l3"><a class="reference internal" href="changelog/changelog_01.html">0.1 Changelog</a></li>
429
<li class="toctree-l2"><a class="reference internal" href="changelog/index.html#older-migration-guides">Older Migration Guides</a><ul>
430
<li class="toctree-l3"><a class="reference internal" href="changelog/migration_07.html">What’s New in SQLAlchemy 0.7?</a></li>
431
<li class="toctree-l3"><a class="reference internal" href="changelog/migration_06.html">What’s New in SQLAlchemy 0.6?</a></li>
432
<li class="toctree-l3"><a class="reference internal" href="changelog/migration_05.html">What’s new in SQLAlchemy 0.5?</a></li>
433
<li class="toctree-l3"><a class="reference internal" href="changelog/migration_04.html">What’s new in SQLAlchemy 0.4?</a></li>