Is there a good MSSQL / SQL Server adapter for sails.js?

Question

I want to preface this with saying that I really like sails.js for a simple MVC framework, but feel that it lacks in its documentation and api reference.

I searched all over to try and find any information on a good mssql (SQL server) adapter for Sails.js, but cannot find one. I am hoping someone has come across one, and could recommend it. I also looked into building a custom adapter, but found the documentation to not be helpful. Any help on this topic would be greatly appreciated. Thank you.

Answer 1

We don't currently have a MS SQL Server adapter but it's something I'd love to add. There is a basic definition of the various interfaces and how adapters are created at: API Adapter Interface.

If anyone would like to tackle this you can use the Sails MySQL Adapter or the Sails PostgreSQL Adapter as examples.

I don't have access to a MS SQL Server to build one out but there is an Integration Test library I use to build out adapters that support the CRUD interface: Waterline Adapter Tests.

Answer 2

I have recently started building a sails adapter for MSSQL based on the node-sqlserver module.

It isn't finished yet but I have finished the main parts of the adapter and it still needs testing, but there is enough there to get going.

It can be found at https://github.com/swelham/sails-mssql