Where can I learn more

8 views
Skip to first unread message

Paul Hemans

unread,
Jun 12, 2010, 8:27:51 PM6/12/10
to sqlalchemy
Where can I learn more about creating a dialect for SQLalchemy? I
could just copy one of the existing dialects, but I don't know what I
am looking for in what needs to be changed. I need a kind of high
level view of how it all fits together.
Essential SQLalchemy doesn't seem to cover it. Can anyone point me to
some info?

Thanks

Michael Bayer

unread,
Jun 12, 2010, 8:39:19 PM6/12/10
to sqlal...@googlegroups.com
Essential SQLAlchemy unfortunately is out of date in most areas and certainly with regards to dialect creation (as a note to anyone reading this, we are interested in authors for a new SQLAlchemy book, already signed to a major publisher, if anyone has 8 months of time to spare) .

someone had a good intro to how to write a dialect at SO:

http://stackoverflow.com/questions/1674841/how-do-i-write-an-external-dialect-for-sqlalchemy

Also some README's that are in the dist include:

README.unittests
lib/sqlalchemy/dialects/type_migration_guidelines.txt

and of course the ASCII art at:

http://www.sqlalchemy.org/docs/dbengine.html

A good, simple dialect to start with as a guide is the SQLite/pysqlite dialects in lib/sqlalchemy/dialects/sqlite. The Firebird dialect is quite simple too, and Postgresql is fairly digestible as well. The MySQL and MS-SQL dialects are a little crazy in some regards.

> --
> You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
> To post to this group, send email to sqlal...@googlegroups.com.
> To unsubscribe from this group, send email to sqlalchemy+...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
>

Reply all
Reply to author
Forward
0 new messages