[Modeling-users] Porting to SQL Server

[Dennis Kertis]

I am interested in using the Modeling framework for
SQL Server and was wondering what is involved with
designing support for SQL Server? Any way someone
could give me a rough estimate of the time it would
take? I'd like to know what I am getting myself into.

thanks,
Dennis




__________________________________
Do you Yahoo!?
Yahoo! Mail - 50x more storage than other providers!
http://promotions.yahoo.com/new_mail

[Driver, David]

I am interested in a sql server porting as well I just didn't want to start
it on my own. I have never worked on oss, just with. I am willing to code
and or test.

[Sebastien Bigaret]

Post by Dennis Kertis
I am interested in using the Modeling framework for
SQL Server and was wondering what is involved with
designing support for SQL Server? Any way someone
could give me a rough estimate of the time it would
take? I'd like to know what I am getting myself into.

The time needed for the development of a new adaptor layer can be
roughly counted in days; it essentially depends on how far the database
server stands from SQL standards, obviously on how good you know the
server and its python adaptors, and how familiar one is with the MDL
framework.

I cannot help w/ SQL Server, and I won't be able to have a SQL Server
here (unless iot cabn be deployed on Linux ;) --but I can help during
the development of a new adaptor, esp. regarding integration into the
framework and the test-units.

You can have a look at the existing adaptor layers to get an idea of
what needs to be done, and ask for more here.

Some questions that needs to be answered before starting:

- how to make SQL JOINs
- does SQL Server support sequences? (for PK generation)

- check whether the types declared in SQLExpression's
valueTypeForExternalTypeMapping() are supported, and whether some
should be added

In any ways I'll be happy to collaborate w/ you and David to make this
happen.

-- Sébastien.

P.-S.: Oh, BTW, if we go for adding this into the framework it would be
important that it can be tested on a regular basis, esp. before a
release is made; would someone maybe consider to offer an access to a
sample db-server, or take the responsability for these tests?

[Driver, David]

So Dennis, Are you interested in working on this?

-----Original Message-----
From: Sebastien Bigaret [mailto:***@users.sourceforge.net]
Sent: Tuesday, August 03, 2004 3:15 PM
To: Dennis Kertis; David Driver
Cc: modeling-***@lists.sourceforge.net
Subject: Re: [Modeling-users] Porting to SQL Server

Post by Dennis Kertis
I am interested in using the Modeling framework for
SQL Server and was wondering what is involved with
designing support for SQL Server? Any way someone
could give me a rough estimate of the time it would
take? I'd like to know what I am getting myself into.

The time needed for the development of a new adaptor layer can be
roughly counted in days; it essentially depends on how far the database
server stands from SQL standards, obviously on how good you know the
server and its python adaptors, and how familiar one is with the MDL
framework.

I cannot help w/ SQL Server, and I won't be able to have a SQL Server
here (unless iot cabn be deployed on Linux ;) --but I can help during
the development of a new adaptor, esp. regarding integration into the
framework and the test-units.

You can have a look at the existing adaptor layers to get an idea of
what needs to be done, and ask for more here.

Some questions that needs to be answered before starting:

- how to make SQL JOINs
- does SQL Server support sequences? (for PK generation)

- check whether the types declared in SQLExpression's
valueTypeForExternalTypeMapping() are supported, and whether some
should be added

In any ways I'll be happy to collaborate w/ you and David to make this
happen.

-- Sébastien.

P.-S.: Oh, BTW, if we go for adding this into the framework it would be
important that it can be tested on a regular basis, esp. before a
release is made; would someone maybe consider to offer an access to a
sample db-server, or take the responsability for these tests?

[Dennis Kertis]

I am but it may take me a week or so to get up to
speed on the framework, as I have not used it yet. I
have postgres installed on cygwin which I can use to
get familiar with Modeling. I'm sure this will help
when going through the source code as well.

Post by Driver, David
So Dennis, Are you interested in working on this?
-----Original Message-----
From: Sebastien Bigaret
Sent: Tuesday, August 03, 2004 3:15 PM
To: Dennis Kertis; David Driver
Subject: Re: [Modeling-users] Porting to SQL Server

Post by Dennis Kertis
I am interested in using the Modeling framework

for

Post by Dennis Kertis
SQL Server and was wondering what is involved with
designing support for SQL Server? Any way someone
could give me a rough estimate of the time it

would

Post by Dennis Kertis
take? I'd like to know what I am getting myself

into.
The time needed for the development of a new adaptor
layer can be
roughly counted in days; it essentially depends on
how far the database
server stands from SQL standards, obviously on how
good you know the
server and its python adaptors, and how familiar one
is with the MDL
framework.
I cannot help w/ SQL Server, and I won't be able
to have a SQL Server
here (unless iot cabn be deployed on Linux ;)
--but I can help during
the development of a new adaptor, esp. regarding
integration into the
framework and the test-units.
You can have a look at the existing adaptor layers
to get an idea of
what needs to be done, and ask for more here.
Some questions that needs to be answered before
- how to make SQL JOINs
- does SQL Server support sequences? (for PK
generation)
- check whether the types declared in
SQLExpression's
valueTypeForExternalTypeMapping() are
supported, and whether some
should be added
In any ways I'll be happy to collaborate w/ you and
David to make this
happen.
-- S�bastien.
P.-S.: Oh, BTW, if we go for adding this into the
framework it would be
important that it can be tested on a regular
basis, esp. before a
release is made; would someone maybe consider to
offer an access to a
sample db-server, or take the responsability for
these tests?

__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail