db_json

Version, currently master branch1 version
  • master branchlatestJan 16, 2017

github.com/bcardiff/sample-crystal-db_json

Sample app for streaming db content as ndjson with crystal

6 stars
0 dependents
License: MIT

Installation

# Add this to your shard.yml
dependencies:
  db_json:
    github: bcardiff/sample-crystal-db_json
    branch: master

master is a branch, not a release, so this tracks it rather than pinning a version.

Then run:

shards install

shard.yml

Crystal
0.20.4
License
MIT
Author
Brian J. Cardiff
Target
  • db_json from src/db_json.cr

Dependencies

Runtime Dependencies

  • pg*github: will/crystal-pg
  • kemal*github: kemalcr/kemal
  • mysql*github: crystal-lang/crystal-mysql
  • sqlite3*github: crystal-lang/crystal-sqlite3

README

db_json sample application

Use ./db/seed-*.sh scripts to initialize a sample database for each driver. Build and start the app with the database_url as command line argument.

$ git clone https://github.com/bcardiff/sample-crystal-db_json.git
$ cd sample-crystal-db_json
$ ./db/seed-chinook.sh
$ crystal src/db_json.cr -- sqlite3://./db/chinook.db

Other connection strings

$ ./db/seed-sqlite3.sh
$ crystal src/db_json.cr -- sqlite3://./db/sqlite3.db
$ ./db/seed-mysql.sh
$ crystal src/db_json.cr -- mysql://root@localhost/db_json_sample
$ ./db/seed-pg.sh
$ crystal src/db_json.cr -- postgres://localhost/db_json_sample

Contributors

  • bcardiff Brian J. Cardiff - creator, maintainer