search

anxiousmodernman / teamdash

A platform for developing, scheduling, and viewing reports
0 stars 0 forks source link

Investigate SQLAlchemy library for remote database connections #9

Closed anxiousmodernman closed 11 years ago

anxiousmodernman commented 11 years ago

Django provides an ORM to map objects to its own database, but for the external connections we've only used pyodbc or pymssql so far (whichever we can get working in any particular environment).

We should see if SQLAlchemy can even make the task of connecting easier.

anxiousmodernman commented 11 years ago

SQLAlchemy will let us abstract away from different MSSQL drivers since doing that is a huge pain. Check this out for MSSQL:

http://docs.sqlalchemy.org/en/rel_0_8/dialects/mssql.html#

And for working with SQLAlchemy database engines (how to make a connection) see:

http://docs.sqlalchemy.org/ru/latest/core/connections.html