Question 1

How do I install TinyTDS on Mac?

Accepted Answer

Install FreeTDS via Homebrew with commands like 'brew install freetds', then run 'gem install tiny_tds'. The README provides specific steps for dependencies like openssl and libiconv.

Question 2

What's the difference between TinyTDS and the ActiveRecord SQL Server adapter?

Accepted Answer

TinyTDS is the low-level database driver that handles connections and queries, while the ActiveRecord adapter uses TinyTDS to provide ORM functionality. TinyTDS is the default driver for the adapter in Rails.

Question 3

How to handle UTF-8 encoding errors in TinyTDS?

Accepted Answer

TinyTDS intelligently handles encoding: it replaces bad characters with '?' on reads and raises exceptions on writes, allowing transaction rollbacks. Configure encoding options in the client setup.

Question 4

Can TinyTDS be used with Sequel ORM?

Accepted Answer

Yes, TinyTDS can be used with the Sequel gem, as mentioned in the README under thread safety, though it's commonly paired with ActiveRecord for Rails applications.

Question 5

How do I set connection timeouts in TinyTDS?

Accepted Answer

Use the :timeout option in seconds when creating a TinyTds::Client, with default of 5 seconds. The README notes that network failures may raise errors after a delay.

Question 6

TinyTDS vs ODBC for Ruby SQL Server connections: which is better?

Accepted Answer

TinyTDS is often preferred for its simplicity and performance with FreeTDS, while ODBC might offer broader system compatibility but with more overhead. TinyTDS is optimized for common Ruby use cases.

Question 7

How to connect to Azure SQL Database with TinyTDS?

Accepted Answer

Set the :azure option to true in the client configuration and use a username format like 'username@server' (not the full domain). The README specifies this and recommends reviewing Azure guidelines.

TinyTDS

What is TinyTDS?

Overview

Use Cases

Best For

Related Projects

Found a gem we're missing?

Not Ideal For

Pros & Cons

Pros

Cons

Frequently Asked Questions