Popularity
9.3
Stable
Activity
4.1
Declining
146
11
28
Programming language: Crystal
License: MIT License
Tags:
Database Drivers
Latest version: v0.19.0
crystal-sqlite3 alternatives and similar shards
Based on the "Database Drivers" category.
Alternatively, view crystal-sqlite3 alternatives based on common mentions on social networks and blogs.
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
Promo
www.influxdata.com

Do you think we are missing an alternative of crystal-sqlite3 or a related project?
README
crystal-sqlite3 
SQLite3 bindings for Crystal.
Check crystal-db for general db driver documentation. crystal-sqlite3 driver is registered under sqlite3://
uri.
Installation
Add this to your application's shard.yml
:
dependencies:
sqlite3:
github: crystal-lang/crystal-sqlite3
Usage
require "sqlite3"
DB.open "sqlite3://./data.db" do |db|
db.exec "create table contacts (name text, age integer)"
db.exec "insert into contacts values (?, ?)", "John Doe", 30
args = [] of DB::Any
args << "Sarah"
args << 33
db.exec "insert into contacts values (?, ?)", args: args
puts "max age:"
puts db.scalar "select max(age) from contacts" # => 33
puts "contacts:"
db.query "select name, age from contacts order by age desc" do |rs|
puts "#{rs.column_name(0)} (#{rs.column_name(1)})"
# => name (age)
rs.each do
puts "#{rs.read(String)} (#{rs.read(Int32)})"
# => Sarah (33)
# => John Doe (30)
end
end
end
DB::Any
Time
is implemented asTEXT
column usingSQLite3::DATE_FORMAT_SUBSECOND
format (orSQLite3::DATE_FORMAT_SECOND
if the text does not contain a dot).Bool
is implemented asINT
column mapping0
/1
values.