Skip to content

jrobertson/drb_sqlite

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 

Repository files navigation

Introducing the drb_sqlite gem

Setting up the server

installation

gem install sqlite_server2018

require 'sqlite_server2018'

SQLiteServer2018.new(host: '127.0.0.1').start

Using the client

require 'drb_sqlite'

# Open a database
db = DRbSQLite.new 'test.db'

# Create a database
sql=<<-SQL
  create table numbers (
    name varchar(30),
    val int
  );
SQL
rows = db.execute sql

# Execute a few inserts
{
  "one" => 1,
  "two" => 2,
}.each do |pair|
  db.execute "insert into numbers values ( ?, ? )", pair
end

# Find a few rows
db.execute( "select * from numbers" ) do |row|
  p row
end

Observed:

["one", 1]
["two", 2]

Resources

sqlite sqlite3 gem drb_sqlite3 server sqlite_server2017 sql

About

Connects to a remote SQLite database (sqlite_server2018 gem).

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages