A couple of weeks ago I received my sticker from the master dealer, Juergen, so I thought I'd share my pimped up laptop, complete with sticker friend.
|Pimp my laptop|
And now I also learn (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 ------------ ------- TABLE 17 INDEX 28 SEQUENCE 5 TRIGGER 14 LOB 9 FUNCTION 2
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
gem install thin
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:
Fetching: eventmachine-1. (more...)
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:
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
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.
On my play environment I usually use Oracle APEX with the Embedded PL/SQL Gateway, just because it's so easy.
When a new version of APEX is released, just like everybody else, I upgrade my play environment.
After the apexins.sql script is run, I always want to start playing with it immediately. Usually it is at this point where I just see a blank page... scratching my head wondering why it is not running,... having (more...)
- Table Functions: Introduction and Exploration, Part 1: skizziert die vorgesehene Struktur der Artikelserie und erläutert zunächst das Grundkonzept von table functions: der table (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.
Feel free to ask questions!
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
1 2 3 4 5
# Import sys library. import sys # Print the Python version. print sys.version
You can run the
version.py program dynamically like this:
It will print the (more...)
Most folks know how important JSON is to web development but (more...)
After you install Ruby and build the Rails framework, you need to create the
mysql gem. This blog post shows you how to create the
mysql gem and how to write a simple Ruby program that queries the MySQL database.
The first step creates the
mysql gem for Ruby programming:
yum install mysql
It should show you the following:
Fetching: mysql-2.9.1.gem (100%) Building native extensions. This could take (more...)
Just been tearing my hair out on some unexpected SQL behaviour in SQL Developer.
Eventually I managed to get to the root cause of the problem as illustrated below.
SQL> var ps number SQL> exec :ps := 4001644945; PL/SQL procedure successfully completed. SQL> select :ps from dual; :PS ---------- 4001644945 SQL>
SQL Developer v3.2 and v4.0 via “Run As Script(F5)”:
var ps number exec :ps := 4001644945; select :ps from dual; anonymous (more...)
I watched and listened to Shakeeb Rahman from the APEX team on an ODTUG webinar, which was recorded and available for ODTUG members.
I did, however, take some notes. I thought I'd share:
Not shy about reference to Douglas Adams.
Theme can be (more...)