Planning out my year, I decided to take the Oracle OCP and MySQL OCP exams. I checked for review books and was pleasantly surprised to find the soon to be released OCP MySQL Database Administrator Exam Guide (Exam 1Z0-883). However, I noticed that the book was actually prepared for the obsolete and discountinued Exams 1Z0-870, 1Z0-873, and 1Z0-874.
There isn’t an alternative review book for the OCP MySQL 5.6 Developer or Database Administrator (more...)
One of my students requested an option to the
bash shell. It was interesting to hear that he wanted me to instal the
zsh in my Fedora image.
This post shows how to add the
zsh to my Fedora image because I already release a new one for the term without the
zsh shell. You use the
yum utility as the
root user to install the
It should produce (more...)
Back in January 2014, I wrote a script to cleanup an Oracle
student schema. It worked well until I started using APEX 4 in my
student schema. You create the following 75 objects when you create an APEX 4 schema.
OBJECT TYPE TOTAL
Here’s the modified script that ignores the objects created automatically by Oracle APEX when you create a
Somebody suggested that I try out
thin, “A fast and very simple Ruby web server.” So, I thought it might be interesting to test, and a simplification over Rails to demonstrate an small Ruby MVC pattern.
thin seemed straight forward as a gem installation, like
The initial install didn’t work out of the box because I’d neglected to install the
gcc-c++ library. It raised the following errors:
From time to time, folks ask questions about how to solve common problems in Linux or Unix. Today, the question is: “How do I find a list of files that contain a specific string?” There are two alternatives with the
find command, and the following sample searches look for files that contain a
sqlite3 string literal.
- Search for only the file names:
find . -type f | xargs grep -li sqlite3
Or, the more verbose:
Last week I posted how to configure and test Ruby and MySQL. Somebody asked me how to handle a dynamic list of columns. So, here’s a quick little program to show how to read the list of column:
It turns out that configuring Perl wasn’t the last step for my student instance. It appears that I neglected to configure my student instance to support Java connectivity to MySQL. This post reviews the configuration of Java to run programs against MySQL. It also covers the new syntax on how you register a
DriverManager, and avoid Java compilation errors with the older syntax.
In prior posts, I’ve shown how to use Perl , PHP (more...)
Sometimes trying to keep a post short and to the point raises other questions. Clearly, my Python-MySQL Program post over the weekend did raise a question. They were extending the query example and encountered this error:
TypeError: range() integer end argument expected, got tuple.
That should be a straight forward error message because of two things. First, the Python built-in
range() function manages a range of numbers. Second, the row returned (more...)
Configuring Perl to work with MySQL is the last part creating a complete Fedora Linux LAMP stack for my students. Perl is already installed on Fedora Linux.
I’ve also shown how to use PHP, Python, and Ruby languages to query a MySQL database on Linux. After installing this additional Perl DBI library, my students will have the opportunity to choose how they implement their LAMP solution.
You can find the Perl version with (more...)
The Fedora Linux distribution installs Python 2.7 by default. Unfortunately, the
MySQL-python library isn’t installed by default. You can verify the Python version by writing and running the following
version.py program before installing the
# Import sys library.
# Print the Python version.
You can run the
version.py program dynamically like this:
It will print the (more...)