sqlite3-ruby

sqlite3-ruby copied to clipboard

ver1.5.0.rc1, execute method is 30% slower than ver1.4.4

1

Seems that `execute` method is 30% slower than ver1.4.4. ## Environment - macOS - macOS 13.0 Beta（22A5321d） - Apple M1 Max - Apple clang version 14.0.0 (clang-1400.0.29.102) - ruby 3.2.0dev...

Watson1978

Database#transaction always return true. This doesn't strike me as very helpful behaviour - it doesn't allow you to simply pull the result of the last SQL statement executed in the...

steveg-h

first naive implementation of virtual table

2

- see test/test_vtable.rb for example - only select is supported (update/insert is not yet implemented)

duhlin

Fix `get_boolean_pragma` comparison: - ### Problem `get_boolean_pragma` always returns true because the value returned from the db is an Int not a String. cc/ @rafaelfranca @casperisfine

Edouard-chin

exploding zipped rows to flatten them is unnecessary since `Hash[]` takes a 2-d array ``` ruby def ordered_map_for columns, row h = Hash[*columns.zip(row).flatten] row.each_with_index { |r, i| h[i] = r...

audibleblink

execute_batch returns the result of the last statement

1

Currently `execute_batch` always return `nil`. 1) Would it be better to return the result of the last statement instead? 2) Would it make sense to accept a list of statements...

donaldong

can't build gem on aarch64/Android/Termux/Ubuntu srv jammy 22.04LTS w/ Ruby 3.0.2

1

this is my learning-programming environment: aarch / Android / Termux / Ubuntu server jammy aka 22.04LTS Ruby 3.0.2 I tried the git version of rbenv, and discovered that NO version...

libweirdness

Track names of fns created on db instance

2

I have found that it useful to be able check whether a function with a particular name has been created on an instance of `SQLite3::Database`. In the sqlite_ext gem, I...

stevecj

BLOB-reading/writing can be done apart from SQL-Queries. --- EXAMPLE: .. filename = "test.png" stmt = db.prepare("insert into files (filename, data) values (:filename,:data)") stmt.bind_param("filename", filename) stmt.bind_zeroblob("data", File.size(filename) stmt.execute f = File.new(filename,...

tenderlove

Would be good to be able to pull the specific query that caused the error from the SQLException class. For example: ``` ruby begin ids = ids.join(",") db.execute("SELECT * FROM...

penguinpowernz