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 <k...@metaskills.net> 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 her...@googlegroups.com. >> To unsubscribe from this group, send email to >> heroku+unsubscr...@googlegroups.com. >> 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 her...@googlegroups.com. > To unsubscribe from this group, send email to > heroku+unsubscr...@googlegroups.com. > 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 her...@googlegroups.com. To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/heroku?hl=en.