Extralite 2.0 released

[noteflakes]

Extralite 2.0 has been released!

Extralite is a gem for working with SQLite databases. It is blazing fast (up to 11x the performance of the sqlite3 gem), and provides a rich API for accessing database data in a variety of formats.

Version 2.0 introduces a number of new APIs, removes the old PreparedStatement API, and fixes a number of issues.

New features

• A new Query class represents a parametrized query that is prepared once and can be reused with different bound parameters. It provides a new, richer API for accessing query rows, enabling external iteration using an Enumerable iterator. Here's a quick overview of some of the new capabilities:

  query = db.prepare('select * from foo where bar = ?')
  query.bind(42).each { |r| ... } # rows as hashes
  query.each_ary { |r| ... } # rows as arrays
  
  # with external iteration, we can iterate through individual records
  while (row = query.next)
    handle_row(row)
  end
  
  # we can also iterate through batches of records
  while (batch = query.next(10))
    handle_batch(batch)
  end
  
  # calling Query#each without a block returns an Enumerable iterator
  results = query.each.map { |r| r[:bar] * 10 }

Removed APIs

• The old PreparedStatement class is removed in favor of the new Query class.

Bug Fixes

• The Sequel Extralite adapter is improved, and Sequel migrations are fixed (ThreadPool#process does not work after call to Process.daemon #8). To use Extralite with Sequel, specify extralite as the connection URL scheme:

  db = Sequel.connect('extralite:/path/to/db')

Other improvements

• Some minor improvements to the docs.

Extralite repository: https://github.com/digital-fabric/extralite
API docs: https://www.rubydoc.info/gems/extralite

Thanks,
Sharon