Re: Querying Across Apps on Heroku
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.
Re: Querying Across Apps on Heroku
I'd consider providing an internal web service in your existing applications that your summary application can query using a REST API. Mat On Tue, Jan 26, 2010 at 12:09, 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.
Re: Querying Across Apps on Heroku
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.
Re: Querying Across Apps on Heroku
I'd probably go this route as well. ActiveResource in your summary application can make this pretty easy. On Tue, Jan 26, 2010 at 12:11 PM, Matthew A. Brown mat.a.br...@gmail.comwrote: I'd consider providing an internal web service in your existing applications that your summary application can query using a REST API. Mat On Tue, Jan 26, 2010 at 12:09, 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.comheroku%2bunsubscr...@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.comheroku%2bunsubscr...@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.comheroku%2bunsubscr...@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.