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?
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.
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.
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.
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).
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:
Better use one that is popular and more recently updated.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With