Clarification needed on database busy/lock issue

[forthrin]

If requesting this server, all writes on the database from other connections get a "locked" exception until killing the server.

Occasional busy/lock exceptions on writes have also occurred when running simultaneous scripts to the same database.

If this by design? Or how to fix the code? Didn't see a mention of busy/lock handling in the FAQ.

require 'sinatra'
require 'sqlite3'

$db = SQLite3::Database.open("foo")
$db.results_as_hash = true

get '/' do
  $db.query('select * from bar')
end

On a side note, if querying select 1, the following error occurs.

Puma caught this error: undefined method `bytesize' for {"1"=>1}:SQLite3::ResultSet::HashWithTypesAndFields (NoMethodError)
puma/request.rb:370:in `block in fast_write_response'
sqlite3/resultset.rb:126:in `each'
rack/body_proxy.rb:41:in `method_missing'
puma/request.rb:369:in `fast_write_response'
puma/request.rb:260:in `prepare_response'
puma/request.rb:133:in `handle_request'
puma/server.rb:443:in `process_client'
puma/server.rb:241:in `block in run'
puma/thread_pool.rb:155:in `block in spawn_thread'