{"repo":"elixir-ecto/myxql","free":true,"listed":false,"github":"https://github.com/elixir-ecto/myxql","clone":"git clone https://github.com/elixir-ecto/myxql.git","description":"MySQL 5.5+ driver for Elixir","language":"Elixir","stars":298,"topics":["elixir","database","mysql"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"MyXQL MySQL driver for Elixir. Documentation: Features Automatic decoding and encoding of Elixir values to and from MySQL text and binary protocols Supports transactions, prepared queries, streaming, pooling and more via DBConnection Supports MySQL 5.5+, 8.0, and MariaDB 10.3 Supports mysql native password , sha256 password , and caching sha2 password authentication plugins Usage Add :myxql to your dependencies: Make sure you are using the latest version! It's recommended to start MyXQL under supervision tree: and then we can refer to it by its :name : Mariaex Compatibility See Mariaex Compatibility page for transition between drivers. Data representation MySQL Elixir ------------------------- ------------------------------------------------- NULL nil bool 0 , 1 int 42 float 42.0 decimal #Decimal (1) date D[2013-10-12] (2) time T[00:37:14] (3) datetime N[2013-10-12 00:37:14] (2), (4) timestamp U[2013-10-12 00:37:14Z] (2), (4), (7) json %{\"foo\" = \"bar\"} (5) char \"é\" text \"myxql\" binary bit point , polygon , ... %Geo.Point{coordinates: {0.0, 1.0}}, ... (6) Notes: 1. See Decimal 2. When using SQL mode that allows them, MySQL \"zero\" dates and datetimes are represented as :zero date and :zero datetime respectively. 3. Values that are negative or greater than 24:00:00 cannot be decoded 4. Datetime fields are represented as NaiveDateTime , however a UTC DateTime can be used for encoding as well 5. MySQL added a native JSON type in version 5.7.8, if you're using earlier versions, rem","default_branch":null,"files":null,"tree":[],"storefront":"/r/elixir-ecto","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/elixir-ecto/myxql/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}