Skip to content

Instantly share code, notes, and snippets.

@melnikaite
Created October 13, 2016 07:31
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save melnikaite/57f19144b07f92e636a917b04fda5dd5 to your computer and use it in GitHub Desktop.
Save melnikaite/57f19144b07f92e636a917b04fda5dd5 to your computer and use it in GitHub Desktop.
enable JSON functions in SQLite
# To enable JSON functions in SQLite run in irb
require 'sqlite3'
c = SQLite3::Database.new('database')
c.enable_load_extension(1)
c.load_extension('/usr/local/Cellar/sqlite/3.14.2/lib/libsqlitefunctions.dylib')
# To install SQLIte with JSON extension on OS X run
brew install --with-functions --with-json1 sqlite
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment