kemal-mysql

Easily add MySQL database to your Kemal application
0.3.0 Latest release released

kemal-mysql

Easily add MySQL database to your Kemal application.

Installation

Add this to your application's shard.yml:

dependencies:
  kemal-mysql:
    github: sdogruyol/kemal-mysql

Usage

This middleware adds MySQL connection pool to Kemal as a middleware.

require "kemal"
require "kemal-mysql"

CONN_OPTS = {
  "host" => "127.0.0.1",
  "user" => "root",
  "password" => "",
  "db" => "your_db"
}

mysql_connect CONN_OPTS, 25, 0.1

# Make sure to yield `env`.
get "/" do |env|
  env.content_type = "application/json"
  users = conn.query("SELECT * FROM users")
  # Release the connection after you are done with exec
  release
  # Renders the users as JSON
  users
end

You can configure the connection pool capacity and timeout like:

mysql_connect CONN_OPTS, capacity: 10, timeout: 0.1

The default value for connection pool capacity is 25 and timeout is 0.1.

Contributing

  1. Fork it ( https://github.com/sdogruyol/kemal-mysql/fork )
  2. Create your feature branch (git checkout -b my-new-feature)
  3. Commit your changes (git commit -am 'Add some feature')
  4. Push to the branch (git push origin my-new-feature)
  5. Create a new Pull Request

Contributors

kemal-mysql:
  github: sdogruyol/kemal-mysql
  version: ~> 0.3.0
License MIT
Crystal none

Authors

Dependencies 2

  • mysql~waterlink master
    {'branch' => 'master', 'github' => 'waterlink/crystal-mysql'}
  • pool master
    {'branch' => 'master', 'github' => 'ysbaddaden/pool'}

Development Dependencies 0

Dependents 0

Last synced .
search fire star recently