I need to work with Python again and would like to use H2 there also. The
'best' way is to use SQLAlchemy. On the site H2 was not named. So I
inquired about that. The reply I got was:
SqlAlchemy needs 2 things for a database work:
1. A python database driver
2. A SqlAlchemy dialect (that tells SqlAlchemy how to write sql for the
driver)
So...
1. H2 doesn't seem to have any Python drivers or other support. I just
came across an old forum post that talked about possibly using Postgresql
client since they supported similar protocols, but that's about all I could
find.
2. There are a handful of posts and articles on writing custom
dialects. Several recent ones as well.
If you're just trying to handle the dialect, and their syntax is
reasonably similar to an existing dialect... I think you could do it alone.
If you have to write the general Python support as well though, that's
a bigger task.
Anyone a comment on this? I would like to make SQLAlchemy work with H2, but
at the moment do not know where to start and even if it is feasible. Could
the PostgreSQL client be used, or is it necessary to write a Python
database driver?
--
Cecil Westerhof
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
