MySQL database from Ruby - an example

2b8c MySQL database from Ruby - an example

Training, Open Source Computer Languages

Perl •

PHP •

Python •

Tcl •

Ruby •

Lua •
- Learning to Program in Lua
- Lua Programming

C & C++ •

SQL •
- SQL - Programming and Admin

Tomcat •

Linux

MySQL database from Ruby - an example

Both MySQL and Ruby are huge subjects - the former being an excellent database engine and the latter a superb programming language. Yet although each individually is a huge subject, linking the two (i.e. accessing data stored in a MySQL database via a Ruby program) is so each that it's almost trivial.

Here's one way of doing it - my "Hello MySQL in Ruby" if you like.

1. Download the Ruby/MySQL module from http://www.tmtm.org/en/ruby/mysql/

2. Add the following lines (or equivalent) into your code:

require "mysql"

myconnect = Mysql::new("192.168.200.67", "trainee", "abc123", "forsale")

 

res = myconnect.query("select * from agents")

res.each do |row|

3. Enjoy!

The code loads in the module that you've downloaded (require), connects to the database engine and database (Mysql::new), runs the query (the query method on the connection object) and iterates through the result set.

The full source code of this example is here, and we cover the topic on our Ruby Programming course.
(written 2008-11-16)

Associated topics are indexed under

R117 - Ruby GUIs, XML, SQL Database Connectivity
  [4006] Ruby / SQLite3 example program, showing JOIN v LEFT JOIN - (2013-02-16)
  [2714] A simple example - XML from a Ruby program - (2010-04-10)

R119 - Ruby Miscellany
  [3799] Ruby Documentation through rdoc - (2012-07-07)
  [3783] Load path, load and require in Ruby, and a change from 1.8 to 1.9 - (2012-06-24)
  [3622] Loading Ruby classes - where does Ruby look? - (2012-02-24)
  [3428] How many days to Christmas? - (2011-09-09)
  [3155] Rake - a build system using code written in Ruby - (2011-02-03)
  [1889] Ruby mixins, modules, require and include - (2008-11-16)
  [1720] Some Ruby lesser used functions - (2008-07-26)
  [1586] Variable types in Ruby - (2008-03-21)
  [1181] Good Programming practise - where to initialise variables - (2007-05-09)

5641

Back to
Ruby mixins, modules, require and include

Previous and next
or
Horse's mouth home

Forward to
Ruby to access web services

Some other Articles

Shopping in Melksham
Some Linux and Unix tips
Melksham Chamber of Commerce and Industry
Ruby to access web services
MySQL database from Ruby - an example
Find the link
Ruby Programming Course - Saturday and Sunday
Keys to friendless churches
Hiding a MySQL database behind a web page

4086 posts, page by page

Link to page ... 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82 at 50 posts per page

This is a page archived from The Horse's Mouth at http://www.wellho.net/horse/ - the diary and writings of Graham Ellis. Every attempt was made to provide current information at the time the page was written, but things do move forward in our business - new software releases, price changes, new techniques. Please check back via our main site for current courses, prices, versions, etc - any mention of a price in "The Horse's Mouth" cannot be taken as an offer to supply at that price.

Link to Ezine home page (for reading).
Link to Blogging home page (to add comments).

You can Add a comment or ranking to this page

Public Training Courses

Running regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Like this? ??

Related short articles

Perl design patterns example

Python network programming - new FTP and socket level examples

Cacheing class for Python - using a local SQLite database as a key/value store

JSON from Python - first principles, easy example

Further recent PHP examples

Learning about Object Orientation in PHP - a new set of examples

Sessions, forms and validation in CodeIgniter - early examples

A couple of new fast-start PHP examples

Using Pygments to colour our training examples

Exception, Lambda, Generator, Slice, Dict - examples in one Python program

Really Simple Class and Inheritance example in Python

SQL databases from Python - an SQLite example

Spike solution, refactored and reusable, Python - Example

Clear, concise examples - Ruby classes and objects.

Reading and checking user inputs - first lessons - Ruby

Which database should I use? MySQL v SQLite

Web and console - same principle, same code - Ruby example

Upcoming courses at Well House Manor - Ruby, Python, Perl

Extended and Associated objects - what is the difference - C++ example

Our examples work with any recent version of PHP

Zend / layout of MVC and other files in an example application (PHP)

PHP revision ... by example.

The components of an Apache httpd / Tomcat / MySQL stack and what each does

Inheritance, Composition and Associated objects - when to use which - Python example

Formatting output - why we need to, and first Python example

PHP sessions - a best practice teaching example

A year ago today, a server upgrade and a new Perl example

When you should use Object Orientation even in a short program - Python example

Standard methods available on all objects in Ruby

Private, Protected, Public in Ruby. What about interfaces and abstract classes in Ruby?

Ruby of Rails - cleanly displaying model data in the view

Adding validation to form entries and sticky fields - Ruby on Rails

Providing a form to allow the user to add data to the model - Ruby on Rails

Multiple views in a single appication - sharing common parts of the template - Ruby on Rails

Ruby on the web - a simple example using CGI

Hello World - Ruby on Rails - a checklist of each step

Muttable v immutable and implications - Ruby

Spike solutions and refactoring - a Python example

Why you should use objects even for short data manipulation programs in Ruby

Ruby - standard operators are overloaded. Perl - they are not

Ruby - a teaching example showing many of the language features in short but useful program

Ruby on Rails - how it flows, and where the files go

Refresh and Revision training class days - Perl / PHP / Python / Lua / Ruby / Tcl / C / C++

A Complete makefile example

Defining database relations in your Django model

Some TestWise examples - helping use Ruby code to check your web site operation

Matching regular expressions, and substitutions, in Ruby

Ruby v Perl - a comparison example

lists and struct::list in Tcl - Introduction to struct::list and examples

Tcl - dicts - a tutorial and examples

Easy session example in PHP - keeping each customers data apart

Learning to program in PHP - Regular Expression and Associative Array examples

Operator Overloading, Exceptions, Pointers, References and Templates in C++ - new examples from our courses

Databases - when to treat the rules as guidelines

Tkinter - an easy to use Python Graphic User Interface - introductory examples

Vintage Bus Running Day in Warminster. An example of good bus practise.

MySQL, MySQLi, PDO or something else - how best to talk to databases from PHP

Sorta sorting a hash, and what if an exception is NOT thrown - Ruby

Ruby at both extremes of your website

Sigils - the characters on the start of variable names in Perl, Ruby and Fortran

Searching through all the files in or below a directory - Ruby, Tcl, Perl

Automed web site testing scripted in Ruby using watir-webdriver

Divide 10000 by 17. Do you get 588.235294117647, 588.24 or 588? - Ruby and PHP

Assigning values to variables within other statements - Ruby

Ruby off the Rails?

Blowing our own trumpet - MySQL resources

List slices in Python - 2 and 3 values forms, with an uplifting example

Reading the nth line from a file (Perl and Tcl examples)

Do I need to initialise variables - programming in C, C++, Perl, PHP, Python, Ruby or Java.

Files or Databases? MySQL, SQLite, or Oracle?

Alternative Vote (AV) - explaining and an example

Ruby - a training example that puts many language elements together to demonstrate the whole

All possible combinations from a list (Python) or array (Ruby)

Process every member of an array, and sort an array - Ruby

Multiple inputs, multiple out, ruby functions

Is this number between? Does this list include? - Ruby

Using functions to keep look and feel apart from calculations - simple C example

Tcl - Some example of HOW TO in handling data files and formats

Rekeying a table - comparison in #Ruby #Perl and #Python

Extra courses - Advanced PHP, MySQL and Lua

4a6

© WELL HOUSE CONSULTANTS LTD., 2013: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 899360 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/mouth/1890_MyS ... ample.html • PAGE BUILT: Sat Feb 23 12:39:13 2013 • BUILD SYSTEM: wizard

0