Connect with Ruby
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
SingleStore is wire-compliant with MySQL.
-
Standard Ruby
-
Ruby on Rails
Connect with Standard Ruby
For a complete example, including samples of CRUD operations, see GitHub.
Prerequisites
-
Ruby (version 2.
6. x or 3. x) -
mysql2
gem
Connection Details
To connect your Ruby application to your cluster, you'll need the following:
-
Host: the endpoint or IP Address of your SingleStore cluster.
-
Port: default is
3306
-
User:
root
-
Password
-
Database
Here is an example of a Ruby connection for a SingleStore cluster:
client = Mysql2::Client.new(:host => "localhost",:username => "root",:password => "<root password>",:database => "test")
For more examples, see Getting started with SingleStore stored procedures and Ruby.
Connect with Ruby on Rails
To connect with Ruby on Rails, configure your SingleStore.
Open config/database.
and edit the development adapter to use MySQL.show variables like 'socket'
.
$ mysql -u root -h 127.1 -P 3306 -e "show variables like 'socket'"
+---------------+---------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------+---------------------------------------------------------------------------------------+
| socket | /var/lib/memsql-ops/data/installs/MI85eaf8fca04849888be7f1a9a596210e/data/memsql.sock |
+---------------+---------------------------------------------------------------------------------------+
SingleStore can run queries using the mysql2
connector in controller code.mysql2
result, which can be converted to an array and easily displayed:
class WelcomeController < ApplicationControllerdef indexrender plain: ActiveRecord::Base.connection.execute('show databases').to_a.join(' ')endend
Last modified: December 14, 2022