From 017989ce8bca6e0540701fe0221fcfc556f7aba8 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Thu, 18 Oct 2012 18:24:15 -0400 Subject: - move out maxdb - begin consolidating docs for dialects to be more self contained - add a separate section for "external" dialects - not sure how we're going to go with this yet. --- lib/sqlalchemy/dialects/firebird/base.py | 19 ++++++++++++++----- 1 file changed, 14 insertions(+), 5 deletions(-) (limited to 'lib/sqlalchemy/dialects/firebird/base.py') diff --git a/lib/sqlalchemy/dialects/firebird/base.py b/lib/sqlalchemy/dialects/firebird/base.py index 4a83f2332..b99040038 100644 --- a/lib/sqlalchemy/dialects/firebird/base.py +++ b/lib/sqlalchemy/dialects/firebird/base.py @@ -7,10 +7,19 @@ """ Support for the Firebird database. -Connectivity is usually supplied via the kinterbasdb_ DBAPI module. +DBAPI Support +------------- -Dialects -~~~~~~~~ +The following dialect/driver options are available: + +``firebird://``- uses kinterbasdb_ + +``firebird+kinterbasdb://`` - uses kinterbasdb_ + +``firebird+fdb://`` - uses fdb_ + +Firebird Dialects +----------------- Firebird offers two distinct dialects_ (not to be confused with a SQLAlchemy ``Dialect``): @@ -27,7 +36,7 @@ support for dialect 1 is not well tested and probably has incompatibilities. Locking Behavior -~~~~~~~~~~~~~~~~ +---------------- Firebird locks tables aggressively. For this reason, a DROP TABLE may hang until other transactions are released. SQLAlchemy does its best @@ -47,7 +56,7 @@ The above use case can be alleviated by calling ``first()`` on the all remaining cursor/connection resources. RETURNING support -~~~~~~~~~~~~~~~~~ +----------------- Firebird 2.0 supports returning a result set from inserts, and 2.1 extends that to deletes and updates. This is generically exposed by -- cgit v1.2.1