PHP and MySQL database connection the easy way

January 21, 2010

I’ve been using a very light weight extension of mysqli to connect to the MySQL database with PHP.  It is a mysqli wrapper class for using the Singleton database design pattern.
To use the:
1.  Change database configurations with login/pass in db.class.php
2. No need for error checking with query.  Exceptions will be thrown on error.
3. Everything else works like mysqli.
See [...]

Skills to Learn in 2010

January 8, 2010

High Frequency Trading
Statistical Abitrage
High Availibity and Clustering in MySQL
C# and .NET.  I’ve been avoiding the Microsoft centric languages, but resistance is futile.  Being on StackOverflow might have something to do with it.  Learning a new language is easy enough especially another C-like language.

Best Chocolate Chip Cookies Ever

January 6, 2010

I baked some cookies over the weekend and they were fantastic.

Ingredients

1 cup butter, softened
1 cup white sugar
1 cup packed brown sugar
2 eggs
2 teaspoons vanilla extract
3 cups all-purpose flour
1 teaspoon baking soda
2 teaspoons hot water
1/2 teaspoon salt
2 cups semisweet chocolate chips
1 cup chopped walnuts

Directions

Preheat oven to 350 degrees F (175 degrees C).
Cream together the butter, white [...]

postcrossing

December 23, 2009

Today I stumbled upon a site called postcrossing.com. It’s a postcard exchange community. The idea is interesting: send postcards out to people around the world and get postcards back from people around the world.
It’s a great way to collect postcards/stamps from around the world!
I have a friend who collects post cards and [...]

MySQL Certifications CMDEV and CMDBA

December 21, 2009

Today I completed the last of the 4 exams required to obtain the MySQL certifications. I am now a Certified MySQL Developer (CMDEV) and Certified MySQL DBA (CMDBA).

For more information about the certification you can go here.

Since, I signed a nondisclosure agreement before taking the exam, I’m not allowed to write about the [...]

Information is Beautiful

December 17, 2009

Came upon this Information is Beautiful.
Sometimes I wish I was more artistic.
The visualization tag on flickr is a great place to browse.

Simple way to remember SQL JOINs

December 16, 2009

Beginners to SQL often have a hard time remembering the differences between all the joins in SQL.  INNER JOIN is simple enough.  LEFT JOIN and RIGHT joins are harder.  LEFT JOIN and RIGHT JOIN are the same and depends on the ordering of the table in the FROM clause.  MySQL doesn’t implement the FULL OUTER [...]

MySQL index selectivity

December 15, 2009

Index are faster if the column is unique and NOT NULL.  This is the reason why primary indexes are UNIQUE NOT NULL.  The optimizer will avoid index if too many records are estimated to be returned by the condition and instead do a table scan.
Selectivity is defined as the percentage of distinct values in a [...]

Oracle Sun Merger heats up

December 14, 2009

Being a software developer, I dislike politics.  I don’t follow it in the news or on tv.  I dislike talking heads on TV disagree with one another for the sake of disagreeing with one another.  And I especially dislike politics in the office.  I’m a software developer let me solve problems and code.
Oracle bought Sun [...]

INFORMATION_SCHEMA helper

December 11, 2009

Is it just me so is INFORMATION_SCHEMA too long to type? INFO_DB would have been a more appropriate name. It’s in the SQL ANSI standard so INFORMATION_SCHEMA will last for a long time.
Amway, I’m tired of typing the same query over and over again to access metadata from INFORMATION_SCHEMA so I’ve created three [...]

← Previous Entries

Next Entries →

 

You need to log in to vote

The blog owner requires users to be logged in to be able to vote for this post.

Alternatively, if you do not have an account yet you can create one here.

Powered by Vote It Up