Multiple database connections with Python + Pylons + SQLAlchemy

Question

I'm trying to implement the proper architecture for multiple databases under Python + Pylons. I can't put everything in the config files since one of the database connections requires the connection info from a previous database connection (sharding).

What's the best way to implement such an infrastructure?

Have you checked out the sharding example in the SQLAlchemy source? sqlalchemy.org/trac/browser/sqlalchemy/trunk/examples/sharding/… — jamieb
– jamieb, Commented Feb 5, 2010 at 4:39

joeforker · Accepted Answer · 2010-02-08 19:27:04Z

1

Pylons's template configures the database in config/environment.py, probably with the engine_from_config method. It finds all the config settings with a particular prefix and passes them as keyword arguments to create_engine.

You can just replace that with a few calls to sqlalchemy.create_engine() with the per-engine url, and common username, and password from your config file.

answered Feb 8, 2010 at 19:27

joeforker

42.1k41 gold badges159 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple database connections with Python + Pylons + SQLAlchemy

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related