Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
For 2021 - online Python 3 training - see ((here)).

Our plans were to retire in summer 2020 and see the world, but Coronavirus has lead us into a lot of lockdown programming in Python 3 and PHP 7.
We can now offer tailored online training - small groups, real tutors - works really well for groups of 4 to 14 delegates. Anywhere in the world; course language English.

Please ask about private 'maintenance' training for Python 2, Tcl, Perl, PHP, Lua, etc.
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 as below, or enter http://melksh.am/nnnn for individual articles
R119 - Ruby Miscellany
  [1181] Good Programming practise - where to initialise variables - (2007-05-09)
  [1586] Variable types in Ruby - (2008-03-21)
  [1720] Some Ruby lesser used functions - (2008-07-26)
  [1889] Ruby mixins, modules, require and include - (2008-11-16)
  [3155] Rake - a build system using code written in Ruby - (2011-02-03)
  [3428] How many days to Christmas? - (2011-09-09)
  [3622] Loading Ruby classes - where does Ruby look? - (2012-02-24)
  [3783] Load path, load and require in Ruby, and a change from 1.8 to 1.9 - (2012-06-24)
  [3799] Ruby Documentation through rdoc - (2012-07-07)

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


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
4759 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, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96 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

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

PAGE: http://www.wellho.net/mouth/1890_MyS ... ample.html • PAGE BUILT: Sun Oct 11 16:07:41 2020 • BUILD SYSTEM: JelliaJamb