MS SQL Connector

Question

MS SQL Connector

marktani opened this issue 7 years ago · 71 comments

marktani commented 7 years ago

This feature requests serves as a central place to discuss development and progress for the MS SQL connector.

nadilas commented 7 years ago

+1

jurby commented 7 years ago

+1

felixti commented 6 years ago

+1

👎4

albangiroux commented 6 years ago

+1

👎4

killjoy2013 commented 6 years ago

+1

👎3

Answer 1 · 2018-01-30T18:38:26.000Z

When you can expect a working connector to Ms SQL ??

Answer 2 · 2018-01-31T03:02:47.000Z

I need this too

Answer 3 · 2018-01-31T20:33:05.000Z

Hey @SebaBoler and @iamgmd, thanks a lot for your interest in the MS SQL connector 🙂
I would love to hear your thoughts on specific use cases you'd like to be covered, and an initial suggestion for the SDL syntax and exposed capabilities.

You can read more contributing to a DB connector here.

Answer 4 · 2018-02-17T15:07:28.000Z

Super excited about this, though I will probably fall back on the hosted platform as I'm getting tired of managing everything - the NET community is ~desperate for a GraphQL API interface to SQL Server.

Answer 5 · 2018-02-21T22:00:48.000Z

I noticed MS SQL was missing on the main README: https://github.com/graphcool/prisma.

Answer 6 · 2018-03-19T08:28:41.000Z

I waiting for this

Answer 7 · 2018-04-11T15:52:09.000Z

I need this badly

Answer 8 · 2018-04-11T16:09:11.000Z

Thanks a lot for your feedback everyone 🙂

If you have any thoughts in the spirit of what I mentioned above, I'd be happy to hear it!
If you want to express your desire in this feature, please use Github reactions on the original post. Thanks! 🙌

Answer 9 · 2018-04-16T01:50:29.000Z

I really need this! Please make this happen!

Answer 10 · 2018-05-17T09:08:53.000Z

There is a huge .NET community - by supporting MSSQL and writing some how-to's on deploying onto Azure I think you will capture some massive traction in the enterprise space - especially financial services.

Answer 11 · 2018-05-17T15:49:38.000Z

Big +1 on this. Regarding features even just reproducing the pgsql functionality would solve 90% of users needs.

Answer 12 · 2018-05-29T07:40:29.000Z

This is important because there are lots of enterprise organizations as @develomark mentioned, which use MS SQL and they will be able to start using Prisma (I'll be one who will suggest them to try), hope it will happen soon :) Also I'll take a look current connectors and I'll try to share something valuable about that.

One note here, if you will support azure sql, ms sql will be supported also, because azure sql is limited version of ms sql, but those limits will not have any effects for Prisma.

Answer 13 · 2018-06-18T08:22:56.000Z

I also would like to take a vote for a MSSQL connector to

push Prisma/GraphQL to enterprise environments
broaden the availabitly and compatibility of Prisma

Since I have become a user of MSSQL I must say it's a great DBMS and I would like to start a GraphQL project with some of our customers. Therefore I would like to have a solid development library that fits with SQL Server and is capable of using some more of the TSQL features and is not limited to a a really small subset of the SQL standard.

One could say to go with .NET/.NET Core but making Prisma available as a JavaScript solution to the market would propably also accell the need and use of full stack JS developers that could create products for big enterprise customers.

Answer 14 · 2018-08-06T10:15:19.000Z

hope this .

Answer 15 · 2018-08-29T11:44:42.000Z

When I execute 'prisma deploy' to a local MySQL instance, I get this error.
What am I missing?

TypeError: Cannot read property 'name' of undefined
at Socket. (C:\Users\Owner\AppData\Roaming\npm\node_modules\prisma\node_modules\pg\lib\connection.js:123:21)

Answer 16 · 2018-08-29T11:49:17.000Z

@Gary-Shurgin Not sure if your post is relevant in this thread as this one is related to wanting MS SQL in Prisma, nothing to do with MySQL.

Answer 17 · 2018-09-06T09:26:57.000Z

This connector should be shipped by default as soon as possible.
Supported should be

Tables (of course)
Views
Stored Procedures (including result selection)
Table- and Scalarfunctions
Table Types

Answer 18 · 2018-09-07T16:09:50.000Z

I think you can add support to this through the Microsoft SQLServer JDBC library ?

Code should be similar to what you have done with MySQL and PostgreSQL.

You might also need to consider supporting different versions :
https://docs.microsoft.com/fr-fr/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix

Microsoft team has also been open-sourcing lot of stuff related to SQL Server lately, may be we can ask their help. Check out the Linux tools they have released:

I am using these tool at work in a Linux / Scala environment with connection to Windows / SQL Server backends. But not using GraphQL for the moment.

Answer 19 · 2018-09-10T06:44:58.000Z

Would like to know whether the work on this has started or not? Dont see a branch for it either.

Answer 20 · 2018-11-28T22:39:22.000Z

I need this so badly, at this moment I use TypeORM because of this, if we have MS SQL Server Connector, for sure I change for Prisma.
Other project I develop I used PostgreSQL and MariaDB (MySQL),

Answer 21 · 2019-01-18T15:30:27.000Z

I notice there's some development on the JDBC connector. Having not worked on MSSQL for a long time, I have to ask if the JDBC connector allows use of MSSQL? Azure SQL?

Answer 22 · 2019-01-29T17:10:29.000Z

Anyone have an update on this? I would like to help contribute to the project if it's in active development.

Answer 23 · 2019-02-02T15:51:59.000Z

CRUD functions with API access would work at first. We would love to use Prisma. @marktani is there already something going on?

Answer 24 · 2019-02-03T10:10:17.000Z

You can read more contributing to a DB connector here.

404

Answer 25 · 2019-02-12T13:58:33.000Z

It will be great to have it.

Answer 26 · 2019-02-12T17:07:53.000Z

I need support for Azure SQL

Answer 27 · 2019-02-25T19:31:23.000Z

I need it too

Answer 28 · 2019-03-03T17:51:16.000Z

Is this being worked on? Don't see a branch that seems relevant. If it is, I'd love to get my hands dirty and help get it finished.

Answer 29 · 2019-03-14T08:49:11.000Z

Hey ..
pls. implement this connector to push prisma to enterprise environment

Answer 30 · 2019-03-16T01:53:36.000Z

Is there a way to contribute to new connectors? A comment mentions a doc on this topic but it’s a 404 and I don’t see any updated link.

Answer 31 · 2019-03-28T15:15:54.000Z

https://github.com/prisma/prisma/issues/1751 for the new link

You can read more contributing to a DB connector here.

404

Answer 32 · 2019-05-07T18:19:52.000Z

I need this so badly. Any news? Is this even started?

Answer 33 · 2019-05-30T03:30:07.000Z

Has there been any progress on this? Is there any way to contribute? A MSSQL connector is in much demand! 🤞

Answer 34 · 2019-05-31T14:10:29.000Z

Has there been any progress on this? Is there any way to contribute? A MSSQL connector is in much demand!

Its possible to build a GraphQL solution with Apollo and MSSQL. Its still not as elegant as using Prisma and would love to see a connector built for it.

I used this article as a starting point: https://medium.com/infocentric/setup-a-graphql-api-with-apollo-2-0-sequelize-and-express-js-608d1365d776

Installed tedious instead of mysql2. Hope this helps.

Answer 35 · 2019-07-01T01:28:10.000Z

you needa another round of funding then build it
https://github.com/microsoft/mssql-jdbc

Answer 36 · 2019-07-01T19:14:05.000Z

definitely waiting for it.

Answer 37 · 2019-07-14T09:03:20.000Z

Would be great if we have some idea on this - The organisation where I work at is investing on creating Microservices, APIs/GraphQL, etc. for its legacy infrastructure based on MS SQL. Wanted to know if we can leverage this at some point of time.

Btw, Amazing work by all of you guys with Prisma! Its even cooler than GraphCool

Answer 38 · 2019-07-24T19:06:46.000Z

Need this badly.

Answer 39 · 2019-08-08T12:52:59.000Z

Is it possible to ask if we are even near to a beta stage? We've followed this confidently from 1Y ago... But still nothing. I know even 2 more big companies are waiting for this for updating some old projects.

Answer 40 · 2019-08-10T17:36:36.000Z

Just adding to the growing list of people wanting this feature and also wondering about the status of current efforts and the potential to contribute (link above is still 404).

Answer 41 · 2019-08-13T06:36:15.000Z

@infin8loop yes the team needs to provide better guides for "how to contribute" and "writing a db connector" in order to enable the community to help here

Answer 42 · 2019-08-13T14:24:22.000Z

Do we have any timelines for this? Keen to see or contribute to this as it will greatly help when building for enterprises that work only with MS SQL due to legacy implementations.

Answer 43 · 2019-08-16T10:45:04.000Z

I need it badly too. any update yet?

Answer 44 · 2019-08-16T14:34:04.000Z

I don't understand why no one reply. I understand that actually there aren't any intention of doing some efforts; but I don't understand why no one is explicitly saying this.

Answer 45 · 2019-08-16T23:04:13.000Z

Typeorm or sequenlize could be alternatives solution. But they are not designed for gql specifically.

Answer 46 · 2019-08-19T20:18:43.000Z

This is annoying. MS Sql is still in the top 3 most used DBs world wide, double more used than Postgres that already has the connector.

Also if it not deserves a connector yet, I think may deserves a reply at least

Answer 47 · 2019-08-23T14:53:56.000Z

Is this due to the different type of connection. I see on W3 that you simply import mysql and connect, where as a msSql database needs an odbc connection. It would make sense then that a connection like this might take longer and work differently with the infrustructure.

It would be a cool feature to have. Is there a way to use a node server as a middleware for this. Could we use a node server connecting through odbc then pass that to prisma directly from the query response?

https://www.tutorialsteacher.com/nodejs/access-sql-server-in-nodejs

Answer 48 · 2019-08-23T17:08:21.000Z

@JesseHenson
All the kind of reasons would be accepted. A "This feature is postponed due to technical issues" would be great also...

The silence NO.

Answer 49 · 2019-08-28T10:11:10.000Z

if you really need sth for mssql database connector badly. There is another open source library called sql datasource, it’s been recommended by Apollo offical document(you should be able to find it y reading doc of Apollo-datasource-rest)You can find it from Github(https://github.com/cvburgess/SQLDataSource/blob/master/README.md#sqldatasource). It’s based on knex and Apollo-datasource. It provides huge flexibility to build a ms sql server based datasource connector at gql server, it has some good features such as batching, transactions and simple syntax. Try it with dataloader would be a way to go if you can’t wait prisma’s new release. Hope it helps.

Answer 50 · 2019-09-04T15:22:40.000Z

Has there been any progress on this? Is there any way to contribute? A MSSQL connector is in much demand!

Its possible to build a GraphQL solution with Apollo and MSSQL. Its still not as elegant as using Prisma and would love to see a connector built for it.

I used this article as a starting point: https://medium.com/infocentric/setup-a-graphql-api-with-apollo-2-0-sequelize-and-express-js-608d1365d776

Installed tedious instead of mysql2. Hope this helps.

I have done this and it is not that difficult If anyone wants to see a SOLID implementation check out the "The road to graphql" by Robin Wieruch

Full walk though

Answer 51 · 2019-09-05T11:19:46.000Z

Prisma 2 is currently being rewritten using Rust instead of Scala.

Are any more DB connectors being written for Prisma 1? Or is the plan to wait until Prisma 2 is out before any more are written? And at that point we may expect to have a SQL Server DB connector?

Answer 52 · 2019-09-30T08:10:49.000Z

Is it a good day to ask about ETA? Or even to ask about EST?
I've seen a lot of good feature proposal for Prisma 2! 😄

But... it's a shame that most of the people are cut off because of the lack of connectors

Answer 53 · 2019-10-25T21:26:31.000Z

Hey, for anyone trying to help out here, but hitting that 404:

It's not too bad to correct the link. Just change 'graphcool' to 'prisma' and the link will work. That will help, because the next link is full of links that 404 too 😆

Answer 54 · 2019-10-26T18:53:42.000Z

@AndryHTC

But... it's a shame that most of the people are cut off because of the lack of connectors

What problem are you trying to solve? Is it that you want to do GraphQL with SQL Server or is it that you want to specifically use Prisma with SQL Server?

Answer 55 · 2019-10-28T07:28:56.000Z

The final target

@AndryHTC

But... it's a shame that most of the people are cut off because of the lack of connectors

What problem are you trying to solve? Is it that you want to do GraphQL with SQL Server or is it that you want to specifically use Prisma with SQL Server?

The final target is obtaining a GraphQL with SQL Server, with subscriptions, schema migrations and all the good stuff of PRISMA. So, probably... The final target is obtaining PRISMA for SQL Server?

I've seen another great tool, also that only for Postgres Hasura

Answer 56 · 2019-12-20T23:08:12.000Z

Sorry, but everything is a mess... Do we need to wait here the connector even for Prisma 2, Prisma Framework or Photon.js ecc...?

Answer 57 · 2019-12-30T17:44:55.000Z

This will be a game changer and I for one would be more than glad to encourage my team to adopting this. Any ETA would be highly appreciated.

Answer 58 · 2020-03-23T16:27:39.000Z

Any insights into where this might fit on the roadmap?

Answer 59 · 2020-03-31T10:44:20.000Z

After 2+ years would be gold :)

Answer 60 · 2020-03-31T11:53:28.000Z

Is there any way to post a bounty towards this feature?

Answer 61 · 2020-04-24T15:42:21.000Z

Is there any way to post a bounty towards this feature?

Bounty or somehow Microsoft buys prisma 😂

Answer 62 · 2020-04-24T17:33:22.000Z

For prisma 1, I do not think this will happen. For prisma 2, it will probably happen sometime after it is stable, or somebody starts to write this connector. I am told it is a lot easier than for prisma 1.

Answer 63 · 2020-06-08T12:06:46.000Z

Starting a new project and used typeorm for that. Until I saw a demo of Prisma and fell in love with its simple and clean syntax. God I would love to use it in cooperation with MSSQL. Waiting eagerly ... :)

Answer 64 · 2020-06-19T11:38:39.000Z

Starting a new project and used typeorm for that. Until I saw a demo of Prisma and fell in love with its simple and clean syntax. God I would love to use it in cooperation with MSSQL. Waiting eagerly ... :)

Good luck :)

Answer 65 · 2020-07-01T19:28:26.000Z

Prisma is working on this it seems. They've done a lot work patching this driver:

https://github.com/prisma/tiberius

If anyone knows Rust and wants to contribute their expertise on this then check out this repo.

Answer 66 · 2020-09-03T17:52:36.000Z

Eagerly waiting on this. Because I need a sql database for my project, I'm currently using MySql and it sucks...