H2 supports the PostgeSQL wire protocol, so you can use the PostgreSQL database driver. Although you will probably need to tweek the dialect description that SqlAlchemy needs. I would suggest looking at the Hibernate project, since they also use dialect definitions for different databases.
On Sat, Apr 25, 2015 at 11:35 AM, Cecil Westerhof <[email protected]> wrote: > 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. -- 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.
