Training, Open Source Programming Languages

Print friendly page
Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
Python and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for 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
R117 - Ruby GUIs, XML, SQL Database Connectivity
  [4679] Reading in XML in Ruby with xmlsimple - (2016-05-18)
  [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)


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

Like this? ??

Related short articles
Python examples - updates under way
When to check an object type - Python isinstance example
with in Python - examples of use, and of defining your own context
Real life PHP application using our course training MVC example
One line scripts - Awk, Perl and Ruby
Ruby testing with RSpec - a new example
Processing data line by line - iterator in Ruby with yield
Expect with Ruby - a training example to get you started
Running shell (operating system) commands from within Ruby
Exceptions in Ruby - throwing, catching and using
Alternating valuses / flip-flop / toggle - example in Ruby
Separating detailed data code from the main application - Ruby example
Ruby training, half a world away
Recursion in Python - the classic example
Unique word locator - Python dict example
Object and Static methods - what is the difference; example in Python 3
What are callbacks? Why use them? An example in Python
String handling in C - new examples of extracting integers from a string
Singleton design pattern - examples and uses
Perl 6 - a Practical Extraction and Reporting example!
Pytest - second example beyond hello world
Pytest - starting example
XML handling in Python - a new teaching example using etree
Thin application, thick objects - keep you main code simple. Example in Ruby
Easy example - data record to object and object to data record mapping in Ruby
Behaviour and test driven development in Ruby using RSpec
Perl, PHP, Python, Lua, Tcl, C++, Ruby - final public courses for 2015
RUby - loading, using, changing, storing JSON format data
Build up classes into applications sharing data types in Ruby
RSpec - Ruby testing (stand alone example / no cucumber)
example of SQLite using a local database file through SQLalchemy
SQLAlchemy - first examples with a Python Object Relationship Mapping system
Tcl - a new example for data reformatting
Throwing a die - exercise in Ruby
Regular Expressions for the petrified - in Ruby
Where does Ruby load modules from, and how to load from current directory
Separating your code for easier testing, understanding and re-use; example in Ruby
Reading and parsing a JSON object in Ruby
Significant work - beyond helloworld in Ruby
Ruby - where one statement ends and the next begins
Forgotten / lost MySQL root password
Starting MySQL. ERROR! The server quit without updating PID file - how we fixed it.
Moving from mysql to mysqli - simple worked example
Extracting data from backups to restore selected rows from MySQL tables
Using Object Oriented Tcl and the Tk toolkit together - real life example
A new Tcl/tk example - a window to show system status
Test framework for TCL - Tcltest - some examples
Objects in Tcl - iTcl - updated first steps example
Accessing a MySQL database from Python with mysql.connector
Java example - for loop and conditionals from course exercise
Java Inheritance example - group of classes - step by step
A good example of recursion - a real use in Python
Setting up and using a dict in Python - simple first example
Fixing damaged MySQL tables - Error 1712 and Error 2013
Finding sum, minimum, maximum and average in Python (and Ruby)
Java Utility class - flexible replacement for array. Also cacheing in objects and multiple catch clauses example.
Philosophy behind object design - and how I applied in to a Java example
Checking MySQL database backups have worked (not failed)
Cucumber example - test::unit, scenario outlines, datafile driven test
Global Regular Expression matching in Ruby (using scan)
Installing Cucumber (Ruby)
Behaviour Driven Development / Ruby and Cucumber
Final examples for 2014 - and a look at our 2015 training course options
Conditionals, loops and methods in Ruby - a primer with simple examples
Ruby - the second rung of learning the language
Shuffling a list - Ruby and Python
A behaviour driven example of writing a Java program
Python base and inherited classes, test harness and unit testing - new examples
Simple C structs - building up to full, dynamic example
Test Driven Development - a first example of principle in C
Java - factory method, encapsulation, hashmap example
An example of Model-View-Controller techniques in a Perl / CGI script
A bright new gem - updated Ruby training
Lazy operators in Lua - what they mean, and examples
Python, PHP, Ruby, C, Lua, etc ... course prices held for the rest of 2014
Lists in Tcl - fundamentals in a commented source code example
Tcl + Tk (Wish) - an introduction and revision example
Endorsed Perl, Python and PHP training - Tcl, Lua, Ruby and C too!
Public courses - Python, PHP, Perl, Ruby, Lua, Tcl, C and C++ - autumn 2013 and through 2014
Perl design patterns example
© WELL HOUSE CONSULTANTS LTD., 2019: 404 The Spa • Melksham, Wiltshire • United Kingdom • SN12 6QL
PH: 01225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/mouth/1890_MyS ... ample.html • PAGE BUILT: Sat May 27 16:49:10 2017 • BUILD SYSTEM: WomanWithCat