Popularity
9.2
Growing
Activity
2.9
Growing
118
7
25
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.
-
crystal-monetdb-libmapi
Crystal bindings for MonetDB
Static code analysis for 29 languages.
Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
Promo
www.sonarqube.org
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.