On Jul 3, 6:36 pm, Emily Rodgers <emily.kate.rodg...@googlemail.com>
wrote:
> 2009/7/3 Alex Gaynor <alex.gay...@gmail.com>:
>
>
>
>
>
> > On Fri, Jul 3, 2009 at 12:25 PM, Emily Rodgers
> > <emily.kate.rodg...@googlemail.com> wrote:
>
> >> On Jul 3, 3:29 pm, Emily Rodgers <emily.kate.rodg...@googlemail.com>
> >> wrote:
> >> > On Jul 1, 3:44 pm, Alex Gaynor <alex.gay...@gmail.com> wrote:
>
> >> > > On Wed, Jul 1, 2009 at 9:39 AM, Emily Rodgers <
>
> >> > > emily.kate.rodg...@googlemail.com> wrote:
>
> >> > > > On Jul 1, 3:22 pm, Alex Gaynor <alex.gay...@gmail.com> wrote:
> >> > > > > On Wed, Jul 1, 2009 at 9:16 AM, Emily Rodgers <
>
> >> > > > > emily.kate.rodg...@googlemail.com> wrote:
>
> >> > > > > > On Jun 25, 6:45 pm, Alex Gaynor <alex.gay...@gmail.com> wrote:
> >> > > > > > > On Thu, Jun 25, 2009 at 10:24 AM, Tim Chase
> >> > > > > > > <django.us...@tim.thechases.com>wrote:
> >> > > > > > > > > Right now, Django doesn't seem to support the multiple
> >> > > > > > > > > databases on the same server or different servers.  Will
> >> > > > > > > > > that
> >> > > > > > > > > feature be available out of the box for future releases?
>
> >> > > > > > > > You may want to eavesdrop on the Django Developers group (as
> >> > > > > > > > opposed to this Django Users group) where Alex Gaynor has
> >> > > > > > > > been
> >> > > > > > > > posting updates on his GSoC project to add multi-DB support
> >> > > > > > > > to
> >> > > > > > > > Django[1].  There are several aspects to multi-DB support[2]
> >> > > > > > > > but
> >> > > > > > > > I believe he's addressing some of the more common use-cases.
> >> > > > > > > >  You
> >> > > > > > > > can even follow along if you like to live dangerously as I
> >> > > > > > > > believe he's got a public repository for his code on GitHub.
>
> >> > > > > > > > -tim
>
> >> > > > > > > > [1]
>
> >> > > > >http://groups.google.com/group/django-developers/search?group=django-.
> >> > > > > > ..
>
> >> > > > > > > > [2]
>
> >> > > > >http://groups.google.com/group/django-users/browse_thread/thread/6630.
> >> > > > > > ..
> >> > > > > > > > for my posted concerns
>
> >> > > > > > > I have both a public code repository on github at
> >> > > > > > github.com/alex/django/ as
> >> > > > > > > well as a branch in Django's SVN at branches/soc2009/multidb.
> >> > > > > > >  The
> >> > > > best
> >> > > > > > > place to find out about the work is the django-developers
> >> > > > > > > list, where
> >> > > > I
> >> > > > > > have
> >> > > > > > > sent any number of emails discussing both the overall design,
> >> > > > > > > as well
> >> > > > as
> >> > > > > > the
> >> > > > > > > status.
>
> >> > > > > > > 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
>
> >> > > > > > Hi,
>
> >> > > > > > Alex - do you know roughly when this is likely to be
> >> > > > > > incorporated into
> >> > > > > > django? I am working on a project that is going to need to
> >> > > > > > connect to
> >> > > > > > multiple databases (I am just planning / designing at the
> >> > > > > > moment), and
> >> > > > > > I want to know whether I should start investigating how to do
> >> > > > > > this
> >> > > > > > using django 1.0.2 or if that would be a waste of my time.
>
> >> > > > > > If it is going to be a while, where would you suggest I start
> >> > > > > > looking
> >> > > > > > if I need to understand how to do it with django 1.0.2?
>
> >> > > > > > Cheers,
> >> > > > > > Em
>
> >> > > > > It will, at a minimum not occur until the end of the summer.
> >> > > > >  Beyond that
> >> > > > I
> >> > > > > can't make any really useful guesses, other than to say that the
> >> > > > aggregation
> >> > > > > GSOC project from last summer
> >> > > > > ultimately made it's way into django trunk in January, about 3-4
> >> > > > > months
> >> > > > > after the official end of GSOC.  That may or may not ultimately be
> >> > > > > representative of how long it will take multi-db to make it's way
> >> > > > > back
> >> > > > into
> >> > > > > Django.  A lot of it probably depends on how the 1.2/1.3 releases
> >> > > > > are
> >> > > > > scheduled.  For example is 1.2 ends up being a smaller release
> >> > > > > that's put
> >> > > > > out in Novemberish I wouldn't expect multi-db to be considered for
> >> > > > > trunk
> >> > > > > until 1.3.  Like I said all of that's rather speculative :)
>
> >> > > > > 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
>
> >> > > > Thanks Alex. I don't think I can wait that long so it looks like I
> >> > > > am
> >> > > > going to have to get my hands dirty!
>
> >> > > > Is this [1] a sensible starting point?
>
> >> > > > [1]
>
> >> > > > >http://www.mechanicalgirl.com/view/multiple-database-connection-a-sim...
>
> >> > > That blog post is a good source of information, as
> >> > > is:http://www.eflorenzano.com/blog/post/easy-multi-database-support-djan...
> >> > > unfortunately appears to be down right now).
>
> >> > Hi,
>
> >> > I have tried implementing this, but I am running into the problems
> >> > that others have about too many idle MySQLconnections. Is there an
> >> > easy way to get around this?
>
> >> OK now I am running into even more problems :(
>
> >> I am probably being dumb, but I assumed there were only problems with
> >> foreign keys accross the different databases, but I am finding that I
> >> can't follow foreign keys from the secondary database to another table
> >> in the secondary database (even though both tables have the
> >> MultiDbManager defined for them). It just assumes all foreign keys are
> >> for tables in my primary database :(
>
> >> I may have to set up another script on another django project with a
> >> cli to get the data I want since I am only reading from the second db
> >> (it just seems to wrong!!). Or maybe just use mysqldb?
>
> > Does your multidbmanagerhave use_for_related_fields = True on it?
>
> Ah - no. Thanks for spotting that!
>
> <trying it out>
>
> Yay - it worked. Thanks Alex :-)
>
> Still stuck on the too manyconnectionsthing. Will have to look into
> it on Monday though. Any ideas welcome.
>
> Em

I am still hitting a brick wall with this 'too-many-connections'
thing :(

I am assuming that I need to be doing something with the Manager
creation_counter, but I can't see where this is being used  to close
default connections, so trying to implement something similar is
tricky :(

Can anyone help?

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
-~----------~----~----~----~------~----~------~--~---

Reply via email to