Hi, If you want h2 dialect and are not afraid of programming there is an interesting project: https://pypi.python.org/pypi/JayDeBeApi/
Its seems there is already HSQLDB support, this is quite close to H2. Regards, -Nicolas Le samedi 25 avril 2015 11:35:24 UTC+2, DecebalICT a écrit : > > 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.
