MySQL database from Ruby - an example

Training, Open Source computer languages

Perl • Python • MySQL • Tcl • Ruby • C & C++ • Lua • Java • Tomcat • PHP • httpd • 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 16:21:07)

Associated topics are indexed under

R117 - Ruby GUIs, XML, SQL Database Connectivity
R119 - Ruby Miscellany

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
Ruby mixins, modules, require and include
Find the link
Ruby Programming Course - Saturday and Sunday
Keys to friendless churches
Hiding a MySQL database behind a web page

1975 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 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).

Public Course Enquiry / Booking

Courses that run regularly at our UK training Centre.
[Schedule] - [About] - [Book]

Related short articles

mod_proxy_ajp and mod_proxy_balancer examples

Summary of MySQL installation on a Linux system

Flash (client) to PHP (server) - example

Perl Socket Programming Examples

Ruby, Perl, Linux, MySQL - some training notes

Virtual Hosting under Tomcat - an example

Ruby to access web services

MySQL database from Ruby - an example

Ruby mixins, modules, require and include

Ruby Programming Course - Saturday and Sunday

Hiding a MySQL database behind a web page

Seven new intermediate Perl examples

Javascript/HTML example, dynamic server monitor

Starting Ajax - easy example of browser calling up server data

Pointing all the web pages in a directory at a database

More HowTo diagrams - MySQL, Tomcat and Java

Lua examples, Lua Courses

Clean code, jump free (Example in Lua)

Finding words and work boundaries (MySQL, Perl, PHP)

memcached - overview, installation, example of use in PHP

Apache httpd, MySQL, PHP - installation procedure

A short Perl example

addslashes v mysql_real_escape_string in PHP

PHP examples - source code and try it out too

Some Ruby lesser used functions

If you are learning Lua, here are some more examples

Virtual Hosting on Apache httpd - a primer example

Factory method example - Perl

Example of OO in Perl

String interpretation in Ruby

Some Ruby programming examples from our course

Variable types in Ruby

Ruby, C, Java and more - getting out of loops

Making PHP and MySQL training relevant to the course delegates

Database design for a shopping application (MySQL)

Joining MySQL tables revisited - finding nonmatching records, etc

Uploading to a MySQL database through PHP - examples and common questions

Trying out our Java examples on our web site

Java (JSP and Servlet examples) live on our server

Downloading data for use in Excel (from PHP / MySQL)

Handling Binary data (.gif file example) in Perl

Ongoing Image Copyright Issues, PHP and MySQL solutions

Java, sorting, ArrayList example, generics

Efficient PHP applications - framework and example

Some new C programming examples - files, structs, unions etc

Perl, PHP, Python, Tcl, Linux, MySQL, Ruby courses ...

Python Script - easy examples of lots of basics

Connecting to MySQL 5 from PHP on Mac OSX Leopard

Linux, PHP, Tcl, Ruby, C, C++ - last minute training course availability

MySQL - table design and initial testing example

Good, steady, simple example - Perl file handling

Using PHP to upload images / Store on MySQL database - security questions

Using a MySQL database to control mod_rewrite via PHP

MySQL joins revisited

GUI design - Sketch it out first! (Java / Swing example)

2008 course schedule - Perl, Python, PHP, Linux, Java Deployment, Ruby and more

Ruby, Ruby, Ruby. Rails, Rails, Rails.

An example of Java Inheritance from scratch

An example of Java Inheritance from scratch

Outputting numbers as words - MySQL with Perl or PHP

Bathtub example

MySQL - the order of clauses and the order of actions

Emailing as HTML (Web Page) - PHP example

HTML - example of a simple web page

Python GTK - Widget, Packing, Event and Feedback example

MySQL - Password security (authentication protocol)

mysqldump and mysqlrestore

Apache httpd , browser, MySQL and MySQL client downloads

Learnt in London - Ruby, Martini, Coral and the Core

Tomorrow's keywords - London, Training, Course, PHP, Ruby.

.pdf files - upload via PHP, store in MySQL, retrieve

Ruby's case - no break

Adding a member to a Hash in Ruby

Ruby - Totally Topical

Ruby v Perl - interpollating variables

puts - opposite of chomp in Ruby

Equality in Ruby - == eql? and equal?

Blessing in Perl / Member variable in Ruby

String duplication - x in Perl, * in Python and Ruby

Breaking a loop - Ruby and other languages

1st, 2nd, 3rd revisited in Ruby

Display an image from a MySQL database in a web page via PHP

The LAMP Cookbook - Linux, Apache, MySQL, PHP / Perl

Databases needn't be frightening, hard or expensive

A practical example of roles

Browser -> httpd -> Tomcat -> MySQL. Restarting.

Image maps for navigation - a straightforward example

Simple polymorphism example - C++

Viewing images held in a MySQL database via PHP

Planning a hotel refurb - an example of a Gant chart in PHP

Testing you Perl / PHP / MySQL / Tcl knowledge

Database design - get it right from first principles

Ruby course - oops - it's not happening

Python to MySQL

Checking for MySQL errors

Using a MySQL database from Perl

Key facts - SQL and MySQL

Saving a MySQL query results to your local disc for Excel

Giving the researcher power over database analysis

Combining similar rows from a MySQL database select

MySQL permissions and privileges

Javascript events - a good example

MySQL - JOIN or WHERE to link tables correctly?

SELECT in MySQL - choosing the rows you want

MySQL - a score of things to remember

Which MySQL server am I using?

Matching in MySQL

Database or Progamming - which to learn first?

Javascript examples (some PHP and MySQL too)

Central London Courses - Perl, PHP, Python, Tcl, MySQL

Oops - I got my initial database design wrong

Getting a list of unique values from a MySQL column

Getting your examples, my examples and the data files after your course

new 'Perl on the Web' example

Tcl/Tk (wish) Grid layout example

Examples - Gadfly, NI Number, and Tcl to C interface

Customer service - examples to warn us

The wrong MySQL

Current MySQL and PHP paths and upgrades

MySQL, Java, PHP and Linux - new technical articles

MySQL - Optimising Selects

MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN

example of Tcl namespaces and packages

mysql_connect or mysql_pconnect in PHP?

Present and future MySQL

MySQL - nuggets

MySQL - Pivot tables

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