Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Meteor JS and SQL Server

Is there a simple way for Meteor.js to interact with a SQL Server the same way it does with MongoDB? For example, by using the Node.js MSSQL driver found here: http://www.microsoft.com/en-us/download/details.aspx?id=29995 - however ideally this needs to work in linux.

The closest I have found was tedious - how can I use this, or another alternative, in Meteor?

like image 787
rickyduck Avatar asked Apr 08 '13 13:04

rickyduck


People also ask

CAN node js work with SQL Server?

Yes, it's true. You can build Node. js applications with SQL Server! In this tutorial, you will learn the basics of creating a Node.

Can I connect to SQL Server using JavaScript?

There is no common way to connect to SQL Server database from JavaScript client, every browser has it's own API and packages to connect to SQL Server.

Is Snowflake an SQL Server?

And that's where Snowflake comes in. Snowflake is a cloud-based data platform that allows users to instantly and automatically scale, use all their data and support all users, securely share data, control costs, access data from any cloud, and query all data with ANSI SQL.

Can you use JavaScript and SQL?

SQL. js is a JavaScript library that allows you to create and query a relational database entirely in the browser. It uses a virtual database file stored in the browser memory, so it doesn't persist the changes made to the database. This library also uses Emscripten to compile SQLite to WebAssembly (Wasm).


1 Answers

You probably have read the meteor docs. You will find it is given there :

The current release of Meteor supports MongoDB, the popular document database, and the examples in this section use the MongoDB API. Future releases will include support for other databases.

So until 'that' future release, you won't have native support for other databases. Your best shot is to use packages that allow you to connect MS-SQL. You can check the packages listed here or search them here. Some of them are:

  1. https://npmjs.org/package/tedious
  2. https://npmjs.org/package/msnodesql
  3. https://npmjs.org/package/tds

Better use one that is popular and more recently updated.

like image 80
user568109 Avatar answered Sep 28 '22 08:09

user568109