SqlAlchemy branch status or composite keys?

[Mike Driscoll]

Hi,

I am doing research on alternative Python Web Frameworks that I can
use at my place of work. We use legacy SQL Server and have many
databases from various vendors which include composite (multi-column)
primary keys of the non-integer variety. Does anyone know how Ticket
373 is coming along or if the SqlAlchemy branch of Django is getting
any love? The ticket doesn't seem to have any new data since approx. 4
months ago (see http://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys)
and I can't find much of anything newer than March 2007 for the
SqlAlchemy branch.

Anyone know what's going on? I've been messing with TurboGears for a
couple of weeks, but their SqlAlchemy implementation doesn't seem to
play nice with MS SQL Server.

Thanks,

Mike

[Jacob Kaplan-Moss]

Hi Mike --

The SQLAlchemy branch is defunct.

Jacob

[Ben Ford]

Hi Mike,
As far as I know the newest body of work regarding SA is the tranquil project on google code. Have a look here
Hope it help, I haven't read through enough of the source to know if it does what you want.
Cheers
Ben

[Malcolm Tredinnick]

Multi-column primary keys is something we'll have one day, but maybe not
in the immediate future. The problem is that it's very hard to make it
work in a backwards compatible way. The first 75% is really easy, but
then you have to make it work with generic relations and admin logs and
things like that and you realise that the last 25% is about 90% of the
work.

I've started writing some code to implement them, but keep coming up
against that hurdle, so I've put it off for a bit.

Search the recent archives of this list for information about an
external SQLAlchemy integration. The branch in Django's subversion
repository isn't being maintained.

Malcolm

--
Borrow from a pessimist - they don't expect it back.
http://www.pointy-stick.com/blog/

[Mike Driscoll]

Ben,

On Feb 25, 4:32 pm, "Ben Ford" <ben.for...@gmail.com> wrote:
> Hi Mike,
> As far as I know the newest body of work regarding SA is the tranquil

> project on google code. Have a look here<http://code.google.com/p/tranquil/>

> Hope it help, I haven't read through enough of the source to know if it does
> what you want.
> Cheers
> Ben

Thanks for the info. I'll check it out and see if it does what I need
or not.

Mike

>
> On 25/02/2008, Mike Driscoll <kyoso...@gmail.com> wrote:
>
>
>
>
>
> > Hi,
>
> > I am doing research on alternative Python Web Frameworks that I can
> > use at my place of work. We use legacy SQL Server and have many
> > databases from various vendors which include composite (multi-column)
> > primary keys of the non-integer variety. Does anyone know how Ticket
> > 373 is coming along or if the SqlAlchemy branch of Django is getting
> > any love? The ticket doesn't seem to have any new data since approx. 4
> > months ago (see
> >http://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys)
> > and I can't find much of anything newer than March 2007 for the
> > SqlAlchemy branch.
>
> > Anyone know what's going on? I've been messing with TurboGears for a
> > couple of weeks, but their SqlAlchemy implementation doesn't seem to
> > play nice with MS SQL Server.
>
> > Thanks,
>
> > Mike
>

> --
> Regards,
> Ben Ford
> ben.for...@gmail.com
> +447792598685

[Mike Driscoll]

Malcolm,

On Feb 25, 5:05 pm, Malcolm Tredinnick <malc...@pointy-stick.com>
wrote:

> On Mon, 2008-02-25 at 13:33 -0800, Mike Driscoll wrote:
> > Hi,
>
> > I am doing research on alternative Python Web Frameworks that I can
> > use at my place of work. We use legacy SQL Server and have many
> > databases from various vendors which include composite (multi-column)
> > primary keys of the non-integer variety. Does anyone know how Ticket
> > 373 is coming along or if the SqlAlchemy branch of Django is getting
> > any love? The ticket doesn't seem to have any new data since approx. 4

> > months ago (seehttp://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys)

> > and I can't find much of anything newer than March 2007 for the
> > SqlAlchemy branch.
>
> > Anyone know what's going on? I've been messing with TurboGears for a
> > couple of weeks, but their SqlAlchemy implementation doesn't seem to
> > play nice with MS SQL Server.
>
> Multi-column primary keys is something we'll have one day, but maybe not
> in the immediate future. The problem is that it's very hard to make it
> work in a backwards compatible way. The first 75% is really easy, but
> then you have to make it work with generic relations and admin logs and
> things like that and you realise that the last 25% is about 90% of the
> work.
>
> I've started writing some code to implement them, but keep coming up
> against that hurdle, so I've put it off for a bit.
>
> Search the recent archives of this list for information about an
> external SQLAlchemy integration. The branch in Django's subversion
> repository isn't being maintained.
>
> Malcolm
>
> --
> Borrow from a pessimist - they don't expect it back.http://www.pointy-stick.com/blog/

Ben Ford mentioned Tranquil, so I assume that's what you were
referring to. However, I'll also do a search of the archives and see
if there's any alternate information.

Mike

[Malcolm Tredinnick]

On Tue, 2008-02-26 at 06:50 -0800, Mike Driscoll wrote:

> Ben Ford mentioned Tranquil, so I assume that's what you were
> referring to.

Yes, that's the one I meant. My reply and Ben's crossed in the post, so
I could have saved myself some time if I'd waited longer (or he'd typed
faster).

Regards,
Malcolm

--
The sooner you fall behind, the more time you'll have to catch up.
http://www.pointy-stick.com/blog/

[Ben Ford]

It's true, I do type like an drunken 84 year old with broken fingers, my sincere apologies :-)

 (or he'd typed faster).

--
Regards,
Ben Ford
ben.f...@gmail.com
+447792598685