Reputation: 2330
I have been using PHP for a number of years now and have found it to be (relatively) well documented, easy to work with, to setup and to use.
One of its main advantages is its capablility of working, without many modifications, similarly on a Windows or *nix platforms.
It also has good support for connecting to Microsoft SQL Servers, in particular 2005 + 2008 through the mssql module + ntwdblib.dll or FreeTDS.
That being said, the more time I spend developing PHP, the more I feel the need to pick up another scripting language to broaden my skill set and to develop better web-based applications.
Because of this I've spent some time exploring alternative scripting languages in an effort to evaluate their suitability.
At present the biggest hurdle I have come accross is support provided by recent versions of the Open Source scripting languages, specifically: Python 3.2.2, Ruby 1.9.2, Node 0.5.7 for the Windows OS (WinXP in my case) and Microsoft SQL Server (2005 + 2008).
My existing working environ necessitates the requirement for connecting to a MSSQL database.
I'm looking for answers from developers who have experience working with either Python, Ruby or Node.js and using them to interacting with a MS SQL Server.
What would be your recommended Open Source scripting language which has good support for MS SQL Server.
Ideas welcome.
-P.
Upvotes: 0
Views: 1132
Reputation: 26979
Ruby on Rails / ActiveRecord has support for mssql, using the activerecord-sqlserver-adapter gem.
Upvotes: 0
Reputation: 39950
Both Ruby and Python should be able to connect to MS SQL databases.
Python libraries:
Ruby libraries:
Upvotes: 1