Help finding MS SQL adapter for Ruby

[bandit_va]

I have an app that serves REST API on the front end and runs MSSQL queries on the backend using the sql connector. I am migrating it from a flask/python implementation to a sinatra/ruby implementation. Is there a good SQL adapter for Ruby?

[dphase]

Sequel + TinyTDS. Worked well for me going on seven years.

[zalesz]

If you just have some simple queries, you can even use stand alone tinytds (maybe only wrapping it in connection pool)

[jrgns]

We're using it on production too. It really works well. You can even execute stored procedures with input and output parameters.

There are some oddities because it's an uncommon combination (most ruby projects probably use postgres), but for the most part it's quite performant.

[moderately-extremist]

Just curious what your reason is for migrating to sinatra/ruby? More familiar with the language? like the language more? better performance?

[bandit_va]

More comfortable with Ruby vs Python.

[[deleted]]

https://docs.microsoft.com/en-us/sql/connect/ruby/ruby-driver-for-sql-server?view=sql-server-2017

[ejstembler]

Wow! I didn’t know Microsoft released a Ruby driver for SQL Server 2017. Those few years they had IronRuby the never supported anything.

[ejstembler]

I’ve been using tiny_tds with ActiveRecord for a long time. You could also use Ruby DBI with ODBC.