Re: accessing multiple dbs?
OK. Before I get flamed! I neglected to search THIS group before I posted. So, I see some chatter about being able to instansiate a second DB connector. Great. Now, how about where the best examples of that are? And what impact, if any, does this have on the rest of Django? My boss is starting to weaken too: "Maybe its not so bad having Django tables added" --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: accessing multiple dbs?
On Jul 15, 2:46 pm, "Richard E. Cooke" wrote: > OK. Before I get flamed! > > I neglected to search THIS group before I posted. > > So, I see some chatter about being able to instansiate a second DB > connector. Great. > > Now, how about where the best examples of that are? > > And what impact, if any, does this have on the rest of Django? > > My boss is starting to weaken too: "Maybe its not so bad having > Django tables added" Hi Richard, I have been having a go at this lately [1], and what I posted seems to work to an extent, but I am currently having some m2m field problems (not problems with foreign keys though), so what I posted may be flawed. Alex G is working on getting proper support added to django for google summer of code 2009, so hopefully it will be in a future release of django :-) Em [1] http://groups.google.com/group/django-users/browse_thread/thread/af3a77225594a28c --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: accessing multiple dbs?
On Jul 15, 4:19 pm, Emily Rodgers wrote: > On Jul 15, 2:46 pm, "Richard E. Cooke" wrote: > > > OK. Before I get flamed! > > > I neglected to search THIS group before I posted. > > > So, I see some chatter about being able to instansiate a second DB > > connector. Great. > > > Now, how about where the best examples of that are? > > > And what impact, if any, does this have on the rest of Django? > > > My boss is starting to weaken too: "Maybe its not so bad having > > Django tables added" > > Hi Richard, > > I have been having a go at this lately [1], and what I posted seems to > work to an extent, but I am currently having some m2m field problems > (not problems with foreign keys though), so what I posted may be > flawed. > > Alex G is working on getting proper support added to django for google > summer of code 2009, so hopefully it will be in a future release of > django :-) > > Em > > [1]http://groups.google.com/group/django-users/browse_thread/thread/af3a... I have figured out why the m2m field problems were happening (although not fixed it elegantly yet). When I figure out how to prevent the problem, I will reply to the other thread (where my suggested workaround it). Em --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: accessing multiple dbs?
On Wed, Jul 15, 2009 at 11:35 AM, Emily Rodgers < emily.kate.rodg...@googlemail.com> wrote: > > > > On Jul 15, 4:19 pm, Emily Rodgers > wrote: > > On Jul 15, 2:46 pm, "Richard E. Cooke" wrote: > > > > > OK. Before I get flamed! > > > > > I neglected to search THIS group before I posted. > > > > > So, I see some chatter about being able to instansiate a second DB > > > connector. Great. > > > > > Now, how about where the best examples of that are? > > > > > And what impact, if any, does this have on the rest of Django? > > > > > My boss is starting to weaken too: "Maybe its not so bad having > > > Django tables added" > > > > Hi Richard, > > > > I have been having a go at this lately [1], and what I posted seems to > > work to an extent, but I am currently having some m2m field problems > > (not problems with foreign keys though), so what I posted may be > > flawed. > > > > Alex G is working on getting proper support added to django for google > > summer of code 2009, so hopefully it will be in a future release of > > django :-) > > > > Em > > > > [1] > http://groups.google.com/group/django-users/browse_thread/thread/af3a... > > I have figured out why the m2m field problems were happening (although > not fixed it elegantly yet). When I figure out how to prevent the > problem, I will reply to the other thread (where my suggested > workaround it). > > Em > > > Unfortunately because of the way m2ms are done in Django right now working with any db besides the default is nearly impossible (they import a raw connection and do queries). I have a branch on github where I've rewritten m2ms to use an internal model so we don't have this problem. Alex -- "I disapprove of what you say, but I will defend to the death your right to say it." -- Voltaire "The people's good is the highest law." -- Cicero "Code can always be simpler than you think, but never as simple as you want" -- Me --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: accessing multiple dbs?
On Jul 15, 5:43 pm, Alex Gaynor wrote: > On Wed, Jul 15, 2009 at 11:35 AM, Emily Rodgers < > > > > emily.kate.rodg...@googlemail.com> wrote: > > > On Jul 15, 4:19 pm, Emily Rodgers > > wrote: > > > On Jul 15, 2:46 pm, "Richard E. Cooke" wrote: > > > > > OK. Before I get flamed! > > > > > I neglected to search THIS group before I posted. > > > > > So, I see some chatter about being able to instansiate a second DB > > > > connector. Great. > > > > > Now, how about where the best examples of that are? > > > > > And what impact, if any, does this have on the rest of Django? > > > > > My boss is starting to weaken too: "Maybe its not so bad having > > > > Django tables added" > > > > Hi Richard, > > > > I have been having a go at this lately [1], and what I posted seems to > > > work to an extent, but I am currently having some m2m field problems > > > (not problems with foreign keys though), so what I posted may be > > > flawed. > > > > Alex G is working on getting proper support added to django for google > > > summer of code 2009, so hopefully it will be in a future release of > > > django :-) > > > > Em > > > > [1] > >http://groups.google.com/group/django-users/browse_thread/thread/af3a... > > > I have figured out why the m2m field problems were happening (although > > not fixed it elegantly yet). When I figure out how to prevent the > > problem, I will reply to the other thread (where my suggested > > workaround it). > > > Em > > Unfortunately because of the way m2ms are done in Django right now working > with any db besides the default is nearly impossible (they import a raw > connection and do queries). I have a branch on github where I've rewritten > m2ms to use an internal model so we don't have this problem. > Alex > > -- > "I disapprove of what you say, but I will defend to the death your right to > say it." -- Voltaire > "The people's good is the highest law." -- Cicero > "Code can always be simpler than you think, but never as simple as you want" > -- Me I think for my system it isn't too much of a problem because I only need to add / delete m2m relationships from my main database (not secondary), but I will have to make sure I document it well! As I have said before, I am so happy that someone is working on this because it will make django so much more flexible. Thanks for your work Alex, it is much appreciated. Em :-) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---
Re: accessing multiple dbs?
Thanks for the replies! Happily I have managed to avoid the issue. We will just make one Django site per database. Using a web page to post all the different sites, thus making it "look" like its accessing multiple dbs.. Cheap shot I know, but I'm very lazy. Plus I figure by the time I really get forced to deal with this issue, GSOC will have helped out enough it won't be "hard" or tricky anymore By the way,when I was evaluating different packages to choose I was torn between Django and TurboGears2. It was the fact Django has GSOC working on the multi-DB issue that made me choose it. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~--~~~~--~~--~--~---