Hey all,
in order to support more databases than MySQL, e.g. sqlite and postgres,
we need to add in code for slurping in database schemas from those
databases. This is one of the cases where there is no SQL standard
and everyone does it completely differently -- sqlite has .schema, for
example.
I would like to propose incorporating code from SQLAlchemy (henceforth
'sa'),
http://www.sqlalchemy.org/
for this purpose. SQLAlchemy already supports a wide range of
databases, and it's under the MIT License so we can borrow without
restraint.
Specifically, we might want to borrow --
- the sa URL opening code
- the sa schema reading code
sa is a very nice, general object-relational mapper, so it might be
worth looking into it as a general solution for O/R mapping in pygr, too
-- why maintain our own code base? Performance would be the main
potential blocker; I don't know how fast sa is.
Comments or thoughts?
cheers,
--titus
--
C. Titus Brown, [email protected]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pygr-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/pygr-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
