Adds ability to ActiveRecord to retrieve the current transaction ID. This can be used to as metadata for the purposes of grouping operations performed on many records across many tables. In particular I had its usage with auditing libraries in mind.

Currently supported adapters:

  • PostgreSQL
  • OracleEnhanced (untested, help!)
  • Mysql, Mysql2 (help! user needs PROCESS privileges and requires a query returning/modifying records before you can get an id!!!)

Adapters with no support for retreiving the transactions ID:

  • Sqlite
  • Sqlite3

Please fork and add functionality for other databases.


Add this line to your application's Gemfile:

gem 'xid'

And then execute:

$ bundle

Or install it yourself as:

$ gem install xid 


Simply call this to get the current ID:



You must have the ActiveRecord test suite databases set up. The gem uses these to connect to for each adapter's specs.


  1. Fork it
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Added some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create new Pull Request