There are many ways to solve this problem. One way: Have each app provide a "search service" that the central app can call. This works if you don't mind having the data segmented by application.
Second way: If the results need to be ranked as a whole then you should put all of the data into a single database. On Tue, Jan 26, 2010 at 12:09 PM, Ken Collins <[email protected]> wrote: > > I've seen live DB to DB solutions fail many times before. But I'm willing to > admit I could have been doing it wrong :) My advice is to go with on DB and > partition the app. Others may have better advice. > > - Ken > > > On Jan 26, 2010, at 2:51 AM, Splashlin wrote: > >> I have multiple apps on Heroku that each have their own database. I >> want to build a new application that serves as a summary tool for all >> the data across the different databases. What is the best way to >> tackle this issue? >> >> Should I use one massive database on the new application and just >> point all my other apps to it or is there a way to move from database >> to database collecting the information? >> >> Thanks >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Heroku" 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/heroku?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Heroku" 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/heroku?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Heroku" 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/heroku?hl=en.
