what's the optimal solution for connecting to different databases in zend

Question

Let's say I want to run same queries on two different databases in ZEND ? What's the best solution for this?

Keval Domadia · Accepted Answer · 2012-08-08 04:28:26Z

1

Let me introduce you to ORM.

You might want to download and use Doctrine2 , it hardly takes a day or 2 to learn it and using createQueryBuilder SQL scripting is just easier considering you know the logics to use JOIN, etc.

Try Doctrine CLI for beginning, once you are good to go, you might go manual with it!

Enjoy coding!

answered Aug 8, 2012 at 4:28

Keval Domadia

4,6931 gold badge39 silver badges65 bronze badges

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

Comments

Tomáš Fejfar · Accepted Answer · 2012-08-07 17:40:14Z

0

Create an adapter (proxy really) that will execute the queries on it's own internal adapters. But you need to take care of the situation where one of the calls fail or the results are not the same.

If your use-case is replication of the databases, I suggest using the ready made solution

answered Aug 7, 2012 at 17:40

Tomáš Fejfar

11.2k8 gold badges58 silver badges85 bronze badges

Collectives™ on Stack Overflow

what's the optimal solution for connecting to different databases in zend

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related