For 2023 (and 2024 ...) - we are now fully retired from IT training. We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk.
Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active!
I am also active in many other area and still look after a lot of web sites - you can find an index ((here)) |
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)
Some other Articles
Shopping in MelkshamSome Linux and Unix tipsMelksham Chamber of Commerce and IndustryRuby to access web servicesMySQL database from Ruby - an exampleFind the linkRuby Programming Course - Saturday and SundayKeys to friendless churchesHiding 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).
|