AdapterExtensions add extra abilities to Rails ActiveRecord adapters, including:
- bulk load
- truncate table
- copy table
- add select into table
Compatibility matrix
See Travis for up-to-date info: 
| v1.0.0.rc1 | v0.9.5 | |
|---|---|---|
| ActiveRecord adapters | ||
| mysql | OK | OK |
| mysql2 | OK | Unsupported |
| postgresql | OK | OK |
| sqlserver | Work in progress | Broken |
| ActiveRecord/ActiveSupport versions | >= 3 | < 3 |
| Ruby versions | ||
| MRI 1.9.3 | OK | Untested |
| MRI 1.8.7 | OK | Should be OK |
Important notes on MySQL support
Security warning
Be sure to first read and understand the security implications of LOAD DATA LOCAL INFILE. In particular, having this enabled on a web app is probably not a good idea.
v0.9.5
v0.9.5 will always use LOAD DATA LOCAL INFILE for bulk load - this is not configurable.
v1.0.0.rc1
This version should by default use LOAD DATA INFILE for safer defaults.
You can override this by passing :local_infile => true though.
Troubleshooting LOCAL INFILE
If you enable :local_infile => true and meet the following error, then you'll have to work it around.
The used command is not allowed with this MySQL version: LOAD DATA LOCAL INFILE
For mysql2 with AR >= 3.1:
- use this fork until this pull-request is merged
- add
local_infile: trueto your database.yml
For mysql2 with AR < 3.1:
- no current easy solution afaik
For mysql:
- try this untested patch
Notes on SQLServer support
v0.9.5 had a broken support for SQLServer.
v1.0.0.rc1 has a work-in-progress bulk import using freebcp. More tweaking needed.
Running the tests
You may have to tweak the Rakefile and database.yml a bit, but roughly:
rake ci:create_db
rake "ci:run_one[mysql2,test/config/gemfiles/Gemfile.rails-3.2.x]"
You can also run a matrix of tests using:
rake ci:run_matrix
License
MIT
Contributors
- Thibaut Barrère (current maintainer)
- original code by Anthony Eden and probably others (let me know if you read this!)
- thanks to Zach Dennis for his work where I borrowed ideas for the rails 3 rewrite