Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
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))

Well House Consultants
You are on the site of Well House Consultants who provide Open Source Training Courses and business hotel accommodation. You are welcome to browse and use our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources
Ruby module R117
Ruby GUIs, XML, SQL Database Connectivity
Exercises, examples and other material relating to training module R117. This topic is presented on public courses Learning to program in Ruby, Ruby Programming



Related technical and longer articles
Interfacing applications to a MySQL database engine
Graphic User Interfaces (GUIs)

Articles and tips on this subjectupdated
4679Reading in XML in Ruby with xmlsimple
The xmlsimple Ruby gem allows you to load in a file (or IO handle object or string) of XML as a multidimensional collection - hashes of arrays of hashes. There's a sample program here which includes this code to load the data from after __END__:   require 'xmlsimple'   info = XmlSimple.xml_in(DATA) If ...
2016-05-19
 
4006Ruby / SQLite3 example program, showing JOIN v LEFT JOIN
Ruby includes support for the SQLite3 database ... and SQLite is an excellent tool for developing and testing ("Spike solutions") your database structure and concepts before implementing a larger system. For a smaller and straightforward requirement, SQLite may be all that you require. Towards the ...
2013-02-16
 
2714A simple example - XML from a Ruby program
The REXML module is supplied with the Ruby distribution and provides a neat way of handling XML data in Ruby. There is a very wide range of methods available, though, and sometimes it's hard to see the wood for the trees. So here - to start - is the [full source] of an application which reads an ...
2010-04-10
 
1890MySQL 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 ...
2008-11-16
 
Examples from our training material
dbl   Using MySQL databases from Ruby
myrssfeed.xml   Sample XML data
tag2   SQLite example with table joins
tago   SQLite example
x1.rb   REXML - XML in Ruby - absolute basics
xmls.rb   XML in Ruby with xmlsimple gem
Background information
Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from [here].
Topics covered in this module
Ruby/Tk, Ruby/GTK, Glade, etc.
FOX and FXRuby.
VisualuRuby, SWin and VRuby.
SAX and DOM - XMLParser and others.
SQL and ODBC connection.
Using Ruby/DBI to connect to MySQL, Oracle, etc.
Complete learning
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Ruby, Lua, Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 700 books on the subjects on which we teach. These books are available for reference at our training centre.


You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2024: 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.info/resources/R117.html • PAGE BUILT: Sun Oct 11 14:50:09 2020 • BUILD SYSTEM: JelliaJamb