Implement an ActiveRecord adapter

[noteflakes]

'nough said.

[fractaledmind]

I started experimenting in the Rails codebase to see what I needed to patch/alias from Extralite to have the default Rails SQLite adapter work with Extralite instead. I haven't finished that project, but I was at the point where I was running the tests. Here is the patch I was using:

module Extralite
  class Database
    alias_method :original_execute, :execute
    alias_method :execute, :query
    alias_method :execute_batch2, :query
    alias_method :readonly?, :read_only?

    def transaction(mode = :immediate)
      mode = @default_transaction_mode if mode.nil?
      execute "begin #{mode} transaction"

      if block_given?
        abort = false
        begin
          yield self
        rescue
          abort = true
          raise
        ensure
          abort ? rollback : commit
        end
      end

      true
    end

    def commit = execute("commit transaction")
    def rollback = execute("rollback transaction")
    def encoding = "UTF-8"
    def busy_timeout(timeout) = self.busy_timeout=(timeout)
  end

  class Query
    alias_method :original_to_a, :to_a
    alias_method :to_a, :to_a_ary
    alias_method :reset!, :reset
    def bind_params(bind_vars) = bind(*bind_vars)

    alias_method :original_columns, :columns
    def columns = original_columns.map(&:to_s)
  end
end

On the Rails side, I only needed to patch the SQLite3Adapter.new_client method:

def new_client(config)
  ::Extralite::Database.new(config[:database].to_s, config)
  # ...
end

I'm not sure if you want to go in this direction (proving a compatibility layer so that the default Rails adapter can be used as is), but if so, this is a healthy starting point.

[martijn10kb]

@fractaledmind I kinda found that you have been more then just experimenting.. And I saw that you have a gem with this PR: fractaledmind/activerecord-enhancedsqlite3-adapter#2 Will there ever be a future where this will be finished nicely, with that PR integrated?