Installing MySQL Workbench from Source on Fedora 12
Here is a quick tutorial on how to install MySQL Workbench on Fedora 12, as there are some unique things you need before it will install correctly.
First, download the source code tar ball from dev.mysql.com here: http://dev.mysql.com/downloads/workbench
Next, unpack the tarball into a directory of your choice, open a terminal, and cd into that directory where you unpacked the source.
You will need root priviliges for the install so you can do so by running either su or sudo -s.
You will need to run the following command to install the librarys required by MySQL Workbench.
yum install libtool
libzip libzip-devel glib2 glib-devel2 libxml2 libxml2-devel libsigc++20 libsigc++20-devel libglade2 libglade2-devel gtkmm24 gtkmm24-devel libgnome libgnome-devel boost boost-devel libuuid libuuid-devel lua lua-devel pcre pcre-devel mysql mysql-devel
Next run sh autogen.sh
Then make
And then finally make install
If the whole process succeeded, the MySQL Workbench binary should be /usr/local/bin/mysql-workbench
Significant Figure Calculator
Here is a little calculator I wrote while I was at a conference this week. Nothin fancy but it will calculate a mathematical equation while taking into account the significant figures and precision of each number in the equation, rounding the final answer to the same precision as the number with the least precision in the equation.
http://mphwebsystems.com/SignificantFigureCalc/index.php
Enjoy!
Sending POST parameters via HTTP to a server in C#
Here is a C# Method for sending data to a server via POST.
You would call this method like this:
get_post_response("http://somesite/", "email=email&password=password")
If any of the characters in the params contain special characters (Such as $, #, @) you must call HttpUtility.UrlEncode() on each param or on the entire param string. Here is how you do that: http://www.vcskicks.com/encode-url.php
public static string get_post_response(string page_url, string page_params) {
var request = (HttpWebRequest)HttpWebRequest.Create(page_url);
request.CookieContainer = new CookieContainer();
request.CookieContainer.Add(session);
request.ContentType = "application/x-www-form-urlencoded";
request.Method = "POST";
byte[] bytes = Encoding.ASCII.GetBytes(page_params);
request.ContentLength = bytes.Length;
using (Stream os = request.GetRequestStream()) {
os.Write(bytes, 0, bytes.Length);
}
var resp = request.GetResponse();
CookieContainer cookieJar = new CookieContainer();
session = cookieJar.GetCookies(request.RequestUri);
Stream respStream = resp.GetResponseStream();
byte[] buffer = new byte[1024];
string text = "";
while (Convert.ToBoolean(respStream.Read(buffer, 0, buffer.Length)))
text += Encoding.ASCII.GetString(buffer).Trim('\0');
return text;
}
Enjoy!
Say thank you to our troops!
How to install Adobe Flash 10 on Slackware 13 for Firefox
The installation of adobe flash on Slackware is quite a simple process actually. It requires 4 steps.
First, open a terminal then type su to get a root shell.
Next run the following command to get the latest version of adobe flash 10 from adobe.
root@paulhenry-laptop:~# wget http://fpdownload.macromedia.com/get/flashplayer/current/install_flash_player_10_linux.tar.gz
Next uncompress the file you just downloaded.
root@paulhenry-laptop:~# tar -zxvf install_flash_player_10_linux.tar.gz
Then simply copy the uncompressed library file to the /plugins directory of firefox.
root@paulhenry-laptop:~# cp libflashplayer.so /usr/lib/firefox/plugins/
Restart (or start) firefox and look in Tools->Addons->Plugins and Shockwave flash should be installed!
Feel free to email me at paulhenry@mphwebsystems.com if you have any problems.
New forums!
Check out our new forms! Feel free to join up and post!
http://forums.mphwebsystems.com/
Also check out our project management suite: http://project.mphwebsystems.com/
If you would like an account on the project management suite, please email me at paulhenry@mhpwebsystems.com
Scoring?
Alright, so one of the major things that CMS will accomplish is the automatic scoring of a registered competition. How will CMS do this?
First of all, we can lay down some basic rules on how we get the total score for each team.
First: A team’s total score is the sum of all rounds by that team. This tells us that for each team, their competition score is the sum of the total score for all rounds played by that team.
Second: A round has one or more actions.
Third: Every competition has a registered number of actions per round.
Fourth: Each action contributes to each round’s total score.
All we really need to do to find out scores is just to define actions, and those actions will make up rounds, and those rounds will make up a team’s score.
Now we just need to lay down some rules about how special cases, like ties are handled. I am thinking an additional round will be added. Anything you all would suggest?
New Main Website design
Alight, so over the past few weeks, I have been monitoring the bandwidth usage for both blog.mphwebsystems.com and the main site, mphwebsystems.com and noticed one very interesting thing. There have been approximately 1,100 hits on the main site, and there have been 3,000 hits on the blog. Now, the really interesting part is the bandwidth used by both. The main site, with 1,100 hits, used 13 MB. The blog, with 3,000 hits, used 10 MB. The theme I have used for the main site is extremely heavy, with 1600 lines of CSS, and about 20 images. The theme used for the blog is very very light and simple, thus the lower bandwidth usage. Now what this shows, is that it really makes a big difference how your website is designed.
Because of this difference, I went ahead and decided to redesign the main site. The new design has 3 images, and 251 lines of CSS, much lighter and simpler. I think the hardest part of web development is finding the balance between size and “shinyness”.
CMS Database Design
Hi all, it has been a while since I posted something new. I have been on a trip fixing up a house, but hey! I have been getting lots of programming in during my free time.
I think I have pretty much finalized the database design for the Competition Management System that is under development. Here is an image:
cms_db.jpg
Everything grouped under Registered Competition Tables basically all depends on a single competition entry into the Competitions table. Notice the separate accounts table, every type of account, except for admins, is linked from that table to either a Competition entry, a school entry or a team entry via the links table. This also allows for multiple links from a single account.
CMS Developement has begun!
I have started work on CMS (Competition Management System). Its going to be a cool system! I am implementing Object Orientation into the PHP, like say you call a method and send that method a SQL script, it executes that script, and hands you back an object. It just puts another abstraction layer of the database communication.
If you would like to preview this system, while it is being developed, add a comment below, and I will get back with you! 