Dead, or merely dormant?

Question

Dead, or merely dormant?

oaustegard opened this issue 10 years ago · 37 comments

oaustegard commented 10 years ago

Nearly 2 years without an update does not signal a healthy library.

Where does this fall compared to say https://github.com/pekim/tedious?

justinfreitag-zz commented 10 years ago

bump :)

Answer 1 · 2015-05-04T18:56:09.000Z

Dead.
No action for a long time and no response to your post.
Shame, this could have helped with a project I have been working on. Will have to use other routes to get data from MS SQL 2014 to node.

Answer 2 · 2015-05-04T23:25:11.000Z

Hello oaustegard.
We are currently working on the next node.js driver. Additionally we just updated some docs Azure.com.
http://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-nodejs-simple-windows/
It is a getting started simple doc. We are also working on a blog series which go deeper into using this driver.
Feel free to reach out to me if you have any questions about this driver.
Best,
Meet

Answer 3 · 2015-05-07T16:43:11.000Z

Thanks @meet-bhagdev. Will the next node.js driver be open-source? Will it be continuing from the work in this repo? It'd be nice for some observable activity. MS SQL would be a great fit for some of my work, but hard to trust it'll be there when I need it in the future.

Answer 4 · 2015-05-07T18:33:35.000Z

The next node.js driver will be open source. We are still working on a cadence strategy for accepting pull requests. It will definitely build on on the codebase here. We now have a dedicated team here at Microsoft whose goal is to maintain SQL Server drivers. So if you need any help with the driver in the future feel free to reach out :)

Answer 5 · 2015-05-11T08:05:52.000Z

That's great news. When can we expect a release?
I don't want to hijack this thread, but...

If there is a dedicated team at Microsoft looking after MS SQL Server drivers - could they please have a look at this blog post I wrote?
http://blog.alignment-systems.com/2015/04/microsoft-jdbc-40-and-41-driver-missing.html
Would be good to get the documentation for the JDBC driver included in the distribution...

Answer 6 · 2015-05-29T08:37:27.000Z

yeah, hope to release ASAP.

Answer 7 · 2015-06-12T05:52:36.000Z

@JohnGreenan : Unfortunately I can not give you a date but let me tell we are working on it as I type :)
For Java, here is some documentation
https://azure.microsoft.com/en-us/documentation/articles/sql-data-java-how-to-use-sql-database/

Answer 8 · 2015-07-13T14:50:44.000Z

Any update on the release date? The current version is honestly a sorry excuse for an NPM module. The whole point is not to have to build the plugin after download to get it to run.

Answer 9 · 2015-07-14T15:30:53.000Z

If this project is dormant you should put that right at the top of the readme.md.

Answer 10 · 2015-07-14T16:57:09.000Z

No, it’s not. We are revamping it and will have a new release in the following months.

Thanks

From: Justin Collum [mailto:notifications@github.com]
Sent: Tuesday, July 14, 2015 8:31 AM
To: Azure/node-sqlserver
Subject: Re: [node-sqlserver] Dead, or merely dormant? (#189)

If this project is dormant you should put that right at the top of the readme.md.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/189#issuecomment-121282662.

Answer 11 · 2015-07-14T17:13:00.000Z

OK. But if this is another "it will only work on Windows" situation (like the officially supported MS SQL Node driver) it will be... disappointing to put it nicely. My team develops on Macs and assumes the code will land on Debian/Ubuntu.

Answer 12 · 2015-07-14T17:14:40.000Z

Hello tylersmith34,
We are working in a newer version of the Node.js driver. Right now, we are heads down working on the scheduling the next version of our Node.js and will let you know when it’s available.

Answer 13 · 2015-07-14T17:14:52.000Z

We will make it available to other OS'es too.

Sent from my iPhone

On Jul 14, 2015, at 10:13 AM, Justin Collum <notifications@github.com mailto:notifications@github.com> wrote:

OK. But if this is another "it will only work on Windows" situation (like the officially supported MS SQL Node driver) there's no way I'll use it.

Reply to this email directly or view it on GitHubhttps://github.com//issues/189#issuecomment-121311722.

Answer 14 · 2015-07-14T17:16:02.000Z

Good news, thanks.

Answer 15 · 2015-10-06T16:56:57.000Z

Any update on the release date of the driver?

Answer 16 · 2015-10-06T17:27:21.000Z

@MartinStava in the meantime you might want to have a look at Seriate. https://www.npmjs.com/package/seriate

Answer 17 · 2015-10-06T17:37:38.000Z

@MartinStava @jcollum we are still working on a new release. In the meantime I highly encourage you look at msnodesqlv8: https://www.npmjs.com/package/msnodesqlv8. Here is the Github repo: https://github.com/TimelordUK/node-sqlserver-v8

It is basically this driver but with latest node.js version compatibility, command line install experience, no dependencies and great performance.

It is a fork of this project and we plan on using it as a base for our next version. Hope this helps and if you have any questions please let me know.

Thanks,
Meet

Answer 18 · 2015-10-06T17:38:52.000Z

@meet-bhagdev @jcollum thank you very much, guys, for pointing me the right direction. I'll definitely give it a try.

Answer 19 · 2015-10-17T14:26:06.000Z

@meet-bhagdev thanks for the updates. Will the new module have linux support?

Answer 20 · 2016-02-16T19:12:11.000Z

Any word on this? Would like to see MSFT supporting their products on node...

Answer 21 · 2016-02-16T20:50:43.000Z

@chadbr : Have you had a chance to check out : https://github.com/TimelordUK/node-sqlserver-v8 ? This seems to fix several of the issues with this driver and shares the same core codebase. I also encourage you to check out https://github.com/patriksimek/node-mssql. We are working out a plan for the node.js driver and will keep you and the rest updated on Github.

Answer 22 · 2016-02-16T21:03:29.000Z

@meet-bhagdev thanks for the update. I've checked it out -- haven't had a chance to try it yet. Just trying to gauge an ETA, etc...

Thanks --

Answer 23 · 2016-06-10T00:46:26.000Z

Hello all,

We at SQL Server have been working hard on putting concerted efforts in training our engineering support team to support with open source drivers. We are pleased to inform you that we now support the Tedious driver. Considering that the Microsoft Node.js driver for SQL Server lacks support for the latest Node.js version, we recommend you to use Tedious for Node.js versions 0.8.x and above.

We would also like to understand your use cases and requirements for the Microsoft SQL Server - Node.js driver for SQL Server. This will to enable us to help you better.

Thank you,
SQL Server team.

Answer 24 · 2016-06-10T13:36:36.000Z

That's great to hear.

Does this mean the MS driver is dead? @Lfsantos said last year it was still in progress...

Thanks, Chad

Answer 25 · 2016-06-11T00:22:49.000Z

@chadbr: It means that a lot of people use Tedious, in fact people use the following drivers with SQL. Our goal is to support customers using all the popular drivers from the list below beyond just the MSFT built ones :)

Answer 26 · 2017-01-05T14:25:13.000Z

So does Microsoft have any plans to release a Node specific SQL Server driver anymore? I've had success using the MS SQL driver for PHP and would like to see something similar in Node.js.

Answer 27 · 2017-01-05T17:08:29.000Z

@restored18 as far as I can tell - Tedious is the answer...

Answer 28 · 2017-01-12T19:01:06.000Z

@chadbr @meet-bhagdev So does this mean Microsoft is putting engineering time into Tedious or is it just a general recommendation for Node users?

Answer 29 · 2017-01-13T18:01:20.000Z

Hello @restored18,

Yes, Microsoft is now actively contributing to Tedious. A few of the things we have done already include the following PRs:

We are also working on adding support for new features for SQL Server, starting with Windows Autentication:

Please let me know if you have any questions 👍

Thanks,
Luis

Answer 30 · 2017-01-13T19:32:45.000Z

@LuisBosquez that's great to hear, I would like to use Node with SQL Server in the future so having a well supported driver is encouraging.

Answer 31 · 2017-01-13T19:42:38.000Z

@restored18 Awesome! Make sure to check out our new samples website: Build an app using SQL Server where we have our getting started samples, as well as all of our driver recommendations for each programming language.

Answer 32 · 2018-04-02T17:02:26.000Z

@LuisBosquez

Hi - We are trying to use the library at https://github.com/tediousjs/node-mssql but are getting random connection pool timeout errors. There are many open issues on the connection pool and other error in that library as well as open PR's etc.

There is even a comment about 'someone from Microsoft' being interested in taking over the library:

tediousjs/node-mssql#601 (comment)

Can you help with this? This is causing us major headaches in our production environment.

Answer 33 · 2018-04-02T18:36:13.000Z

@MrRoyce
Hi - I'm the current PM for the SQL Server drivers teams. I read the conversation you linked to. I had not seen it before and didn't realize node-mssql had been added to the tediousjs org. The conversation is good, though, as Microsoft officially supports and contributes to the tedious project for Node.js connections to SQL Server and we welcome any suggestions on how we can improve the Node.js experience connecting to SQL Server. If people are using something different due to limitations in tedious, those are good areas we can focus our efforts on improving the driver.

That said, I don't see Microsoft signing up to maintain two separate Node.js drivers at this time. As Arthur noted, that has a significant, non-zero cost to it. Ideally, either users migrate to tedious, or (something like this would be driven by Arthur as the tedious owner) tedious and node-mssql merge into a single entity that we continue to support.

Regards,
David

Answer 34 · 2018-04-02T18:55:12.000Z

@David-Engel thanks for the quick response! Do you work with @arthurschreiber?

As you see from the other project, there are lots of folks struggling with the node-mssql library but are scared to switch because of its simple(r) API, connection pools, etc. We are using it in production for several applications (Node.js, Docker) but the instability in the connection is making everyone here very frustrated.

Maybe a best case scenario for developers and Microsoft would be to upgrade the tedious driver to have the same API as the node-mssql library with fixes for the connection pool and other issues.

If you can provide some clarity on the direction we should take, it would be greatly appreciated.

Answer 35 · 2018-04-02T20:12:15.000Z

@MrRoyce I work for Microsoft with the team that contributes to tedious. @arthurschreiber owns the tedious open-source project and we work with him to maintain and improve it. We are happy to participate in conversations on the direction of tedious but we don't make the ultimate decisions there.

As for the direction you should take, I don't really know enough about node-mssql, your issues with it, and how hard it would be for you to migrate to tedious to make that call for you. I can say that Microsoft does officially support tedious and we help troubleshoot and respond to issues filed in the tedious repo. We are committed to helping customers succeed with the tedious driver.

Tedious is open-source and all contributors are welcome. If you have the ability, you can always propose an API layer in tedious to ease migration from node-mssql. 😃

Regards,
David

Answer 36 · 2018-07-05T21:26:54.000Z

@MrRoyce I've just released a new version of node-mssql that should solve the problems with request timeouts. To read more about that and the future maintenance of node-mssql, please read tediousjs/node-mssql#601 (comment).