crystal-sqlite3
crystal-sqlite3 copied to clipboard
crystal-lang
SQLite3 bindings for Crystal
Versions older than 0.14.0 no longer compile on crystal 1.3.2, so they haven't been included.
This should cover the basics of how to use a newer version of SQLite on Ubuntu. I think it could be improved by covering the following, but I do think...
Support for virtual tables in `crystal-sqlite3` would be very useful. (See https://sqlite.org/vtab.html#implementation for docs) Specifically, it would be great to be able to define a virtual table in a Crystal...
The `create_function()` support exists, and was added in order to implement the REGEX() callback function. It would be very useful to have a documented Crystal interface to `sqlite3_create_function_v2()` that could...
Ref: https://forum.crystal-lang.org/t/upgrade-sqlite3-binding-version/3384/2?u=bcardiff
```crystal require "sqlite3" DBFILE = "test.db" db = DB.open("sqlite3://./#{DBFILE}") while true begin db.scalar("select padding from foo where id=#{Random.rand(100000000)}") # size matters! rescue DB::NoResultsError end end ``` grows beyond 32GB of...
As people can have no background in Ruby or Crystal, the following example will be more familiar to them coming from languages like PHP/... See also Issue https://github.com/crystal-lang/crystal-sqlite3/issues/32
Crystal 1.0.0 [dd40a2442] (2021-03-22) LLVM: 10.0.0 Default target: x86_64-unknown-linux-gnu sqlite3: version: 0.18.0 Running this code with query inside iteration, fails with `Invalid memory access` error: ```crystal require "sqlite3" DB.open "sqlite3://%3amemory%3a"...
Hi, The current `Exception.code` field return the primary result code. It would be nice to add a new field `extented_code`, using `sqlite3_extended_errcode()`. https://sqlite.org/rescode.html#pve
Added the support in a connection to load dynamic extensions like Spatialite
