Skip to content

Roger Hosto

Good Talk

Menu
  • Home
  • Blogs
    • Databases Administration
      • MySQL
      • NoSQL
    • Development
    • Open Source Software
    • System Administration
  • Resume
  • About
Menu

Author: webgeek

Using CURL to manage Tomcat

Posted on June 21, 2011 by webgeek

The other day I and a few of my colleges were talking about a easy way to deploy and undeploy war files from the command line like you could through the Tomcat Web Application Manager portal and being on a python kick, I started writing it in python. After an hour or two I realized that…

Read more

Simple HTTP Server with Python

Posted on May 16, 2011 by webgeek

Ever needed a quick web server to share something with a Windows user from you Linux box.  Python has really easy to use embedded HTTP Server. Just try the following.shell> python -m SimpleHTTPServer 9001 And point you web browser at http://localhost:9001 and see what happens. — Cheers  

Read more

Slacking over the Holidays

Posted on January 15, 2011 by webgeek

So December was an interesting month for me, with a few changes in my personal career and the holidays. I take a week off. Which of course lead me spending two weeks catching up on work and to top it off my boss or someone above him decided that we need to take look at…

Read more

Connecting PHP to An Oracle Instance on RedHat or CentOS 5

Posted on November 19, 2010 by webgeek

Here lately it seems that everyone wants to connect to Oracle, but I have to admit this was the first time someone asked me to get PHP to talk to Oracle. It was a lot less painful then I thought it would be, so here is what I did. A long with the standard PHP…

Read more

Quick Start To Using MongoDB with Python on Linux

Posted on November 18, 2010 by webgeek

With it’s rapid growth in popularity MongoDB is quickly becoming one of the top NoSQL Databases out there and with Python being one of the top ten programming languages according to Tiobe Software’s Programming Community Index. I’ve decided to write a quick how-to to show you just how easy it is to get started with…

Read more

Connecting Python to Oracle.

Posted on November 7, 2010 by webgeek

In the current world of heterogeneous networks it seems that you need to be able to connect to ever type of database system out there. In a recent project, I was asked, to take an existing MySQL and Python system and get it to connect to an existing Oracle Data Warehouse system. To be honest,…

Read more

Why You Should Looking at Python.

Posted on November 5, 2010 by webgeek

Python is an interpreted, interactive, object-oriented programming language. Python includes modules, classes, exceptions, very high level dynamic data types and dynamic typing. Python has also been one of the top 10 programming languages, since May of 2004 according toTiobe Software’s Programming Community Index. Python is being used by some big named companies such as Google, Yahoo,…

Read more

Calculating The Percentage of Max Connections in with MySQL 5.1.9 and higher

Posted on October 25, 2010 by webgeek

For longest time it had bugged me that there wasn’t an easy way to put “SHOW STATUS”, “SHOW VARIABLES”, or “SHOW PROCESSLIST” variables into queries, so I could easily calculate stuff like max connections percentage. Then MySQL 5.1.9 came out and you could final start to do SELECT statements on information_schema.GLOBAL_STATUS, information_schema.SESSION_STATUS, information_schema.GLOBAL_VARIABLES, information_schema.SESSION_VARIABLES and…

Read more

MySQL Functions for Converting IP Address to an Integer and Back Again

Posted on October 14, 2010 by webgeek

So after my MySQL server-id idea. I was asked to come up with a function to Convert IP Address. So here it is. use test; DROP FUNCTION IF EXISTS IpToInteger; DELIMITER // CREATE FUNCTION IpToInteger ( ipAddress CHAR(15) ) RETURNS INT UNSIGNED DETERMINISTIC BEGIN DECLARE o1,o2,o3,o4 char(3); DECLARE IpInteger INT UNSIGNED; SET o1 = REPLACE(SUBSTRING(SUBSTRING_INDEX(…

Read more

Amazon Cloud Sends in the MySQL Clones

Posted on October 8, 2010 by webgeek

Amazon is making it easier, and cheaper, to roll out copies of MySQL for very large websites across its cloud. On Tuesday, the company announced an update to its Amazon Relational Database Service that will let users create and delete multiple Read Replicas of MySQL instances in minutes, via a point-and-click interface. Full Story Here

Read more
  • Previous
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • Next
  • Prioritizing Projects Effectively
  • Back to Basics: ORM and Its Impact on Database and Data Architecture
  • MySQL Error: 1062 'Duplicate entry' Error
  • Installing MariaDB 10.1 on CentOS 6.8
  • Linux Mint
  • LinkedIn
© 2026 Roger Hosto | Powered by Minimalist Blog WordPress Theme